the only thing I can think of off hand is whether it was possible the server ran out of disk space after backing up the 30th database....when it moved to...

why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?

then the view will never be out of sync, and will have...

i thought table variables were exempt? i know if they are in a transaction, and the transaction is rolled back, the table variable is unaffected...does that mean it's not logged,...

it's not access to the exe.

once again, the point i'm making is the exe trying to use the security context nt authority\system for example to access files or file shares....

kelvin this may or may not be much help;

i have this saved in my snippets for creating a linked server to Active Directory, and then querying it...in my case, i...

i guess you missed my point; take a look at this thread, where someone had a very similar issue to yours.

http://www.sqlservercentral.com/Forums/Topic944084-392-1.aspx#bm944497

my point is that even though local system can access...

the issue is the dynamic SQL; if that is used in a proc, the calling user needs to have the rights to the underlying object for whatever the proc is...

details? the account cmdexec/xp_cmdShell runs under is local system , you said, right? that account might not have rights to a local folder(ie C:\Documents and settings\SomeUser) or to a \\UNC...

could your application be raising a pop-up/error message window? so when it is run from cmdexec, maybe with a misspelled parameter or something, it seems to be running forever because...

SYSTEM stored procedures? like sp_who? i think that is inherited with CONNECT permissions, but i'm not sure what you are refering to.

can you script out the user you created and...

hmm...rereading your issue, you said it is"SQL query analyser it runs continuously, seemingly without end"...

could your application be raising a pop-up/error message window? so when it is run from QA,...

wouldn't log shipping be an option? a zip of the log file of changes would be much smaller than the 9 gig backup, zipped or not, and your bandwidth would...

dunne do you mean you want to show the existing DISTINCT combinations of the three values, or do you mean that you want to force three distinct lists, but put...

xp_cmdShell does not use your...

here's a simple and fast example: just add the insert into:

--ten years before and after todays date:

with TallyCalendar as (

...