If it's in the current folder, run sqlservr.exe -m only.

If you have auto statistics set, then SQL Server will calculate them. I think this is done when you create the index, but I'm not 100% sure. You can force...

Not sure what you mean? Your question is not clear.

Why not use DTS? Insert to a staging table, very quick, then run cleanup on it.

YOu might need to include the domain in your typing.

Actually I'd argue that most of that stuff is just left in because it works. It's not anyone working the stored procedures that work and aren't called often.

Though I do...

Unless you are using 6.5, doesn't make sense to look back at this version or the changes in 7.

And Books Online for each version has this information.

Thanks, actually hit 600,000 this week (Jan 12, 2008)!

Good point on the insurance. Be sure that you carry some. It's not that expensive, but it's required by some companies that hire you and it's a good idea in...

I tend to agree with Bob that lower prices works and it gives them an advantage, though I'm not sure it's good overall for the world.

I think in the US,...

I bet Terry Bradshaw is good. I almost laugh out loud every Sunday when he's on.

That's really it. Your options are as you've outlined.

It shouldn't be a problem with the upgrade as you're really running the same version, just changing features. Whether you uninstall or...

Best thing I could recommend is to use the Upgrade Advisor. I know there's not usually a lot of work done to move from 2 versions back.

Roy's solution is interesting. How should the user create a view without seeing the table?

Why not just have them request a view from the DBA? Surely they're not doing this...

Please be sure you click "Add topic" and not "add poll".

How is the person connecting to SQL Server? If it's windows authentication, then you can use suser_sname(). If it's SQL...