steveb (2/5/2009)

---

Ahmad Osama (2/5/2009)

---

GilaMonster (2/5/2009)

---

Ahmad Osama (2/5/2009)

---

I have a job to rebuild indexes..this increases the transaction log size....so...

5 clients to start with..Is there any other way to handle this scenario.....

GilaMonster (2/5/2009)

---

Ahmad Osama (2/5/2009)

---

I have a job to rebuild indexes..this increases the transaction log size....so i want to...

I think dat this query will not execute b'coz the join is incorrectly used, it should terminate with error message incorrect syntax

I have a job to rebuild indexes..this increases the transaction log size....so i want to truncate it...

okies...however some time it just didn't work..in those cases I hv used dbcc shrinklog to truncate log.....

Hi...I didn't had that problem again...but as per my research this problem was due to some network issue at my office.....

I think that this can be done thru an Application role....Isnt it...

Hi...

chk whther firewal at those servers allows MSDTC connections...also hv a luk at this article....

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql

Jeff Moden (12/23/2008)

---

Ahmad Osama (12/22/2008)

---

Jeff Moden (12/22/2008)

---

Um.... I don't know much about IIS, but I'm pretty sure that you're going to have to make a trip to OSQL via a...

Can I use a batch file as I posted earlier to restore master database .....

Thanks....but I want to embed my code in a batch for automatic execution....

Jeff Moden (12/22/2008)

---

Um.... I don't know much about IIS, but I'm pretty sure that you're going to have to make a trip to OSQL via a command shell call.

The best...

GilaMonster (12/22/2008)

---

Ok. Confirm the following for me.

1) You have stopped the service.

2) You have one command window open where you ran sqlservr -m and then left it running

3) You are...

GilaMonster (12/22/2008)

---

So you've got the SQL service stopped, you've got one command window where you ran sqlservr.exe -m and left it running, and another command window where you're trying to...