From syslogin view am only able to get logins and database names.Is the database names are those to which they are mapped or just the default database in the logins.What...

Am really sorry for that and will definitely try to eliminate mistakes like this.

Thanks for your help

I got error that the present version is lower than the backup of master.The present one had sp3 ,thinking that earlier one had sp4 i installed sp4 and now the...

Will Restoring the master DB gives the mapping of all users to respective databases???

Command prompt showing

2008-09-01 14:38:26.40 spid4 Recovery complete.

2008-09-01 14:38:26.41 spid4 SQL global counter collection task is created.

2008-09-01 15:15:36.50 spid51 Using...

Given the command sqlservr -c -m at its taking so long displaying messages like executing procedures.What to do am i going through the right way??

stopped services.

run sqlservr -c -m

Can...

Hi ,

Given the command sqlservr -c -m before 2 hours and its still showing some messages like running some procedure and all.Why sql...

How long will it take to start in single user mode and how to come out of single user mode??

Hi,

When i tried to start the sql server in single user mode am getting the error

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr.exe -c -m AST0

26

2008-09-01 13:35:26.83 Server Error:...

Thanks a lot

The latest backup is one took last friday.

Ya i have one..

Really nice article.

Can anyone please tell how to include the report option in the summary of SSMS?

Hi ,

How can i insert three column values together in a single column and i need a space of char(13) in between each...

Solved the issue using case...:P