Can you detach or backup a database from SQL 2000 32bit and reattach or restore it into SQL 2005 64 bit on a new server and have it functional.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2315...
Hi,
Can anyone please tell me how to import text file in SQL 2005 64bit using BCP utility?
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23530358.html
Zones:
MS SQL DTSDate Answered: 07/10/2008 Grade: A Views: 163
Hello -
I am attempting to migrate some DTS packages from SQL 2000 to SQL 2005. I have used the wizard and migrated them to a dtsx file and I am attempting to use xp_cmdshell when i run the foll...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23469031.html
I am having issues making a copy of a database within sql2005.
If i use the copy wizard and use the detach and attach method then the process works ok.
If i use the sql management method the proc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2356...
hi
When I run a openrowset in T-SQL I recieve this error:
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"
I am trying to open a text file in T...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23528248.html
