According to this blog http://itsalljustelectrons.blogspot.ch/2016/05/SQL-Server-Alter-Database-Oddities.html there is not way to roll it back. The final part of the article is not clear. A recovery model chenge for a database member...

I am afraid you are facing quite a difficult task. Trying to find out what users need based on a trace is difficult. You will see what is used but...

On our test server we have build 10.0.1600.22. I was thinking that eventually the date format could give some problems. When I run the query I don't get errors, but...

I get the list of the scheduled jobs, which are working without problems.

In the properties of the job, under steps, advanced it is possible to enable logging to the...

Uh, is it really the same Problem ? Perhaps you should try to check the server performance with perfmon to find out if the HW has some problem. In my...

It may be a stupid question, but you have installed sql 2005 as named instance ? If both are as default, you will have definitely a problem. The error you...

If you have SQL2K and SQL 2005 started at the same time on the same machine, they cannot listen both on 1433. One of the instance is probably listening on...

I am not sure where the problem is. Check out this documentation http://technet.microsoft.com/en-us/library/bb326356.aspx. Make sure you install SP2 for reporting services. You can use the Default Web Site as...

We backup through maintenance plans. It is quite easy. Once a day a full backup is taken (7 pm). A transaction log backup is started every 3 hours starting from...

At the end I think that the most important thing is to check what the DBA has to do on the server and if he has the required skills. In...

You can also list the needed permissions for a user and apply them through a security template on the SQL Server. In this way you DBA have permissions to start...

OK I see your point. Let say, if domain is microsoft.com type microsoft\username

John,

without knowning which permissions are needed from the application you can get some problems. In my opinion you should insist by the vendor to document the application. You are the...

Hey, maybe I got it use mwdc\username without .net otherwise SQL get a problem....I bet now it will work

Define the permissions needed by the users or different group of users. Then you can consolidate them under roles if you wish. I would not give db_owner.

For instance if...