Viewing 15 posts - 16 through 30 (of 33 total)
Can you post the output of sp_configure
October 5, 2012 at 11:55 am
with those permissions user can see the jobs that he owns.
April 12, 2012 at 3:47 pm
Logins are created at server level, master database holds them.
February 28, 2011 at 11:42 am
DBA's should have read/write/copy/paste permission on all SQL server folders.
February 13, 2011 at 9:16 am
1. I assume you're local admin group of server.
2. RDP to the server.
3. On command prompt NET STOP MSSQLSERVER (stop sql server)
4. On command prompt NET START MSSQLSERVER /m (start...
December 8, 2010 at 8:36 am
For me it's failing on transfer/copy database objects task.
November 24, 2010 at 8:54 am
Restore your database on SQL 2008 instance and then change the compatibility level to 90
November 24, 2010 at 8:36 am
Check these two articles for more information. It might help you.
http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx
http://msdn.microsoft.com/en-us/library/ms143393(SQL.100).aspx
November 24, 2010 at 8:08 am
Yes :
RDP to the server:
1. Under local group policy in user rights assignments, you will have to assign service account to
these privileges:
Act as part of the operating system
Adjust memory quotas...
November 23, 2010 at 12:33 pm
I have seen the same issue in SQL 2005. When you backup tlog, SQLServer commits the transactions and once commited it can't be rollback.
November 21, 2010 at 9:30 am
By default they won't be member of any group but both of them would have some permissions assigned in local group policy security settings, in case you want to use...
November 21, 2010 at 8:22 am
What is version of SQL Server?
How did you change the instance name?(please mention all the steps)
November 21, 2010 at 7:58 am
You can force SQL Server to release memory. Schedule a job which will run every 15 minutes with
commands given below.
DBCC FREESESSIONCACHE
go
DBCC FREESYSTEMCACHE ( 'ALL' )...
September 9, 2010 at 9:00 am
I assume you're running sql agent service also under "WEB-1244\SQLAdmin".
This account requires "create files / write data" permissions as well on those folders.
September 8, 2010 at 12:53 pm
What all permissions service account has on EXE file and on the folders?
Does package saves connection information within itself or uses config file?
September 8, 2010 at 12:23 pm
Viewing 15 posts - 16 through 30 (of 33 total)