显示标签为“tasks”的博文。显示所有博文
显示标签为“tasks”的博文。显示所有博文

2012年2月13日星期一

Batch file to restart SQL

Hey all.. I am wanting my SQL Server installation to restart its services at a time I define in the Scheduled Tasks feature of the server its on

I need help with command line commands to:
- Stop SQL Server Agent service
- Stop and Start SQL Server service
- Restart SQL Server Agent service

Thanks in advance

from the command prompt:

>net stop MSSQLSERVER
>net start MSSQLSERVER

>net stop / start SQLSERVERAGENT

2012年2月9日星期四

Basic security questions

Hi,

I am new to SQL 2005, can someone give me some details instructions about how to do below two tasks:

  1. All my developers are in a window domain user group, I need to grant dbo privileges to that domain group so then can do the their development work. The rule is all objects they create need to be owned by dbo not by there ID.( I can’t do it because I got “ The “Deafult_Schema clause cannot be used with a windows group”)
  2. Same as above but this time they only need select permission on tables nothing else.

Many thanks.

PC

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=678115&SiteID=1 and the thread referenced there.

Thanks
Laurentiu