The error from the OS is a simple error that means what it says. There is not enough space. If you get any errors that have OS Error in them,...

http://msdn.microsoft.com/en-us/library/ms188004%28SQL.90%29.aspx

The link provided will help you script out the users and passwords, which you can then run on the new server.

do you mean for all rows? If so, you can do a SELECT and use the + operator to concatenate fields.

SELECT name + CHAR(13) + class + CHAR(13) +...

DATEADD is the way to pick the dates based on today, as ALZDBA has mentioned. You can read more about it here:

http://msdn.microsoft.com/en-us/library/ms186819%28SQL.90%29.aspx

I agree with Jack. Why do you need to loop?

If you are working on position, you would have to have some column that lets you now what order is where. Once data is in SQL Server, it has no...

It's an interesting question to ask of people. I think that we are all givers and takers, but at different points in our careers. I know many people that don't...

I tend to agree with Gail that I'd just index the fields. If there are specific values that you need to pull out, you could add a computed column that...

As Bru mentioned, you haven't joined TableA, so you might end up deleting everything in that table. Only one table is affected, but how it is affected depends on your...

Nice names, and "No RBAR" might be the best one for a boat. Thanks, Jeff.

Thanks, and I appreciate the kind words. I'm enjoying this now, and while I do think about leaving at times, I still enjoy this and the personal answer I keep...

You can use the RESTORE commands from SQL to get this information, like FILELISTONLY (http://msdn.microsoft.com/en-us/library/ms173778%28SQL.90%29.aspx)

exec xp_sqllitespeed_version should give you the version, which you likely will need.

to send the files...

the dateadd is not commented out, just the note.

SQL is only precise to .0, .3, and .7ms, therefore you can't have .1 as the answer. It could only be one...

Good article, Seth, and a nice explanation of the issue. It's not always easy to do things up front, especially when you have business reasons for not putting resources into...