Curious about the decision to use linked servers for the purpose of extracting a bit of info perhaps once a day.

Since these are all servers under your control, would it...

L' Eomot Inversé (5/2/2013)

---

<PEDANTRY>It's 5 extra characters, not 4. Typing...

Hugo Kornelis (4/29/2013)

---

Too bad the question author somewhere switched the two options in his head and marked the wrong answers as right and the right answers as wrong. Fortunately, I...

Thanks, Lynne & Scott,

this is why this forum is so helpful.

Of course, it can work out with NUMERIC(19,6) - I just didn't think the scale was important in trying...

No.

See Phil Factor at http://www.simple-talk.com/sql/database-administration/confessions-of-a-dba-my-worst-mistake/%5B/url%5D

Let's start with small steps:

You have this in the caller routine:

[font="System"]@STARTDATE1 as DATETIME,

@ENDDATE1 AS DATETIME

SET @STARTDATE1=(SELECT MAX(T0.DOCDATE) FROM oinv t0 WHERE T0.DOCDATE='2010-11-01')

set @ENDDATE1=(SELECT MAX(T0.DOCDATE) FROM oinv t0 WHERE T0.DOCDATE='2010-11-30')[/font]

You may...

GilaMonster (7/6/2011)

---

Ol'SureHand (7/6/2011)

---

In practical simplified terms, a full backup will achieve what is needed, i.e. a cleanup that I suspect does not get done, because the default settings for new...

GilaMonster (7/6/2011)

---

Ol'SureHand (7/5/2011)

---

- What is this database Recovery Model? Is it (or can you change it to) SIMPLE? (ask first).

If it isn't, you have a few other issues to...

Ninja's_RGR'us (7/5/2011)

---

steveb. (7/5/2011)

---

dont waste time dropping indexes to save space on the copy, as you will need the space again when you recreate them.

The simple way to move a...

Topic discussed in "Backup" - have posted additional stats and SAN defrag positive effects there - see Topic: "Backup Duration".

---

I had...

free_mascot (6/1/2011)

---

Generally it depends on the server and how much processes & activities are running on it.

Check if backup verification option is on? Internally when backup is done than backup...

vishnubhotla.uday (3/22/2011)

---

Hi,

Thanks for your reply.

As of now i only know that we can change the collation at the server level.

Is it possible to change the collation only to a perticular...

All the answers are at 2 other recent topics - covering the fact you need to drop the PK & FK constraints if they are not numeric before you can...

As it happens, there is a new article just posted today at

http://www.sqlservercentral.com/links/306693/200479

with a rather impressive full scenario script.

Add to it the stored proc that changes the collation...