Viewing 15 posts - 2,341 through 2,355 (of 5,393 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...
-- Gianluca Sartori
November 18, 2011 at 6:23 am
This thread should help you: http://www.sqlservercentral.com/Forums/FindPost1189112.aspx
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
November 18, 2011 at 6:13 am
UPDATE STATISTICS requires ALTER permission on the table or view.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
November 17, 2011 at 7:00 am
From command prompt:
SC DELETE ServiceName
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
November 17, 2011 at 2:40 am
Viewing 15 posts - 2,341 through 2,355 (of 5,393 total)