Did the server reboot or SQL restart? I wouldn't expect this to reboot the server.

Ouch, questionable quality?

Some typos and perhaps some you don't agree with, but I'd like to think there aren't that many.

I'm happy to correct our mistakes, as I'm happy to admin,...

Apologies everyone for selecting the incorrect answer. Somehow in the cut and paste and answer load I picked the wrong one. Guess I'm not so good at the question loading.

Points...

Need an external control to do this. You could use sp_oacreate to instantiate some COM object that can handle this. Or run a program from DOS and pipe the output...

Sorry to disagree, but on a fresh install of SQL 2000, nothing changed, creating a table like this allows NULLs. Perhaps this depends on the config of the base OS,...

There is not version fo SQL Server that's a "client". There are eval versions available from http://www.microsoft.com/sql you can use at home.

It will compile the first time and that is all.

If you have a linked server, then it's pretty simple. Same process, just include the server and database name wiht the owner and table name.

Otherwise, DTS might be the...

Good questions. You should be able to query syspermissions and see things in there for your UID. Perhaps EM will let you see a limited view for what you have...

Each is only compiled the first time, or when it's not in cache. These aren't grouped in any way other than similr naming as far as I know.

I assume you mean new rows in the Notifications table, not columns.

Off the top of my head, I don't see a better solution. Since this should mostly occur in memory,...

Have you rebooted since then? The old one may still respond at a network layer.

The commenting method shown above, or some derivative, is the best way. There is no automated way.

Is this a college course question?

You can also pass in a TEXT parameter.