I typically do this

BEGIN TRAN

DELETE xxx

if @@Error <> 0

begin

rollback transaction

return 1

end

UPDATE xxx

if @@error <> 0

begin

rollback transaction

return 2

end

commit transaction

I...

I usually set up system database separate from user databases, especially since system databases don't need transaction log backups.

Otherwise, the advice above looks good.

I haven't heard of this. Couple questions:

- Are the drives available in Windows and unavailable in SQL Server or unavailable in both?

- When you remap, what do you run?

I've always had to build a separate table and maintain it. Something like

Period Date

1 1/1/2000

1 ...

Each item in the connection string is a separate entry. You just add the failover partner part.

The Integrated Security clause is an either/or with the uid/pwd section.

Where did you get this link? Or which script should it be?

Which item did you try? Note that the procedure give is for SQL 2000, but there are...

Dimbulbz (8/2/2010)

---

... I don't know where you have taken your sample from, but that is scary and perhaps I need to do my own polling where I'm working now....

Depending on what you do, OPENQUERY can be easier to write. If you do a straight join, I believe that the entire table from a linked server comes across and...

Thanks for the update. If you get the DNS specifics, I'm sure this would be a good thread to update for others.

I thought this was interesting, and I've dealt with this in a few places. If you don't have to work with the financial system, you might not encounter this. It...

BTW, I bought a 2500sq ft house in Va (SE) for $140k in late 1997, sold for $150k in 1999. A little over a year later, bought essentially the same...

Spending $160k a year.

Make sure you have indexed the columns.

Is there a reason that you cannot check for an AND with both columns? As in Jeffrey's first example.

First google result for me: http://www.mssqltips.com/tip.asp?tip=1046