So you want a table with an indeterminate number of columns?  That's going to be a horrible mess of dynamic SQL.  I recommend you stick with Eirikur's solution.

John

Will each user always have exactly four activity dates associated with him or her?

John

That doesn't sound all that curious.  Why do you want to change it?

John

Session values configured with the SET command override the sp_configure options. Many tools (such as Management Studio automatically configure set options.

John

If you test properly, you should have nothing to fear.  But if it's a case of once bitten, twice shy, why not just capture logins in the errorlog?  It doesn't...

Given the title of this topic, and the sparsity of information in your post, my only advice is to run DBCC CHECKDB WITH NO_INFOMSGS and post the results here.  Do...

Third-party tool is another option.  Only you know your system, and only you know why you rejected logon triggers, so it's difficult for us to advise you on what's best...

Yeah, something like this.  I've not thought it through thoroughly, but it may give you something to build on.  States such as California that have complex rules will need more...

You'll need to find a way of modelling those overtime rules in a table.  You could put it into your query in a long CASE expression, but I don't recommend...

I'm not totally sure, but I don't suppose it'll be any worse than when the clocks go back an hour, will it?

John

Unfortunately not.  You'll need to have set something up in advance.  I think a trigger on sysjobs would work.

John

Neil

Long time no see!

This does seem strange.  Does the error message state that the error occurred in that stored procedure?  Have you tried running an Extended...

SELECT snapshot_isolation_state_desc
FROM sys.databases
WHERE name = 'MyDatabase'

John

First, sort out your database design.  If a column is going to hold money data, give it a decimal data type, not nvarchar.  If the data in your column is...