Thanks for the reply Scott. I have taken a look at these roles and although the operatorRole gives the users the required privilages it gives them more access than...

Hi Denby,

I have just run a test on my machine and will go through what i did and what i saw. Its all done on one server replicating from...

Im not fully sure what you mean by "copy" but it will take a snapshot of any table, view etc in that publication and place it in the snapshot folder....

Books on line is an excellent reference for all thing SQL. Online references your best bet are these forums, theres plenty out there (SQLTeam, SQL Server Performance etc) and...

MIJ (1/7/2008)

---

In SQL 2005, SQL Mail (which I believe is equivalent to the way SQL 2K sends email) uses an Exchange profile, which is what allows it to talk to...

Yes we have an exchange server and the profile i am using is on that server. Database mail is configured to use a profile called syssql and the test...

What would having outlook express on my machine do for me?

Thanks for the response, however i understand that the two mail types use different protocols, i just dont understand why sql mail will resolve names without the domain and db...

MarkusB (12/21/2007)

---

Animal Magic (12/21/2007)

---

It is taken from the local security policy, which by default will be taken from the settings on the DC. You dont actually set these values...

ps, search for password policy in BOL.

haichells (12/21/2007)

---

Hi,

I need to apply the Expiration policy for SQL Logins. Network domain anyway will maintain windows expiration policy i understand.

My query is can we define expiration days/intervals for Sql...

The domain controller (assuming you are running on a windows domain) - ask your network admin what the settings are.

It is taken from the local security policy, which by default will be taken from the settings on the DC. You dont actually set these values within SQL.

Graeme100 (10/17/2007)

---

Hey..

After a chat with my esteemed colleague I was reminded....

If you make all your FKs NOT FOR REPLICATION, then when the replication applies the child record, even if the...

Since i started there (only 2 months ago) there have been no snapshots applied. They were getting conflicts for as long as they could remember, and didn't know how...