Are the login events originating from sql server or from Windows/Active Directory?

Slightly away from your question... you could also write a stored proc that is executed at startup (exec sp_configure 'scan for startup procs', '1' and exec sys.sp_procoption '<sp name>','startup','on') that...

I imagine Ashish means it depends how many updates have been...

If you REALLY want to force the order, put

OPTION (FORCE ORDER)

at the end of your query. See:

http://msdn.microsoft.com/en-us/library/ms181714.aspx

Dave.

You need to grant (at least) read access to the shared drive to the user account the sql server instance is running under (default is Network Service), otherwise it won't...

ashish.kuriyal (8/17/2010)

---

Never love your company because you never know when the company will stop loving you.

Thats what I follow.

Being in one job for years is always no no for me....

You looking for a new job then Steve 🙂

Don't worry about it... chill!

Anyone here think QoD questions and answers should be checked independently before they are released?

... and so the majority of respondents have decided - no more 'typo' questions please.

Auditing is normally performed in triggers

1)...

A very good article to show how context_info works and how it can be applied.

If the 128 bytes of context_info is insufficient for the purpose, a CLR could be...

Absolutely right - my bad. I'm afraid my brain is wired to never ever use '=' or '<>' where either side can be null, even if I'm trying to make...

Another advantage of "create/alter" over "drop/create" is that the latter leaves the database without the object for a (usually short) amount of time.

Jim Russell-390299 (4/27/2010)

---

On the other hand...

One of the rules of extreme programming was "do the simplest thing that could possibly work."

There is some danger in adding code complexity to anticipate...