No and No.

The system tables contain information that keeps the server running. Logins, users, databases, etc. are contained there.

Why do you want to mess with the system tables?

Thanks:blush:

I'm a little confused and concerned. First don't use Sa or equivalent for something like Cold Fusion. Create an account and work through the rights.

Second, the current security context will...

You add a new conneciton in the Data Sources (ODBC) control panel. Enter the server name/instance name and your credentials. It will connect.

http://support.microsoft.com/kb/943656, looks like you need to submit a request to get the download.

You could build a maintenance plan with SSIS that just does maintenance cleanup. Probably be easiest.

No problem keeping connections open. If they don't use resources (queries), there's very little overhead. Might be sure you have error code in case the connection gets dropped.

I'd actually consider...

I was going to suggest what Michael posted.

Since I often find myself going back a few events, I'd actually keep a query around to pull everything from today.

select

...

...

Great explanation and I'd add that they did a great job with the DMVs exposing almost everything you need, so you don't really need to hit the base table.

Plus the...

It's actually easy. Inside a company, you buy CALs. If the people are authenticated users, Windows Auth, or just AD accounts, they should use CALs. Per processor is for unauthenticated...

Hopefully Peter will respond soon to this and thanks for a nice post on what you see, Hugo.

We don't necessarily check every article for accuracy. It's a time constraint as...

Where is a moved topic forum?

We do move threads that are mis-posted by people in the wrong forums. It might note that.

Working for promotions has been in a couple ways. This is probably another whole editorial ;), but I'll give a few examples.

If I wanted a manager's job, I'd look for...

There is no way to do this directly. It doesn't return anything.

Run a query to look for the user after it's created. If it's there, then it worked.

Stop and restart SQL Agent. Doesn't affect the database server and is very quick.

Check the service (control panel) to see if there is a parameter.

Otherwise, check and see if there is a command window open. close that.