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...

this kind of request ranks up there with a request that was once heard at Enron:

Run everything in these filing cabinets through the shredder...boss said it was ok, and those...

blocking is not affected by users...it's affected by two connections selecting and updating the same row of at nearly the same time.

...whether it is two connections with the same...

i'd think it through first...what happens if the database goes missing? does the company shut down? is the database being used? maybe they mean they want you to move the...

the switches we are talking about are for the program bcp.exe, not xp_cmdShell...easy to confuse

i would reckon books online has a complete description of each delimiter, but the command line...

when i did bcp /? from a command window, i saw one if the switches is a lower case t:

[-t field terminator]

changing my command to this gave me comma delimited...

keyun this example works for me... outputs 3 rows to my file:

no quotes or spaces for the username or password bvariables being passed...your way may work, but it's not how...

wierd i got the same error, not sure if it is because of the reserved word SITE or not;

this passes the syntax check:

select cust_num,slsman,

SUM(CASE WHEN [site] = '11199' THEN...

edited because now i'm not so sure......

Trusted_Connection=yes = I thought was not possible...unless you change the login used for the SQL Service account.

I know SQL does not use YOUR credentials...