You had restarted the service while some operation is happening and now the process should be in roll back or roll forward mode. So sql server initiated the auto...

check whether do you have performed any dml operation (update, insert or delete) on the database and it is still running. Check you have enough free space on disk...

Your problem is not clear. Please be ellaborate to understand your problem.

We didn't add the db_datareader role which will permit the user to perform select operation on the user table. Execute the below statment to provide the same.

Exec sp_addrolemember db_datareader,...

T-sql, maintenance plan and even if you are using third party tool the information will be stored in these tables.

I think you are having problem in sequencing the transaction log files. The below query will help you to sequence the same.

SELECT b.physical_device_name,

a.backup_set_id,

Case When...

Follow the below steps, if you need to create SQL Logins instead of windows

-- Creating Login For Principal

Create Login [PrincipalLoginName] With Password = 'GiveYourPasswordHere', default_database = [GiveYourDBNameHere], Check_policy = OFF;

--...

Verify the owner of the SP. It might have created by a username other than dbo, probably by the username you used while creating this SP. (i.e) [UserName].[SP_Test]...

@Lowell - Thanks for pointing me to a better solution.

@ken - I am analyzing your solution. I will get back if I have and doubt. Thanks.

If you are using Windows XP, you can right click on the Managment Studio and click on "Run As...". Click on the option "The following User" and enter your credentials.

@ Elliott W and CirquedeSQLeil

I got the problem. My sql server instance is installed in the port 1434. Since the sql browser is reserved to use the port 1434...

It's better to go through the application and list out the objects used in the application and remove other objects from the database. And make a practive of creating...

There is no second thought in using NT authentication, but we have to be flexible some times and use a sql authentication as it is not possible always ( particulary...

Thanks for a your reply Mani.

As a work around, I had shared a sql login for that user in the dev box ( the project is in development) and he...

Yes. And also whenever the ServerA/Instance01 is principal and ServerB/Instance02 is witness then the quorum gets lost. I need to identify why the quorum is getting lost in...