We are using the xml technique mentioned in this article in our system and it works like a charm.

I used this and found a proc which is doing a table scan. I put index and then reran this proc again. It is still saying as table scan. But...

I looked into the article. We don't have so many sql users in the system. Also I'm not just getting this error using SMO. This error is happening for applications...

I did put in SP3 yesterday into the SQL Server box. It is still happening, but this time there is no error in Event Log, but the error is in...

We have logshipping going on in our database. Do you think that might have caused this issue? Other than that we don't have anything going on at the time this...

[252] Failed to retrieve operator 1 from the server

[298] SQLServer Error: 233, Shared Memory Provider: No process is on the other end of the pipe. [SQLSTATE 08S01]

Message

[298] SQLServer Error: 233,...

Ok I will try that. But do you know why i get the error with the sql server that I mentioned before?

No I did not. But even if I have enabled DAC, I have restart the service with flag 7806 right. When I restart the service, my sql server started working.

I found out what is causing the deadlock. It is the checkpoint that gets into deadlock with the transaction.

Data is kept in log file and will be written whenever a checkpoint occurs.

You can restore it if you ahve a log backup or full backup before you dropped the tables.

How r u trying to reduce the size? If the database is in full recovery mode you cannot reduce the size without taking a log backup or full backup.Once a...

For example when you are creating a database,

CREATE DATABASE Sales

ON

( NAME = Sales_dat,

FILENAME = 'c:\mssql7\data\saledat.mdf',

SIZE = 10,

MAXSIZE = 50,

FILEGROWTH = 5...

Physical name of a database is the path along with the name of the file you give to store the database in that path eg:(c:\pubs.mdf). Logical name is the name...

Thanks a lot Guys.