Viewing 15 posts - 91 through 105 (of 346 total)
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 15, 2008 at 3:55 pm
Default path is C:\Program Files\Microsoft SQL Server\80\Tools\binn\sqlslic.cpl
NB - this is for SQL 2000 only
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 15, 2008 at 3:50 pm
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 15, 2008 at 2:45 pm
What error are you getting?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 10:22 pm
Check the SQL Server licensing tool in Control Panel.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 10:18 pm
Can you ping the server from the machine by name and IP?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 8:05 pm
Like the error said, sys.fulltext_catalogs is a view, not a stored procedure. You cannot EXEC it, you have to SELECT from it.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 7:07 pm
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 7:01 pm
How about the SQL Server Agent account? What rights does that have?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 6:37 pm
jack_stockton (5/13/2008)
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 14, 2008 at 6:33 pm
Have you looked at using an application role?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 13, 2008 at 4:07 pm
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 13, 2008 at 3:52 pm
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 13, 2008 at 3:42 pm
Try DBCC UPDATEUSAGE
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 13, 2008 at 3:34 pm
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 13, 2008 at 3:33 pm
Viewing 15 posts - 91 through 105 (of 346 total)