Obviously, i don't think that someone will install Client tools on the Production Server. That too just to Execute something. 🙂

DBA's work remotely all the time until and unless theres...

Thanks.

now its Clear to me.

Ok, so if i want to commit all the changes at a rapid speed i can request a checkpoint with a small duration & SQL will put all the required...

It will create Different-tables for all your tables at your destination server with table names prefixed with 'Diff_'

and these tables will have all the adjustment statements.

eNJOY:-)

This query will help you.

select 'tablediff -sourceserver .\sql2k5 -sourcedatabase test12king -sourcetable '

+ TABLE_NAME

+ ' -destinationserver . -destinationdatabase test12king -destinationtable '

...

:unsure: but i want to know the current duration

I'll try this tool.

Passwords are always Case-sensitive whether you talk abt SQL Server 2000 Or SQL Server 2005.

0ops :unsure:

Hi Kuldeep,

If you want to execute DTS Packages in SQL Server 2005 as a DTS Package only, you can download and install DTS Designer, its a utility given by Microsoft.

It...

May be.

I haven't tried it. I use SSIS but to transfer logins this sp seems gud to me and moreover it has been tried and tested on many instances of...

Hey if you've Full or Bulk-Logged Recovery MOde than chances are you can recover your 100% data without any loss.

For this you should have:

1. Full Backup prior to this incident.

2....

Dean, i am not getting you.

What do you mean by

In SQL...

What sort of permission problems you are facing, pls. share so we can help you.

Hey thanks Dude.

I've to try this but if this works this can be tweaked to use for many other things also. 😉