That's probably due to the account SQL Server is using having been logged in before the additional rights were granted. Same as when a user is logged in and...

Default path is C:\Program Files\Microsoft SQL Server\80\Tools\binn\sqlslic.cpl

NB - this is for SQL 2000 only

My grandfather used to play piano, violin, guitar. My mother played piano (she tried teaching me when I was a kid, to no avail. Neither of us had...

What error are you getting?

Check the SQL Server licensing tool in Control Panel.

Can you ping the server from the machine by name and IP?

Like the error said, sys.fulltext_catalogs is a view, not a stored procedure. You cannot EXEC it, you have to SELECT from it.

I don't know what mechanism SQL uses. From the MS SQL Server 2005 Admin Pocket Guide:

[font="Times New Roman"]When the backup starts, SQL Server copies everything in the database and...

How about the SQL Server Agent account? What rights does that have?

jack_stockton (5/13/2008)

---

I have read about it only.

If I understand it:

1. I would start with a granting limited rights to a trusted group, enough to be able to run a stored...

Have you looked at using an application role?

Because the SQL Server service account does not have rights to stop services on that machine.

What rights does the SQL Server service account have on the machine where the service...

The full backup contains the state/data of the database at the time the full backup FINISHED (including whatever log records are required to get the database in a consistent...

Try DBCC UPDATEUSAGE

You could probably do it with a batch file full of sqlcmd calls. However, that means your sa passwords (don't use the same one for all servers, not good...