Arindam Ganguly (2/19/2013)

---

Hi,

I have one point to ask. I have Backup compression enabled in my SQL Server. Can I restore any uncompressed Normal Backup. For the shake of information the...

Looks like you already have the product installed and you can only manage it via the control panel.

If you want to install it again you need to give it a...

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