Lynn Pettis (12/17/2009)

---

Jack Corbett (12/17/2009)

---

Lynn Pettis (12/17/2009)

---

I am having trouble thinking straight on this one, could someone else jump in here and help. It isn't collation, it is the...

You would test for the existence of the table before creating the table. Like this:

IF OBJECT_ID('Empdata') IS NULL

BEGIN

...

Great article Jonathan. Makes everything clear. Signing a module is very useful in many areas.

You'd have to query AD to find out. You can do it using a Linked Server or you could try your hand at PowerShell.

I jumped in on...

Run the dates in the reports through custom code that converts to a universal time format which would be yyyymmdd hh(24):mm:ss. Jamie Thompson had a good T-SQL Tuesday blog...

Don't know why that is. Try checking out this article at MSSQLTips.

There isn't one that I am aware of. Basically it is not an issue. Odds are that any tables that small are likely in the buffer cache so...

I don't have 2000 to run this against, but something like this should work:

CREATE TABLE #logins

(

sid VARBINARY(MAX),

...

I don't think you can reference a value from a subreport in a main report.

Can you post the table definitions and some test data as outlined in the first article linked in my signature?

I forgot to mention you could also use a server-side trace or query the default trace for the Audit Add Login to Server Role Event. The only problem with...

A DDL trigger at the server scope could do this. I think you'd want to look at these events: