The question was pretty simple.....! But I really liked it.

Since the @flg is defined with value = 1 and it is matching 1 again in Case statement so result should...

It was little tough...

Actually,

sp_spaceused only takes the 'table name' as parameter input. Can I get something similar results for SPs?

Actually....I got the mail from Application Support team. Few databases they want to drop,...

Thanks Paul... Lets give it a try at Test Server..

So does this mean that, there is no other way that I can retrieve the password being an admin. O.k.!

Thanks Gail. Since I am a DBA, certainly I have Server Admin rights and eventually I'm the 'sysadmin'. However, was looking for a solution other than 'changing the password'.

Is there...

Folks,

I guessed it very easily..

P2P replication is a newer arrival to SQL Server 2008 and certainly can't be available with SQL 2008 Standard Edtn. But Option -(3) doesn't look to...

Thanks Jason and everyone for putting up your valuable suggestion and comments. Many Thanx. Might be the question looked a little confusing due to the keywords which I used (E.g,...

Thank Perry Whittle. However, will the above sugestion work file for SQL Server 2000?

It is still online. Howvere unable to "use the database".

for second question--

Search object across all databases in instance--

http://www.sqlservercentral.com/Contributions/Edit/31650

----------------------------------------------------------

The above link is not opening!!

Sudhakara ,

That's strange..! The serverproperty gives entire details of the SQL server.

Again cross check the server name from services section.

Refer the link:

http://msdn.microsoft.com/en-us/library/aa933172(SQL.80).aspx

Try to free up space in the drive. What is the recovery model of the database? If possible, attach one more log file to a seperate drive where space available...

Henry, I myself too started thinking this could be due to the I/O bottlement only. Becoz the database log file growth is not very important, it doesn;t contain any user...

I'm trying to deploy a database from one of the servers to the server:SQLXX999YYY12

Do I need to change anything in the protocols? Pls suggest...

Error connecting to SQLXX999YYY12 (OSQL RC=1)....