Viewing 15 posts - 31 through 45 (of 185 total)
Use a SQLAgentUserRole (msdb fixed database role) if you need your user working on his own jobs only.
Use a SQLAgentOperatorRole (msdb fixed database role) if you need your user working...
October 2, 2009 at 9:07 am
This is the answer and a guideline:
you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Don't forget to patch the new instance after...
October 2, 2009 at 7:52 am
Silverfox (10/2/2009)
another way of doing it is to :DENY ALTER ANY DATABASE to [login]
make sure the master database is selected before running
In this case the developer cannot create/modify any database...
October 2, 2009 at 7:43 am
What are the advantages of 'Append to existing backup set' in the Back Up Database for SS 2005?
On other hand the big disadvantage of this option is a problem to...
October 2, 2009 at 7:36 am
It is a problem to put any limitations on the db_owner role.
Yes, db_owner cannot see properties of the own database (like file size) through GUI, but he can easily...
October 2, 2009 at 7:27 am
You may also want to check system requirements for installation of SS2008.
October 1, 2009 at 1:39 pm
What SQL Server edition are you trying to install (Developer, Standard, Enterprise, etc.)?
October 1, 2009 at 1:31 pm
espanolanthony (10/1/2009)
i need steps to upgrade sql 2005 to sql server 2008. some one please provide me whith step by step instructions.
You may want to be more specific, it is...
October 1, 2009 at 1:29 pm
espanolanthony (10/1/2009)
October 1, 2009 at 11:14 am
That is because you are running your script against master database, but not against your database.
In the beginng of your script you have to use
USE [YourDB_name]
GO
There is more...
September 29, 2009 at 7:40 am
As was mentioned above these changes were logged into SQL Server Log.
You can filter SQL Server Log files with text "Setting database option RECOVERY", and you will find history...
September 29, 2009 at 7:17 am
Is it as simple as Add/remove programs and restore a backup of master, msdb, and model?
Unfortunately you cannot uninstall SP3. According to Microsoft if you need it rolled back,...
September 28, 2009 at 11:58 am
Michael G (9/28/2009)
Hi,I'd like to find out the general feeling amongst dbas as to whether to go mixed mode authentication or not?
Cheers,
Michael
Microsoft recommends to use Windows authentication when possible:
http://msdn.microsoft.com/en-us/library/ms144284(SQL.90).aspx
But it...
September 28, 2009 at 8:53 am
You may want to see this thread about some possible issues in such mixed cluster:
http://www.sqlservercentral.com/Forums/Topic271610-146-1.aspx
In your situation it would be easier to upgrade both nodes to SS2008, but leave your...
September 28, 2009 at 8:37 am
Here is a list of updates inside the SP2:
List of updates in SP3:
http://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx
September 28, 2009 at 7:27 am
Viewing 15 posts - 31 through 45 (of 185 total)