any one has any ideas

any one has any ideas

any one help me out

any one help me out............

thanks man.. yes vendor is having FTP site.

plz help...

Thanks i got it

but now i am getting new error..

Msg 15404, Level 16, State 5, Procedure xp_logininfo, Line 42

Could not obtain information about Windows NT group/user 'NT SERVICE\MSSQLSERVER', error code...

my doubt is how to send the backup file to vendor through FTP

Thanks . I got it

Thanks for all your replys

is it necessary to have primary key on each table.

i am confused related to primary key and clustered index.

so far i know that primary key on a column creates...

Thanks for your valuable suggestions.

does this do the job.

CREATE PROCEDURE sp_EmplyAllTable

AS

EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’

EXEC sp_MSForEachTable ‘DELETE FROM ?’

EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’

GO

Thanks for your advice.

if we take CPU option we can have multiple virtual servers that can be monitored with out extra cost .Am i right anthony.

if we have...