Viewing 9 posts - 31 through 39 (of 39 total)
You need to drop the primary key constraint first and then re-create it with a new column added to the primary key
October 12, 2011 at 6:04 pm
Do you have enough space on the C:\ drive
October 12, 2011 at 5:43 pm
You can set "On Success action" and "On Failure action" for each job step
October 12, 2011 at 5:41 pm
You neede to have BIDS installed to design SSIS packages though BIDS is also a part of Visual Studio family.
October 12, 2011 at 5:34 pm
Try taking the backup on the local drive rather than network path and see if it is a issue with the database or the network
September 22, 2011 at 1:31 pm
You can select all jobs at once (from SSMS) and script them out.
September 22, 2011 at 10:54 am
Yes, both collations mean the same.
September 22, 2011 at 10:27 am
Have you followed this article - http://msdn.microsoft.com/en-us/library/ms190673(v=sql.90).aspx
Have you looked at the error logs to see - "Address Windowing Extensions enabled."
September 22, 2011 at 10:16 am
Viewing 9 posts - 31 through 39 (of 39 total)