How have you set the linked server up? What errors is it giving?

GSquared (10/14/2008)

---

A good way to do it is pick the columns that appear in Where/Join the most, and index those, and put the one with the highest selectivity at the...

I don't suppose you have a backup of distrbution?

Did you drop the database, or did you delete the files of distribution? If you query sys.databases, is distribution listed?

Is the drive full? Is there a max size set for the file?

Well, that depends on whether you want your indexes to be selective or do you want them to be useful and used.

The clustered index benefits from unique values and an...

If your dev's getting an error, post the full error message here and we can help diagnose the cause.

A rebuild won't hurt. Whether or not it's necessary depends on where the rows you're deleting are in that index. If scattered all over the place, then a rebuild's not...

The question is do you want the theoretical result (where NULL, 1 and 1, NULL are both right) or the actual result that the current versions of SQL give for...

You don't need a where clause anywhere. If only 1 row is affected by the update, then inserted and deleted will have only 1 row in.

If there's a chance that...

Ok, that is odd.

What does this return?

DBCC SQLPERF(logspace)

As I said before, I've said what I think you should do. If you disagree, then I'm out of suggestions as I don't know what else you could do.

Just the one column.

You used the...

virgo (10/14/2008)

---

Hi

can any one please let me know if there is any system table where i can find sql server error log details

other than general text error log file and...

CREATE TRIGGER trg_SomeInsert ON SOMETABLE

AFTER INSERT

AS

Insert into someothertable

Select somecolumn from inserted

GO

Does that help at all?

A snapshot doesn't just move the updated rows, it will copy the entire database to the subscriber every day.

Still, since it's not transactional it shouldn't have a big (if any)...