Is there an error for the distribution agent?

There is no command that will do a partial backup, that would not really be a backup at all.

You can go table by table with "select top 10 * from...

Unless the reslults were saved to a file, they are gone to binary heaven. 🙁

You will need to rerun the query.

It happens when SSMS is autosaving a file and your My Documents folder is remote or off-line.

The best way to do this is through a tool. I believe Redgate has something that does this.

If you just want a list of columns that are not common...

select...

What are you trying to do with the case statement?

select @@VERSION

In general, a well-tuned large table shouldn't be a performance issue.

One question I would have is do you really need 11 indexes on the table, given that fact that you...

I don't understand what you mean by 'master' and 'transactional' tables.

There is a master database. Is this what you mean? A transactional table is any table that stores...

You can setup a transactional replication that does not delete records. You can also use filters. Using these, you can replicate your adds and updates to your...

You could use randon row sampling in SSIS.

Not really sure what you're asking here. Are you wanting to know parent to child relationships?

Without a diagram, you can't really tell at a glance, but you could trace...

Sean-752587 (2/22/2010)

---

WayneS (2/22/2010)

---

like this... you don't need to cast ROW_NUMBER to an int... it already is

select top 100

case

when...

CirquedeSQLeil (2/22/2010)

---

GSquared (2/22/2010)

---

Just to annoy Jeff, here's my "ultimate version":

SET NOCOUNT ON;

DECLARE @Table1 TABLE (

ID int IDENTITY PRIMARY KEY,

Number int);

DECLARE @Number INT;

SELECT @Number = 1;

WHILE @Number <= 100

BEGIN

INSERT INTO @Table1...