[font="Verdana"]Hi,

Welcome to sqlservercentral.com 🙂

This forum is related to SQL Server 2005 and hence you need to post all your SQL 2000 queries @ SQL Server 7,2000 section.[/font]

[font="Verdana"]Hi,

You can't export the entire database in csv format. You can only export table details in CSV format. To import csv format I hope can use import \ export wizard...

[font="Verdana"]Hi,

Database mirroring will work @ database level only and hence all the changes carried out in the databae will be taken to the mirrored db. If the schema change is...

[font="Verdana"]Hi,

Can you provide your exact requirement. You wont be able to track all the proc that is not scheduled as a job, if you need to track those procs either...

[font="Verdana"]Hi,

You can get all the features in SSMS. Connect to SSMS and expand sqlagent to work with it. If Sqlagent is not listed in SSMS then you may be lacking...

Hi,

Can you post the exact query you are using??

[font="Verdana"]Hi,

When you copy master db's physical file from one server to another server, sysaltfiles table will be updated with respect to the old server and if you start sql service...

[font="Verdana"]Hi,

You can also do this in GUI. The error you have given is specific and saying the folder doesn't exist. Hence you can connect to Integration services through SSMS and...

[font="Verdana"]Hi,

The path you have used above is not added in environment variable thus you are getting the error. Add that binn folder to your environment variable, hence going forward you...

[font="Verdana"]Hi,

Either you can go for manual un-installation or you can use Windows cleanup utility to remove SQL 2000, check out the links below.

How to manually remove SQL Server 2000 default

Description...

[font="Verdana"]Make sure SQLAgent account has necessary permission in the share folder!

If you are having legacy package of SQL 2000 DTS then copy that DTS to a folder and then make...

[font="Verdana"]Create an alias in the client machine to point to the server in right port and then try again.[/font]

[font="Verdana"]Hi Steve,

I had a doubt then, Suppose if the user drops SP @ 9:00 and full backup happens @ 10:00. Is it possible to read the tlog using 3rd party...

*) Login to the source instance, take backup of the db

*) Login to the destination instance, restore the db from backup, you need to use WITH MOVE parameter to place...

[font="Verdana"]Hi,

You can design an SSIS package to export the tables to excel \ csv etc on another server.

Share the folder in the destination server

Provide modify privilege to Source server SQL...