SQLCrazyCertified (2/19/2013)

---

Hi, sorry, I was not aware of this, anyway, with...

Depends on your server hardware, load, network etc.

Could be 1 at a time could be 100000000.

You decide if you need row versioning on a table or not, its there to tell you when a row has changed, hence the timestamp hash changes. Its not...

Row Versioning? You mean adding a timestamp column to the table which changes when rows are updated etc? - No there is no way to know the old...

connection string yes, table name no

you can have as many source and destinations in 1 DFT as you wish

then look at replication, logshipping, creating your own ssis packages, merge commands etc etc etc

get hardware which meets the minimum required to run SQL 2005.

A index with a page count < 1000 you can usually ignore as fragmentation wont cause you to much of a headache with small tables.

Heaps require a different command to...

Abu Dina (2/19/2013)

---

The problem is with this:

(modify_date >='2012-01-28 15:43:46.077' or modify_date <='2012-12-28 15:43:46.077')

Your query is looking for record where the modified date = '2012-01-28 15:43:46.077'

Slight change to Tony's version:

select create_date,...

Nope, its an 11 month...

like this?

select create_date, modify_date from sys.objects

where

create_date >='2010-01-01' and

(modify_date >='2012-01-01' or modify_date <'2013-01-01')

select @van_id + replace(convert(varchar(11), @nextdel, 113), ' ' ,'') datekey from replicationLock

The above line is returning data to the client, which is causing the error

Do

SELECT @count = COUNT(@van_id + replace(convert(varchar(11),...

1 time transfer or continuous transfer?

1 time, use import export data wizard, SSIS, BCP etc

continuous I would look at replication

Ed Wagner (2/18/2013)

---

Personally, I like collecting this type of data all in one place. It allows me to run reports on a single table instead of having to hit...

Yes a SQL Agent alert for that

http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/