grant exec to windows account

When i do
grant exec on sproc1 to 'domain\user'
it returns
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'domain\user'Hi John
Use [ ] instead of quotes:
grant exec on sproc1 to [domain\user]
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"John Doe" <Johndoe@.jd.com> wrote in message
news:Oj4ImmmbIHA.1212@.TK2MSFTNGP05.phx.gbl...
> When i do
> grant exec on sproc1 to 'domain\user'
> it returns
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'domain\user'
>

Grant backup permissions at server level ?

Hi There

The backup database permission seems to only be at a database level , grant backup database and db_backupoperator role only exist at a database level.

However i want to permission to a user to backup any database, and he must not be a sysadmin. I cannot find a server level role that can backup databases.

How can i do this? There are alot of database so granting the permission for every database seems a waste of time, also one would have to remember every time a new database is created to grant this permission.

There must be a way to do this at a server level?

Thanx

In 2005, you can grant CONTROL SERVER, but that would seem too open (almost as bad as sysadmin), so no, you will probably have to add that to your "new database" checklist (or write a procedure that will create the DDL for creating a database and include the GRANT statements/reminder to add GRANT statements.)

They must be really careful with who gets BACKUP privileges, because if you can do a backup, you can do whatever you want with the data in the database.

Good Enterprise Level Monitoring Tools

What are some good enterprise level monitoring tools that one would suggest
for a 24/7 shop that monitors end to end application performance.. i.e from
Web to Application Server to SQL Server.
Please do share your experience.
Thanks
We use MOM - Microsoft Operations Manager
http://www.microsoft.com/mom/default.mspx
HTH. Ryan
"Hassan" <Hassan@.hotmail.com> wrote in message
news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
> What are some good enterprise level monitoring tools that one would
> suggest for a 24/7 shop that monitors end to end application performance..
> i.e from Web to Application Server to SQL Server.
> Please do share your experience.
> Thanks
>
|||ProIT is a very nice tool for enterprise monitoring, if you dont care that it
isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
what your company rules are. ProIT is web based, has a bunch of decent
management packs, very nice trending and snapshot reporting, and easy to
configure alerts. Doesnt take long to get it installed and working at all.
Only downside at the moment is that there are no agents for Sybase or Sun
Solaris 10, but they have agents for almost every other database and OS. All
the Microsoft ones are covered.
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Ryan" wrote:

> We use MOM - Microsoft Operations Manager
> http://www.microsoft.com/mom/default.mspx
> --
> HTH. Ryan
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
>
>
|||We have other OSs and DBs as well and is not a Microsoft shop..
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:26A6C557-5592-4426-92E7-02B1D3084098@.microsoft.com...[vbcol=seagreen]
> ProIT is a very nice tool for enterprise monitoring, if you dont care that
> it
> isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
> what your company rules are. ProIT is web based, has a bunch of decent
> management packs, very nice trending and snapshot reporting, and easy to
> configure alerts. Doesnt take long to get it installed and working at all.
> Only downside at the moment is that there are no agents for Sybase or Sun
> Solaris 10, but they have agents for almost every other database and OS.
> All
> the Microsoft ones are covered.
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "Ryan" wrote:

Good Enterprise Level Monitoring Tools

What are some good enterprise level monitoring tools that one would suggest
for a 24/7 shop that monitors end to end application performance.. i.e from
Web to Application Server to SQL Server.
Please do share your experience.
ThanksWe use MOM - Microsoft Operations Manager
http://www.microsoft.com/mom/default.mspx
HTH. Ryan
"Hassan" <Hassan@.hotmail.com> wrote in message
news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
> What are some good enterprise level monitoring tools that one would
> suggest for a 24/7 shop that monitors end to end application performance..
> i.e from Web to Application Server to SQL Server.
> Please do share your experience.
> Thanks
>|||ProIT is a very nice tool for enterprise monitoring, if you dont care that i
t
isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
what your company rules are. ProIT is web based, has a bunch of decent
management packs, very nice trending and snapshot reporting, and easy to
configure alerts. Doesnt take long to get it installed and working at all.
Only downside at the moment is that there are no agents for Sybase or Sun
Solaris 10, but they have agents for almost every other database and OS. All
the Microsoft ones are covered.
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Ryan" wrote:

> We use MOM - Microsoft Operations Manager
> http://www.microsoft.com/mom/default.mspx
> --
> HTH. Ryan
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
>
>|||We have other OSs and DBs as well and is not a Microsoft shop..
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:26A6C557-5592-4426-92E7-02B1D3084098@.microsoft.com...[vbcol=seagreen]
> ProIT is a very nice tool for enterprise monitoring, if you dont care that
> it
> isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
> what your company rules are. ProIT is web based, has a bunch of decent
> management packs, very nice trending and snapshot reporting, and easy to
> configure alerts. Doesnt take long to get it installed and working at all.
> Only downside at the moment is that there are no agents for Sybase or Sun
> Solaris 10, but they have agents for almost every other database and OS.
> All
> the Microsoft ones are covered.
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "Ryan" wrote:
>

Good Enterprise Level Monitoring Tools

What are some good enterprise level monitoring tools that one would suggest
for a 24/7 shop that monitors end to end application performance.. i.e from
Web to Application Server to SQL Server.
Please do share your experience.
ThanksWe use MOM - Microsoft Operations Manager
http://www.microsoft.com/mom/default.mspx
--
HTH. Ryan
"Hassan" <Hassan@.hotmail.com> wrote in message
news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
> What are some good enterprise level monitoring tools that one would
> suggest for a 24/7 shop that monitors end to end application performance..
> i.e from Web to Application Server to SQL Server.
> Please do share your experience.
> Thanks
>|||ProIT is a very nice tool for enterprise monitoring, if you dont care that it
isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
what your company rules are. ProIT is web based, has a bunch of decent
management packs, very nice trending and snapshot reporting, and easy to
configure alerts. Doesnt take long to get it installed and working at all.
Only downside at the moment is that there are no agents for Sybase or Sun
Solaris 10, but they have agents for almost every other database and OS. All
the Microsoft ones are covered.
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Ryan" wrote:
> We use MOM - Microsoft Operations Manager
> http://www.microsoft.com/mom/default.mspx
> --
> HTH. Ryan
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
> > What are some good enterprise level monitoring tools that one would
> > suggest for a 24/7 shop that monitors end to end application performance..
> > i.e from Web to Application Server to SQL Server.
> >
> > Please do share your experience.
> >
> > Thanks
> >
>
>|||We have other OSs and DBs as well and is not a Microsoft shop..
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:26A6C557-5592-4426-92E7-02B1D3084098@.microsoft.com...
> ProIT is a very nice tool for enterprise monitoring, if you dont care that
> it
> isnt a Microsoft product. Some shops are purely Microsoft, so I dont know
> what your company rules are. ProIT is web based, has a bunch of decent
> management packs, very nice trending and snapshot reporting, and easy to
> configure alerts. Doesnt take long to get it installed and working at all.
> Only downside at the moment is that there are no agents for Sybase or Sun
> Solaris 10, but they have agents for almost every other database and OS.
> All
> the Microsoft ones are covered.
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "Ryan" wrote:
>> We use MOM - Microsoft Operations Manager
>> http://www.microsoft.com/mom/default.mspx
>> --
>> HTH. Ryan
>>
>> "Hassan" <Hassan@.hotmail.com> wrote in message
>> news:ugNaQxkTGHA.4340@.TK2MSFTNGP10.phx.gbl...
>> > What are some good enterprise level monitoring tools that one would
>> > suggest for a 24/7 shop that monitors end to end application
>> > performance..
>> > i.e from Web to Application Server to SQL Server.
>> >
>> > Please do share your experience.
>> >
>> > Thanks
>> >
>>