Viewing 15 posts - 2,341 through 2,355 (of 5,394 total)
anthony.green (11/18/2011)
could grant execute on sp_start_job only to the account in question, then pass it the job_id
Wouldn't work. Does some checks internally to make sure the user is a member...
November 18, 2011 at 6:23 am
This thread should help you: http://www.sqlservercentral.com/Forums/FindPost1189112.aspx
November 18, 2011 at 6:18 am
Another way could be using a loopback linked server and execute the procedure as a pass-through query: http://spaghettidba.com/2011/11/16/discovering-the-output-of-dbcc-commands/
The technique described there uses DBCC commands, but it works with any pass-through...
November 18, 2011 at 6:16 am
Grant Fritchey (11/18/2011)
If the internal proc returns a data set... there's not much you can do. What is it that you're trying to do with the procs?
Well, you could always...
November 18, 2011 at 6:13 am
UPDATE STATISTICS requires ALTER permission on the table or view.
November 18, 2011 at 6:10 am
river1 (11/17/2011)
I am trying to rename a file through SQL Server.
I don't want to irritate you with useless so-called advice, but... why are you doing it in T-SQL?
Don't you think...
November 17, 2011 at 9:23 am
This should do (untested):
DECLARE @docHandle int
DECLARE @xmlDocument xml
DECLARE @xmlFilePath nvarchar(max)
DECLARE @sql nvarchar(max)
SET @sql = '
SET @xmlDocument = (
SELECT...
November 17, 2011 at 7:31 am
Silly question: is it a copy-only backup?
Not sure of the reason behind, but I've had several issues with copy-only backups in the past.
November 17, 2011 at 7:17 am
Dev (11/17/2011)
Gianluca Sartori (11/17/2011)
Dev (11/16/2011)
You cannot restore the backup of a compressed database to an uncompressed database.
I didn't know this one. Can you please clarify...
November 17, 2011 at 7:15 am
I don't think it's a SQL Server issue at all.
It says a different thing: "Class not registered". I guess it's a registry / windows policies permissions issue.
I would trace...
November 17, 2011 at 7:10 am
You could try to turn it into an ITVF.
It wouldn't make much sense either, but it would be faster at least.
November 17, 2011 at 7:00 am
From command prompt:
SC DELETE ServiceName
November 17, 2011 at 6:35 am
GilaMonster (11/17/2011)
An index consists of one or more columns from a single table only.
Unless you set up an Indexed View, but I suspect am sure it wouldn't help at all...
November 17, 2011 at 3:54 am
Dev (11/16/2011)
You cannot restore the backup of a compressed database to an uncompressed database.
I didn't know this one. Can you please clarify what you mean with "compressed...
November 17, 2011 at 2:50 am
It should definitely work with square brackets.
If you created the linked server successfully, navigate your object explorer to one of the remote tables, right click and select "Script Table as...
November 17, 2011 at 2:40 am
Viewing 15 posts - 2,341 through 2,355 (of 5,394 total)