Alternatively, to keep all your old versions under the new name, you can update the sysdtspackages table in msdb.

If you take the package GUID (available from the package properties), you...

I take it this is what happens when a DBA has too much time on his/her hands!

Merry Christmas everyone!

"... dont rush, and follow EVERY step maticulously" 

I certainly agree with you there Vinny!  And I'll remember that the next time I'm involved in this process.  Unfortunately I wasn't...

Brian,

Thanks for the reply.  To clarify our position, we're installing SQL Server (not a service pack) as a clustered instance.  It just so happens that we've managed to resolve the issue. ...

I underwent a similar task not long ago.  I did a lot of searching to see whether it was possible to "convert" a default instance to a named instance.  Unfortunately...

Don't forget to actually back up the log before you truncate it!

Hans,

Funny situation this.  I did the very same thing as you, created a system DSN on the server, went into QA, entered the syntax and came back with exactly the...

You can pass parameters to your stored procedures at the end of your exec statement.  You just need to join the strings together.  For example,

"EXEC SPR_S_FreedomTest '" & DTSGlobalVariables("gvParameter1").Value &...

Hans,

It sounds to me as though you need to create the DSN on the same machine as the SQL Server.  Any DSNs you create are stored on your local PC,...

I always get confused when looking at some of the syntax in BOL, especially when you get braces and brackets all over the show. 

Basically, anything contained within braces {}...

Actually it would be 2005-07-25 12:08:44.440 because datetime is precise to only 1/300 of a second.

How do you know this stuff, Remi ??

I did say it was a crude method !!

Christopher - What Sushila has said is absolutely correct, and I would advise using a default constraint as opposed to a Check constraint in your circumstance. 

I may be wrong...

Bit of a crude method perhaps, but I've known a lot of people to use MS Access to generate reports based on their SQL databases.  Dead easy to use, customise,...

Hi Erik,

Seems to me as though you just need to use a simple SELECT INTO statement.  Try the following:

SELECT Col1, Col2, Col3, Col4 INTO TableB

FROM TableA

This creates a permanent table...