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...

Enjoy! and Happy Pongal!

No, the engine has to know where to put the pages.

Restore as one file, then create new filegroups and files and move the data (by recreating clustered indexes) in the...

1 - assign the users the db_backupoperator rights

2 - It can. If the Windows group has been granted the sysadmin role, they do. This is set up by default, but...

You could just need that much tempdb space. It all depends on your queries. It's used for sorting, etc.

You can shrink it down, but it could grow right back...