But the type changed the result - DELETE TABLE will not work.

The point is not the point<grin> I use this as a way to point out deficiencies in my knowledge. It gives me a headache trying to figure out where I...

I executed on SQL 2008, SQL 2008R2 and SQL 2012 - I got 6 different random numbers in all 3 test environments. I then started running the query against different...

arggg... I knew the answer - it's not an index, but creating a primary key does create a corresponding index (if it doesn't already exist). I better cut back on...

Logged onto dev server, created new package with script task - very simple "Hello World", runs in Debug. Will not run using Execute Package Utility. Changed package type from DTSDesigner100...

Will do - thanks.

Yes - Integration Services, Data Tools, complete Management Tools, and the Client Tools SDK also. I have at least a dozen other packages that are running on the server. The...

I'm troubleshooting the same problem for a developer. The majority of the cases I've found are solved by reinstalling SSIS and SSDT with all patches.

Good one - had forgotten about the column list:)

I know - the super-secret option Ignore Truncation was set:w00t:

Definitely have to slow down and read ALL the answers:)

Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.

The code won't execute. Create Proc has to be the first statement.

Thanks for your reply. The job is enabled and the support staff for the host can run it successfully. There is no history when I attempt to start it since...

How about writing a script to add their logins to the database? They should then be able to run the script after the restore. It would look something like

-- Add...