Dear Arvind,

You can use the extract.exe utility which comes with windowsxp or windows support tools or you can use any commandline zipping utility(...

Dear Arvind,

Log shipping does not allow you to zip or unzip the logs as it is a completely automated process. Please have a look at...

Dear Friend,

Please checkout the scripts given in this site. It will help you. One of my query was working fine for the...

Dear All,

we have a team of 4 sql dba's and none of us were there at that time and no...

Hi Friend,

Plz use the following procedure.

1. Open the following file in any notepad editor

c:\WINNT\SYSTEM32\DRIVERS\ETC\hosts

2. Type the following in the file

IPADDRESS ...

Hi Friend,

Plz use the following procedure.

1. Open the following file in any notepad editor

c:\WINNT\SYSTEM32\DRIVERS\ETC\hosts

2. Type the following in the file

IPADDRESS ...

Hi Friend,

You can do that. Refer sp_addlinkedserver in the SQL Books online or the microsoft site or you google.

Thanks & Regards

Chandra Mohan N

Dear Shekhar Naidu,

 I had also faced the same problem. In our situation we had installed sql server 2000 and created some scheduled jobs and after that we had renamed the...

I did not ask for the space left in the database. I want the diskspace in the drive where the database resides to be sent to everyone of my colleauge...

Dear Peter,

Thanks for your kind reply. You had given procedure for getting the good employees. But is there any way to detect the employees who are forming a chain.

Thanks

Chandra...

Dear Peter,

Yes I had understood. But I had nearly 15 levels of employees. So is there any method to find out where it forming a chain.

Thanks in advance

Chandra Mohan N

Dear Peter,

Yes my problem is also the same. But when I had checked the table with the condition.

select * from employee where empid=managerid. But i did not get any results....

Dear Michael,

        It just calculates bonus, taxes etc....