Wednesday, January 31, 2007
One question which comes into mind immediately is, what if DB is set to SQL 2000 compatibility level? Compatibility level is for client connection behavior. On-disk it is still SQL 2005.
One solution is to create the database manually, create objects and use SSIS/DTS/BCP to transfer the data.
With SQL Server 2005, xp_cmdshell is disabled by default
To enable this feature:
Option 1: Using T-SQL
--Enable the feature
EXEC sp_configure 'xp_cmdshell', 1
-- To update the currently configured value for this feature.
Option 2: SQL Server 2005 Surface Area Configuration tool
From Surface Area Configuration Tools -> Choose “Surface Area Configuration for Features” > Check “Enable xp_cmdshell”