Response is NSFW. :w00t:

Evil Kraig F (8/6/2012)

---

Primarily because that's how they get them from business users and...

One, you really don't want to shrink your database on a regular basis, it will result in both index and file fragmentation will affect performance. regarding the transaction log,...

Really???...

Why do people get upset when you can't provide an answer based on vague requirements?

I think what it comes down to is providing enough information to understand the problem so that a good solution can be provided.

What you posted just didn't provide that information....

jweyl (8/6/2012)

---

Hi -

I have some very simple code that kills all the user pids, then switches the db to single use and runs a restore and sync of the logins....

Unfortunately, we can't see what you see, nor do we know what the final result should look like. Just not enough information to give you a solid answer.

I would tend to agree with Gus except for one thng, no one gets paid for QotD submissions. In addition, Steve could review the QotD if it is rejected...

I came up with the following. It will probably need work to fit into your actual solution but it gives you an idea.

select

productID,

...

Sean Lange (8/6/2012)

---

Lynn Pettis (8/6/2012)

---

Sean Lange (8/6/2012)

---

Ajdba (8/6/2012)

---

INSERT dbo.xdata (RcNBR ,

...

It seems that the most important part of the job is to answer the bloody phone. Anyone else get that out all that as well?

Okay, so share how you fixed it. Others may be interested, plus it is good forum etiquette.

Sean Lange (8/6/2012)

---

Ajdba (8/6/2012)

---

INSERT dbo.xdata (RcNBR ,

...

Ajdba (8/6/2012)

---

INSERT dbo.xdata (RcNBR ,

...