you'll have to provide the linking criteri that shows that an address in one table belongs to the employee in the other;

and you'll simply use a left outer join to...

I edited my saved snippet to have your values;

change the password and see if this works.

note that for this to work, the client tools have to have been isntalled...

I have no...

yes, if not too much time has passed, you can look at the default trace to see who did any DDL chances(ALTER/CREATE/DROP of objects.

easiest way is via the SSMS GUI,...

Marvin that is so weird; i pasted your command to my SQL2005 instance, and it ran without an error;

maybe it's due to a patch level?

here's my @@version:

Microsoft SQL Server...

touching base on this, as Marvin mentioned trouble with this in another thread. I thought the scripting of the hashed password got him where he wanted to be.

I tested this...

For a default instance, there can be only one. all other additional instances would have to be named instances.

if your current default is 2008, and you HAVE to have a...

hossein what indexes are on the table? the key to performance is having good indexes in place, along with SARG-able WHERE statements(which you seem to have)

The EntityID column name...

On a similar thread, Gail Shaw (Gilamonster) reminded us that linked servers and which procedures are scheduled to start when SQL starts are in master, so they need to be...

Thank you for the script and the link to the other thread;

I especially liked the snippet for resending failed mails that WayneS posted; good to have that in the toolbox.

ok, post coffee, with a clearer head, i found the answer.

the table sysmail_event_log, has the error description and the mailitem_id, so you can join it to failed items and see...

nice proc Gianluca; i added that to my snippets.

Jeff's right on target.

no matter what, if a message was generated by SQL(i.e. #row(s) affected or PRINT statements), you cannot read it into a variable with TSQL, whether you wanted...

here's my first guess, when covering the basics.

your server has a hyphen in it's name. that causes problems, in my experience.

i think the connection will have problems with that unless...

you won't be able to capture the messages via TSQL. the information is generated, but not capturable via...