Check this link...I hope this is what u want!

http://www.15seconds.com/Issue/010308.htm

Cheers!

Whats the value of this option in the source and destination db..This needs to be same. If both these dbs are the same...then u can ignore this point.

Are you doing...

Use the ConnectionTimeout property of the Connection Object and set an appropriate value for it.

Cheers!

I guess that will not work....finally when it gets to executing the Kill statement it will throw an error saying the Kill "expects a handle (SPID) tinyint."

Correct me if i...

What do you need this for? Can u tell me the background?

Cheers!

Also try running the backup to some other device say some other server on LAN.

Cheers!

If u want to view all the data in the QA itself...just go to options --> Results and increase the characters per column value. And run the query in Text...

Say for ex, you can use it to export the registry by

xp_cmdshell 'regedit /e registry.txt'

Change and import it back...Just a work around.

Cheers!

Frank Kallis has given/said the easiest way available which is not known to most since these are undocumented. But u can use the xp_cmdshell and your dos command to do the...

Hi Andy,

I hope u never asked...but now that u have...take this into account for the record as well.

i wud like the Cube from the logo along with a...

Use something like this once u have deleted the row...

and before inserting the new ones...

--If there was an error rollback the tran and quit(add other error handling if necessary)

IF @@Error...

Maybe you can also use a tool "DTS Backup" and take a backup and ask your clients to use the same to restore it...Its a pretty good tool.

Cheers!

Arvind

I guess u can write a small script with a variable that takes the value from maybe a cursor or another query and runs against each table!!

What do u think??

Cheers!

Arvind

If you really want only the execution time taken for the query, then simply declare a variable and store the result of gatdate() in it ...now execute the query and...

i think the problem with having the IIS, SQL Server and on top of it ur POP3 mails apart from performance might also affect the security of the server and...