Application locks are just a simple implementation of semaphores that use SQL Server's built-in support for locks. They are used by an application calling sp_getapplock to aquire some resource. What...

Ok, so break down the problem then. Create a simple VBScript file on the server running IIS and try to connect to the server. See where that goes.

Yes, that looks promising. Please post a short review here.

But somewhere there must be an error message swallowed, most probably in the COM object then. If you looked for that it migt be easier to understand what is failing.

Can...

Ken Henderson describes it (in short terms) in The Guru's Guide to SQL Server Stored Procedures, XML, and HTML. You can probably find some resources online with Google.

Out of curiosity,...

This book is a good start by the way: The Guru's Guide to Transact-SQL by Ken Henderson

I agree with brendthess...you need to post some sample data at the very least...

+1

Here is a good reference: Providing details

This error message tells you that somewhere in the query you are referring to a column called Date, but more than one of the tables that are used in the...

Join on xusertype instead and you will get the correct result:

select

distinct so.name as [Table Name],

sc.colid as [ID],

sc.name as [Column Name],

st.name as [Data Type],

sc.length as [Size]

from sysobjects so

inner join syscolumns sc...

Hehe, thanks.

I'm quite happy that post 1000 included actual code for a specific solution, since it symbolize the kind of posts I...

No, that is a client configuration. It is not stored in the server you connect to so you can't access it by T-SQL.

Must be that I am not a native English speaker.

And we're not yet sure I made a correct interpretation anyway.

Great, and nice of you to reply with the url for the query so others with the same issues are helped.

Why not simply use the numeric form of weekday, and then use DATENAME when outputting it?

Do you mean the virtual tables that you can access to get the rows that where modified by the statement that triggered the trigger? If so, then they are called...