This post shouldn’t be in the SQL Server 2000/7, because those versions don’t support Xquery. Having said that, the method query returns an untyped xml (just as you discovered)....

As far as I know the serve doesn't store this information. You could have a trigger on LOGON, that will writes the login name, date and database name...

Can you please write a small script that creates the table with the columns and insert few records into it and then show the requested results? I think that...

You didn't specify how get the parts but in your example it was the first written name until the first space. If this is the criteria that you need,...

As you’ve just found out, openrowset function doesn’t accept variables as a parameter. This behavior is documented in BOL (Books on line). You could modify your code to...

Here is one way:

SELECT schema_name(so.schema_id) as SchemaName, object_name(so.object_id) as ObjectName,

c.name, c.collation_name

FROM sys.columns c inner join sys.objects so on c.object_id = so.object_id

WHERE so.type = 'U' and collation_name is not null

Adi

You can right click on any place on the query pane. In the popup menu click on “connection..”, and then select “change connection…”.

Adi

You already have one - Model database. Any new database is created according to the model DB. If you'll create some user defined objects on the model database,...

Can you explain what are you trying to find, how are you trying to find it and what is the results of your attempts? Based on the information that...

You can query the relevant dynamic management views – sys.partitions, sys.partitition_functions and sys.partition_schemas.

Adi

O.K, now I have to ask it – what was the font’s size:-)? To answer your question, I’ve got some big ugly SQL Statements in the past, but not...

I know that you can use format file to specify which columns should be inserted (you can read about it in BOL or Google). I think (but I didn’t...

I didn’t check your code. Instead here is a demonstration of how to get all the characters in one select statement (you can use it later on in insert-select...

5 years ago...

I’ve noticed that there is no group by, so I selected the answer with the syntax error. Seems that I was wrong and I lost 3 points....