Sure it can. I moved more than 100 DTS packages from one production server to another simply by moving the msdb database and then making a few edits to the...

I like that much better!! If you execute the DTS Packages via DTSRUN.exe, it is simple to pass in global variables as parameters that are set at run time within the...

In my opinion, a DTS package is not portable unless the server from which it is moving can be taken completely out of the picture. This actually creates more overhead,...

Another reason not mentioned in the article why every table the developers want to add to the databases in the systems I administer ........ merge replication. We are merge replicating...

Sounds like a problem with your application, not SQL Server.

One prefix that I want to throw into the mix is "NFR_". Yes, I know it has an undescore which I said I hated earlier. Any table that we do...

I prefix all of my views with 'vw' and make the same requirement of the developers where I work. The main reason you would want to add a prefix is...

That question would probably fool more people if it didn't say that the category is humor.

And I agree with Jeff about agreeing with Kenneth.

Yeah, I'm glad you mentioned that!! It's something people tend to not think about and then they wonder why it worked in development or test (with 1 user) and doesn't...

I agree that this should be getting treated as 3 separate fields, not 1.

Nonetheless, a simpler variation of the above "Replace" solutions would be to remove all commas and then...

What is the error and what is the actual query that is experiencing the error?

The only issue with indexing any variable length field (varchar, varbinary, etc.) is that it can't...

I would say that you should only add it if you think it needs to be monitored or if the time stamp data would be important. For example, I wouldn't add...

How dare you correct me!!!

Just kidding. Thanks, I did leave a...

Use the Ceiling() function. It rounds up to the next whole number. Floor() always rounds down to the next number.