Are you using integrated security? It looks like a double hop issue, i.e. NTLM credentials cannot be hopped to the second machine. So the linked server works fine if you...

Thanks Hugo for your clarification and thanks Richard for the link.

I do use correlated subqueries in a daily basis but in my mind, the outer table can only be referenced...

I am on vacation till Jan.14. I have no reach to any SQL server and have very limited access to internet during my vacation. So I am sorry for the...

if the file exists, bcp jsut overwrites it. So you don't need to delete it

1) Those groups are created by SQL server 2005 installation;

2) MS suggests to add the user accounts under which SQL Server serviecs run to the corresponding group. and Only assign...

if you use sp_xml_preparedocument, OPENXML, and forget sp_xml_removedocument, you will get mem leak.

Sometime though you do call sp_xml_removedocument after sp_xml_preparedocument, you can still get mem leak, e.g. time out happened...

select A, B, MAX(C) AS MaxC

from Yourtbl

group by A,B

You can use DBCC CHECKIDENT to reseed the identity value to 3000.

I copied your code and ran it on my box, it succeeded with no errors.

Check your msxml.dll version.

Brandie Tarvin (9/27/2007)

---

Help, please.

I'm learning how to create XML Schema Collections and I have questions on the "basic" stuff they always include in the help files, but never fully explain.

Here...

I couldnot see your schema and xml in your post. So not sure what's happening

In SQL 2005, the proxy account for xp_cmdshell and proxy for CmdExec job step is different.

If you want to run the SP,  set the proxy accoutn as:

EXEC

...

You can use UNION to get the result. The following is the sample code:

DECLARE @xmlLocations XML

SELECT

@xmlLocations

Strange, my status is showed offline when I logged in, even when I reply the post

Thanks Steve.

I checked my email settings, I donot have any filters setup. I haven't got today's newsletter too.

I got the notification email for your reply though.

Not sure what's going on. I'll do...