Add the full path in your @txt parameter like this:

set @txt = 'C:\Program Files\Winzip\winzip.exe -a V:\Data_1\'+@db_name +'.zip V:\Data_1\'+@db_name+'.mdf'

Exec master..xp_cmdshell @txt

The only way you can achieve what you want is using logshipping, which would give you read access to the database. With any other solution using backups you always...

All these proceures and the dtpropertties table are used to create diagrams in SQL 2000. You can safely ignore them when transferring you're data. If your new server is SQL...

Alan,

the reason for the "insufficient memory" messages is very likely that the largest available contingous memory block is smaller than the maxtransfer size for the backup. The default blocksize...

WHen you double-click a table in EM you call a stored procedure which uses the rowcnt column in the sysindexes table, while your query in QA does an actual count...

Check out this article:

http://support.microsoft.com/kb/319892

This procedure is used for replication and I think it will only added to your system when you run the configure publication/distribution wizard.

If you have done this already and...

Without knowing what exactly you try to achieve and no ddl I can only guess.

Does it matter which record is returned or do you just want any record?

Can't you...

Adding to the previous replies if you really backing up a very large database, you might want to backup to more than one file. Depending on your disk subsystem this...

Sorry, but this is the question:

How many network protocols are available on SQL Server...

Defining an alert is not depending on SQLMail.

What I think you're actually looking for is another way to send out notifcations. By default SQL Server also supports netsend and...

NO, the indexes on a temporary table you have to create yourself. Statistics on the other hand are...

Without knowing your code or even how much data your touching, it's difficult to give a full answer but what comes to my mind is the fact that temp tables...

Oops,

Ramesh my mistake I wanted to say exactly this, that shared memory can only be used to connect to a local instance. So it doesn't access the network. That's...

What exactly are you missing. You say"especially the Service Manager suite". If you mean the small utility which in SQL 2000 sits in the system tray, that no longer exist...