sp_send_dbmail can only send to an address that conforms to an actual email address format, ie mygroup@mydomain.com; you cannot send to just "MyGroup"

a group account is handled special by an...

ok if it's a user who exists in a windows group, and doesn't have an individual login in SQL, then it's the issue Gazareth identified;

I assume the user are...

google update service is one of the things the google toolbar adds when installed on internet explorer or firefox.

if this is on a server, consider either updating to the latest...

check the default database for that login;

if the database was deleted, then you'll see that error, and need to reassign the default login, probably to master.

so as an example,...

glad i could give you a push in a different direction!

Sel what I've done myself is to create a CLR function that returns RTF2Text, or vice versa;

that's the best way i know of, because the RichTextBox from windows.forms handles...

the barcodes i'm used to, like at the grocery store are basically a concatenation of a vendor number plus a product number;

ie 41415 -00106 is Eggs, Large at Publix Supermarkets,...

oops i missed that part;

doing something like SELECT RIGHT('0000' + SomeString,3) will give you stuff like 002 with preceeding zeros;

then it's the find and replace you were after.

i think this...

in my case, i don't use the @query parameter; instead i build a varchar max string, and append multiple FOR XML outputs to it.

I use that string for the @body...

sys.objects has the last time the DDL of an object was modified.

here's a simple example

SELECT

objz.create_date,

objz.modify_date,

SCHEMA_NAME(objz.schema_id) AS SchemaName,

objz.name

FROM sys.objects objz

--WHERE ...

ok, if you are sure there is always three sections to your ID's, here's one way to do it:

with myCTE (ID)

AS

(

SELECT 'AG001/1/P1' UNION ALL

SELECT 'AG002/1/P1' UNION ALL

SELECT 'AG003/1/P1' UNION ALL

SELECT...

glad i helped a little bit Jason! i fixed the link in my original post also, thank you!

I Tripped over this same issue myself, even wrote an article about it long ago(Reverse Engineering a Server Side Trace[/url])

this is a much-improved-since-that-article version of a proc I've created this...

whoops thought i had it...still looking

ok got it;

looks like you were starting to wrap the big query with SELECT * () ds

WHERE....

there's a beginning open parenthesis, but no select *...

i might be reading it wrong, but i think you just want to use either a CTE or a subquery, so you can further group your data;

something like this, maybe?

SELECT

...