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 (

...

Remember one of the design annoyances in Enterprise Manager was that when it starts, it iterates thru and opens every database....so if your server has a lot of databases, it...

that's because the command is repeating over...

i think it needs to be smtp.googlemail.com, and port 465:

you need an account to send with(outgoing smtp);

the imap is to pickup/receive email.

i set up an account to confirm, registered "sqlnotifications@gmail.com":

this...

it's very easy to set u, and you don't need your own SMTP server...just a valid email box somewhere that has SMTP/POP3 access...you can set up with a gmail account...

what site are you guys going to?

http://ask.sqlservercentral.com/ seems to be jsut fine, but i did not find a site named http://www.asksqlservercentral.com

the default trace captures all the DDL commands, including who dunnit info, but it rolls over if you have a lot of cahnges.

if not too much time has past, you...

LinqPad is free and a very light footprint with no dependencies other than requiring .net, but has all the things you need; an object explorer, and multiple query windows for...