Hmmm, couple thoughts.

-Did you miss an "If" Or "End If" somewhere when pasting your code in? I copied

your code into VB after removing the client side JSCript, removed...

There is something in SQLXML that might help you : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp

Tim C.

//Will write code for food

You are right, another example of "I should have tested that" before posting it. FOR XML AUTO does not allow being used in a sub query, and I can not...

From BOL :

quote:

---

The osql utility passes everything between the parentheses ( ) to the server exactly as entered. If a stored...

1) DECLARE @Doc nvarchar(4000)

SET @Doc = (SELECT Col1, Col2 FROM INSERTED As TableName FOR XML AUTO)

2) Take a look at the XP_FILE in the freeware sction on this site @...

Your right, without using xp_cmdshell I don't see another way either. I was trying to offer him an alternative. I really did not understand the need to have it run...

How about removing ALL of the rights to those tables? Then if they complain all he has to do is readd the rights. I would make sure to document the...

I would actually suggest using VBScript or JScript via WSH to execute your

scripts. I used to do something similar to what you are talking about with batch

files, but...

Can you verify that the accounting.dbo.CUSTOMER_DEPOSIT_VOUCHER with that EXACT

namespace exists? Many times I see errors like this occur because the owner is

not the dbo, or some other version...

Could you post some sample xml, and the xsl?

Tim C.

//Will write code for food

What about BITS, it is comparable to the RSYNCH capability that was mentioned ealier. I have not used it yet, would be curious to see if anyone has used it...

Try this stored proc with :

http://www.sqlservercentral.com/scripts/contributions/600.asp

EXEC spSetPermissionsGlobally @name = 'ROLE NAME', 

    @printonly = 0,

    @revokeOldRights = 1,

  ...

Ok, disappointment sets in. The query I posted before does not work the first time you execute it. The second time it does, because the first time you run it...

There were a couple things I left out so as not to muddy the waters, but you are correct. I am concerned that I might be overengineering and trying to...

It happens occasionally that someone will add a column to a table and sometimes place it in the middle of the previous table structure. Without using column names, all of...