Good suggestions above, I'd be sure you get a server class machine, use RAID, at least RAID 5 for the data storage. If you can afford to add in 2...

The worksheet name is the table name, so if you name your worksheet and then create the table to match, it works fine. I've also done the "drop table" as...

I've heard great things about sqlSentry and people do seem to love it, but it can get expensive.

Reporting a negative is something I've done on a homemade exception report. I...

Thanks for the notes and those 3 (2150, 2153, 3054) have been added.

Also added a CSV to the article so you can download the list. I'll try to keep it...

Better to have two Steve's and let them watch each other.

And if anyone needs an escort at a conference, grab myself, Andy, Brian, or one of our well known authors...

Adam,

Haven't taken it, but pass percentages seem to be about 850 or so and the # of questions is usually 52. I took the 444 exam and it was standard...

You can also use the FileSystemObject in DTS (ActiveX) task to do this.

I think you can make this person an owner of the dbo schema as well.

Search this forum and the MS one and you'll likely find some interesting problems to solve. There are also a few DTS articles on this site you can read.

I tried it years ago in the floppy era and it worked a few times for me. Haven't messed with it since then.

sp_help_revlogin from Microsoft. Search for it there for 2005. I think we might have the original version for 2000 here.

Yep, saved it: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1711

The syntax changed slightly for 2005.

Use this on...

Jeff's got great advice here and I agree with him. If this server is used by a few people it might be ok, but 1GB of RAM is pretty low....

Biggest thing for me is on-site shower. Nice to be able to run/bike/basketball/soccer, etc. and get clean after lunch.

Sorry, I know I saw it somewhere, but I must have grabbed the wrong URL. Still looking.

Sorry for missing this the other day.

We did it by creating two tables. One for things you add from the site and one for things we add, like purchased products....