Dear That's True,But How will I decide that When I should use it?

Thanx....Gila.....You are near to my bests.

Should I leave it Or it could give me better performance....My servers have 2 cpus of Intel Xeon..

Dear,

I am also not able to save the result of a query into a CSV file.After saving it doesn't give a readable format.

You have done a great job sethi...

One more thing is confusing me, I have a db server and web server.If anyone log in into website using user id password ...

If they are in sleeping mode yet can they be a reason of slow performance?

Is there any specific number that this much user could connect to sql server?

Can we...

If My database is fine yet I am restoring the snapshot for the database then what happen?what data will get by my original database.

1. Snapshot contains sparse file for updated...

Dear All,

Can I restore the database snapshot on another server..if yes then ?...

Thanx

How to use power shell ????

FYI...

The SSRS installation will create two new IIS sites, Reports and Report Server. The Reports physical directory is located at C:\ Program Files \Microsoft SQL Server \MSSQL.3 \Reporting Services \ReportManager....

Have u checked your IIS settings...

DBCC results for 'postal_survey'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services analyzed: 3.

Service...

Hi Gila,

Thanx to view the article....

Next Time I will post these questions in SQL 2000 forums in the future.

This database server is a development server.I am using the sa account.

Thanx

Dear Ratheesh,

I am getting this error:

Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.

Directory lookup for the file "S:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\postal_survey.mdf" failed with the...

Have u changed it on other side in connection string which is trying to connect to database