hi Gail,

thanks for reply,

Both server n/w was getting reply,

agin i try to register second sever from server one. alternative i register first server to from second server.

same error display

error is...

hi gail,

thanks for reply,

i have checked all the activity

1. windows firewall stoped.

2. select the second server name from the list, not typed.

3. N/W is getting reply.

But second sql server 2000...

hi,

Thanks for reply.

I try to through register sql server wizard, and select the available server name, it was not successfully registered,

I got error msg like sql server server does...

1. First server name jgsrvr28

2.Second server name WJMN0130136

Both windows 2003 server running same domain. pls tell me how to registration from server WJMN0130136 to jgsrvr28.

hi jones,

please tell me how to execute script in sqlcmd, thaks

hi thushar,

Actualy what i want, this table script procdure retun value like

Table name,how much rows and total size of table, so i could get 3 result set.

The above script i...

hi Lester Policarpio ,

Thanks for reply me.

Script was working fine,

Hi, thanks for reply

This is not working, pls tell me if any changes required. actuly file name like Northwind Backup Plan4_200810111149.txt it has been created after completion of backup every...

Hi kishore, one more clarification, pls tell me

alter proc dateformatproc as

Declare @FileName varchar(255)

select @FileName = 'c:\Northwind Backup Plan4_' +

replace (replace (left (replace (replace (convert (varchar, getdate(), 120), '', ''),...

kishore, thank u very much for valuable reply

hi kishore, thanx for reply

It was working fine, but i need to be remove the sec in date.

as per query result is 20081013122619.txt

I want display only 200810131226.txt

thanks

hi sqldba,

pls give me sql script...

Thanks for help me...

Hi thanks for reply me,

Through Database maintenance plan i had configured database backup and backup report text file , so backup was taken daily scuccessfully,and i want send email from...

i need urgent that script,please help me, thanks

whenever using dbcc shrink log file, you have to specify the parameter how much you need the ldf file,

before shrinking ldf file, you have to mention the with_truncate olny