i am new to sql..........first time i am using extended sp.............

thanks.............

thanks ............got it.............

EXEC xp_cmdshell 'copy c:\folder1\file1

\\server2\folder2\file1, NO_OUTPUT';

correct?

master..xp_cmdshell 'copy C:\folder1 \\ + @Server1 '

is it correct?

in server1 , file is C:\folder1

i want to copy that file in server2 , file is D:\folder2

pls give the complete command.

i want to copy through xp_cmdshell ?

what is the command.............

thanks............

got it.........

select * from sys.tables

thanks....................

got it.........

select * from sys.tables

thanks.......................

what is select statement for retreiving the list of table in a database.

thanks...............

what are the advantages ?

thanks...............

thanks....

What I want is if I create a sqlserver login with a password in sqlserver authentication.

That information stored in master database.

where that informantion stored in the master databse?