nikhil.desai1 (1/16/2012)

---

Hi,

I have create on User i.e. User1 with db_owner permission

and gave access to One on User Database DB1 and gave access of DBMailUserRole to msdb database.

When user fires the...

Bhuvnesh (1/16/2012)

---

i got succeeds to implement it but following error now i got

while inserting from server A to B

Error messages:

A conflict of type 'Insert-Insert' was detected at peer 1...

To recover the data from transaction log...

guruprasadurs (1/9/2012)

---

Hi,

I want to schedule back up DB in ms sql server 2005 using maintainence plan wizard. I want to know Is it possible to...

patrickmcginnis59 (1/12/2012)

---

I sort of stumbled over this when trying to diagnose some newb discontent, but now I'm really curious, why doesn't this site have a reputation system? Number of posts...

james.berryman (1/13/2012)

---

Hi, im new here but not totally new to SQL server, however ive come across a problem when reading files stored on a different machine to the sql server....

You need to add this "ReadOnly" user to Model Database. That will serve the purpose. Every new database which is created on the server is actuly a copy of Model...

L' Eomot Inversé (1/12/2012)

---

edit: I haven't looked at the posting history - just the the thread referenced here and the first thread it references - so maybe I'm reacting on...

GilaMonster (1/12/2012)

---

How about only updating ones that haven't just been updated (by the index rebuild)? Yes, it's more work than blanket updating everything (maintenance plan) or updating with sampled...

lol...

So how should I go about...

GilaMonster (1/12/2012)

---

sp_update stats has threshold of rows that must have been changed since the last stats update for it to update them again. As Grant says in his article

then, you...

Evil Kraig F (1/11/2012)

---

Brandie Tarvin (1/11/2012)

---

Evil Kraig F (1/11/2012)

---

Brandie Tarvin (1/11/2012)

---

Evil Kraig F (1/10/2012)

---

Is it bad that my favorite T-Shirt has Mario trying to steal a Dalek's arm and looking...

Yup, Auto fix should do...

GilaMonster (1/11/2012)

---

1) http://www.sqlservercentral.com/articles/Indexing/68636/

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

2) That will prevent key lookups, but you've just duplicated your entire table, perhaps multiple times. Don't use SELECT *, and keep the includes on indexes to as...

Dhirju (1/11/2012)

---

no firewalls between them, and both node are in same subnet mask..

and i have checked using telnet command for this port,

but i m configuring in primary server, how...