All users are placed into the public role and public has select rights on all the system views. You would need to explicitly DENY select to the user/role they...

Lynn is right, if you post some more details you will get a better response.

In an "and" situation I would use where materialID in (1,2,3) wher I dynamically build the...

Well, there is ";" which is an end of statement character "--" which is a comment.

As a dba I do not like application built dynamic sql because it is harder...

Internally sql server stores dates as integers so the date you are using is probably outside the range that sql server recognizes as a date, so by casting to character...

Adam Bean (3/21/2008)

---

Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...

Anyways, both in x86 and x64, I changed the...

Wow, this is the first time I have heard that the case of object names would make a difference in the re-use of query plans. I would have thought...

Todd Engen (3/19/2008)

---

Can only confirm what you're seeing.

Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.

From looking at a...

How much memory do you have? Is the package solution stored in a network location or on the PC itself? At my location our My Documents location is...

I worked at a paper mill and we used shared accounts for the production floor personnel. They were using thin-clients and citrix published apps with restricted permissions. For...

A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.

Lynn,

What mail server are using for...

Joe Clifford (3/20/2008)

---

You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on...

Now that I see the answer I can remember a time with 2000 that I had a similar problem. I think it was due to a an MDAC update.

Thanks for the confirmation Todd. I did a quick google and did not find anything so I made this quick post hoping someone would have a little more information....

I have not lloked at this, but could you use replication and only replicate the schema? Or through using DDL triggers you could generate scripts on the remote database...

You would probably have gotten quicker responses had you posted it in a Development forum and not Administering as this question really has nothing to do with SQL Server, but...