Very interesting... I just had to play and it was fun. However, I can't think of any clever usage for it, yet. But give me time, I'm...

You have to alias the subquery in this case:

select max(myDate) from

( select field_1 myDate from myTable

union all

select field_2 myDate from myTable

union all

select field_3 myDate from...

The web page makes a call to the database which fires a stored procedure. On the times that it fails it returns a timeout error. If I go...

The file being loaded is a plain old CSV file - names, addresses, etc. All ASCII characters and all demographic type information.

Looks like a very handy piece of code; however, the first thing I did was add the following:

SELECT * FROM @procedureListTable WHERE sch_name <> 'sys'

which eliminates all of the system...

In order to get the current objects to lose the system attribute, you would have to script them out, drop them and recreate them. In order to do this...

This is a bug that was reported to Microsoft in 2006. (Timely attention to bugs...) The suggested solution at that time was the following:

You have uncovered a bug...

Andy,

Thanks for your response.  I am going to pursue your connection string idea as it seems promising.  As far as the @@SPID goes, if use just the @@SPID, it gives...

Thanks for your input.

Unfortunately, we are not using Windows Authentication; therefore, the suser_sname is not unique.  This methodology overcomes the limitation of having a bunch of users that are logged...

XML is the answer if the question is "What comes after 'WML'?  What ever happened to the NSF format?  Oh, yeah, it was replaced by ANSI X.12.  But where is...

If Windows 95 is any sort of indicator, that must mean that SQL Server 2005 will be available in June 2007.