Grant Fritchey (7/8/2010)

---

Sharepoint most definitely has to run as 'sa.' I've never seen anything to suggest otherwise and everything I've seen it do on the server pretty much suggests that's...

Hate use this, but, It Depends. Each environment is different, each individual learns things at a different pace.

Sorry, but it looks to me that everyone who responded DID read and understand the post. Unfortunately, you don't seem...

I would be wondering if you are taking periodic t-log backups on the primary database as well.

doobya (7/8/2010)

---

If you don't mind, I'll just go ahead and disagree with you on all those points. 😉 It all works exactly as I expect it to work according...

Alvin Ramard (7/7/2010)

---

CirquedeSQLeil (7/7/2010)

---

Alvin Ramard (7/7/2010)

---

CirquedeSQLeil (7/7/2010)

---

Alvin Ramard (7/7/2010)

---

Jeff Moden (7/7/2010)

---

I'm either getting too old or just lazier in my old age. I no longer fight people who insist...

Jeff Moden (7/3/2010)

---

Jack Corbett (7/3/2010)

---

Cool! They must be in the developer track because I didn't see them in the DBA track. I'm sure one of them will be...

You need to provide us with the table definition(s), sample data, expected results, and what codeyou have written so far to solve your problem.

You are going to find many volunteers...

rajendra prasad-377679 (7/2/2010)

---

Please post table definitions, sample data and desired output

Dear ,

THANKS FOR UR SUPPORT.

i want to do that by using cursor program not in trigger..

U CAN CREATE OWN TABLE...

Jeff already responded to the trigger comment, so I'll...

ricky70rana (7/2/2010)

---

Actually you are right that i want to understand how that code is working.Only was able to understand Common Table Expression out of this script. Actually I want to...

ricky70rana (7/2/2010)

---

Can someone explain me how the script given below is working ?

Especially the CASE Statement

DECLARE @Text NVARCHAR(2000)

DECLARE @StringDelimiter CHAR(1)

SELECT @Text = 'This T-sql will split senteneces...

Here is what may be considered a better example of using a Tally table. It is dynamically created with the function. And FYI, it is formatted the way...

What would really help is for the OP to come back and tell us what is really needed or if any of the code snippets provided actually solve the problem.

mattmc (6/30/2010)

---

Hi

We have a scheduled process each night which drops and recreates index’s on one of our main Databases. This in turn causes the transaction logs file size to over...