Sorry if this solution is too simplicistic (I might have missed something), but why do you think SSIS would not be the right tool for this task?

J Livingston SQL (1/30/2012)

---

in 2008r2...sorry, havent got 2005 anymore...when creating the linked server there is a "security tab" that allows you you to specify the login to the remote server...have...

Does this help?

http://www.sqlsoft.co.uk/sqljobvis.php

I think you should be ok, then.

First of all you have to define what "duplicate" means to you. Duplicate records for the same Id? Duplicate records for the same id+status?

If the former, this should do:

SELECT *

FROM...

Gianluca Sartori (1/30/2012)

---

Weird. Worth filing...

Weird. Worth filing on Connect?

Uh. I didn't know what a Googlewhack is.

Interesting neologism...

Gianluca Sartori (1/30/2012)

---

Plenty of ways to do it:

1) In SSMS isse SELECT TOP (0) * FROM SomeTable, right click the cell on the left of the fisrt column header...

Plenty of ways to do it:

1) In SSMS isse SELECT TOP (0) * FROM SomeTable, right click the cell on the left of the fisrt column header (the one...

BTW, Google indexes scarily useless things: 😉

I mean: did you check that row or column delimiters are not in the column data?

Row delimiter (CR LF) in the column data?

Column delimiter in the column data?

You will find both information in Event Viewer.

As for the server startup (approximatley 2 minutes after the failover) you can query that information from sys.databases (it's the date when tempdb...

If you want to optimize indexes and stats this is a good place to start looking:

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html