Hello Igor,

Can you check the Application Log in the Event Viewer?

Hope that might give you more clues to your problem.

Thanks

Hello,

If you want to clear of the Buffer Pool to check up the execution time, then you need to use DBCC FREEPROCCACHE. The execution times might differ as it has...

Hello Sheba,

It seems the SQL Server Agent Service is not started on the server from where you are trying to take a backup using Enterprise Manager. You check up by...

Hello,

In order to work with SQL Server 2000 just like 2005 SQL Server Management Studio, you need to have 2000 Enterprise Manager i.e., for registering the servers etc. If you...

Hello Khan,

Can you check whether you are getting any data into your local variable for @vcBody by printing them whereever used in the query?

It might be the...

Hello,

You can have both versions of Books Online on the same machine. You can download a copy of 2000 Books Online in .chm format and save it at the desired location.

Hope...

Hello Terry,

I'm not sure of what the actual scenario you have encountered but thought that these links might give you some lead in finding out the problem.

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

http

Hello,

Please refere these links and you might get some clue:

http://support.microsoft.com/kb/903002

http://www.examnotes.net/archive79-2002-10-69316.html

Hope this helps. Please post back any details which might be useful for others.

Thanks

Hello,

Can you check this one

DBCC SHOW_STATISTICS

Hope this helps.

Thanks

Hello Anita,

You need to use the statement like this

Convert(Varchar(20), dbo.MyDate, 108)

Hope this helps you.

Thanks

Hello,

Use

SET ANSI_WARNINGS  OFF

to suppress the warnings.

Hope this helps.

Thanks

Hello Elliott,

You can change the option as follows:

Go to Tools -> Options

Under Query Results -> SQL Server -> Results to Text -> Output Format

Change the default "Comma aligned" to "Tab...

Hello Reddy,

You can change the default parameters to the desired number of bytes. Click on Database Mail -> Select Configure DB Mail -> Next -> Select the radio button "View...

Hello Kourosh,

You are confused with restore and detaching the files.

When you take a backup and try to restore it on a different server, the logical file names will be the...

Hello Eric,

There exists only one row indicating "US_English". But for, UK it will be "British English" and the langid is 23.

Can you check once again in the results?

Hope this helps.

Thanks