I can't work out what your problem is - there are no UNIONs in your code.

John

Several years ago I found a package on Codeplex, or somewhere like that, that allows you to change the collation of every single character column in the database.  It handled...

Here's how you can do it for the first four times for user.  You'll be able to see how to extend it to ten or any other number.  I've shown...

Yes, should be possible.  Are you really on SQL Server 2008?

John

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