no sorry Dave; all you can do is check that the format of the email is correct...[something] @ [a correct TLD]

If you have your own mailserver for davidandrews.com,for example, then...

you did not really provide any definitive requirements; your procedure is unnamed and your fourtables are pseudo names(TABLEA,etc)

here is some pseudo code that is the basics of what i think...

i bet the email is sent as html, and since html does not respect CrLf/Lf, you should substitute the <br /> instead:

Set @Job = 'The following opportunity has been changed...

uggg....you have a SQL server exposed directly to the internet? At our shop, we have a web server that is exposed to the internet, and it connects to a SLQ...

the devil is in the details, but here's my two cents:

use computed columns or a view which does the computation for you whenever possible.

i don't know if you've ever tried...

denying UPDATE at the table level prevents "smith" from directly updating your table with the statement UPDATE TableB SET somevalue = ''

if smith should not update tableB, he should...

also using roles is the recommended best practice for assigning permissions. If you do not want to use them, it's more likely you are not familiar with how useful they...

permissions are not cross checked the way you are thinking.

this is working by design...an example might be you do not want "smith" to touch the tables directly, and only thru...

Sorry, it's not possible with a view.

in SQL Server, only a procedure can be created where the objects it uses do not exist yet;

everything else...tables with foreign keys, views and...

halifaxdal (6/2/2010)

---

One thing missing here: is it possible to find out the last modified user? who made the last change? It seems not included in the sys.objects table. I do...

adding to what Gail said, here's screenshots of where in SSMS to see how much you could release by shrinking the database.

you might want to move any existing backups off...

halifaxdal (6/2/2010)

---

Hi folks,

I am just wondering if there is a way to track the usage of stored procedures and functions in SQL 2005? I want to know how many times...

awesome Aaron;

sometimes just a shove in the right direction gets you rolling;

i had a brain block exactly like that last week, where i knew how to do something, but it...

here you go Aaron;

teh trick you want is to use hte ROW_NUMBER() function; that can give you "partitioned" results per PatientID, for example.

if you can in the future, if...

take a look at this thread: someone was running into a similar situation:

http://www.sqlservercentral.com/Forums/Topic930970-149-1.aspx

without seeing your specific query against the linked server, i bet it is the same issue:

i know...