Another thing, statistics could be different between the two systems, and this could affect the query plan generated in production compared to UAT.

To me it looks like an application issue. Unfortunatley, it appears it allows the wrong data to be entered into the wrong database. It maybe better to focus...

Requires restarting SQL Server from the command line using a switch (check with K Brian Kelley (sp ?)) which means you need access to the server; actually physically or using...

Question now...

Have a declare statement in your code? Try putting a space between...

krypto69 (2/1/2010)

---

Here's what I ran:

As an overview - I need to create a BAK file of the existing MSPHXX. Then, restore that onto my K and L voumes (DB &...

I don't see anything wrong with your comment. Now the OP might, but that is his problem, not yours.

If the database name already exists, the restore will not overwrite it unless you include the REPLACE clause in the RESTORE command. I didn't see that in the code...

san43 (2/1/2010)

---

I completely agree with all the arguments/suggesstions that every one has made here. My doubt is the same number of rows are retured for table variable in UAT(...

Bill Gates-870674 (2/1/2010)

---

OK, NOW:

Can you explain how much important it is for a DBA to know about system administration/HW/Servers? and why ?

AND

Does this also mean that an IT person has...

Part of it depends on when (date and time) the end of month backup is taken and if that time is consistantly the same.

milzs (2/1/2010)

---

OK, so.....

(A) If I change the recovery model from FULL to SIMPLE, then perform the DELETE will the delete action not be logged? I can then change...

Okay, then I won't. 😉

I'm still confused as to what is being asked. How about more detail instead of a single line vaguely worded question. What are you trying to do?

milzs (2/1/2010)

---

We have a classified database (SQL 2K8 Enterprise) that interacts with a "classic ASP" application. This app/database is classified for program "A". Folks can update information within...