PaulB » Databases are handled by SQL Server instances.

PaulB » SQL Server instances are handled by Operating System

Hi PaulB,

This I know. I am new to multiple instances on one server...

Hi,

I thoroughly recommend the SQL Cookbook from O'Reilly. It's not too bad for beginners of SQL and it gives each 'recipe' in 5 flavours of SQL (Oracle, DB2, Transact...

Hi,

The first thing that comes to mind is that you are asking someone to do your work for you.

The second thing that comes to mind is that...

I could, I suppose. The problem is that, aside from malevolent external intervention, the only people who have such write-access are the DBAs and the Sysadmins and none admit to...

Thanks very much for the script! It is extremely useful and it's good to learn about new DB objects. I see now that I'm much more ignorant about traces than...

You can do it simply by dropping/deactivating all logins and all of their associated users. Why you would want to do it, however, I'm not sure.

Wouldn't shrinking the DB also reclaim the space lost by the dropped column?

[font="Verdana"]Thank you very much for the function, sir, you've saved me an hour or two this morning! Many Thanks, Seán.[/font]