From memory, to change a change owned by another user, you need to be a sysdamin. Have a read of http://msdn.microsoft.com/en-us/library/ms188283.aspx for more info

You will need to install the oledb driver for excel on the server where sql server agent is running. Not sure which version you will need but have a...

lisa.randles (10/21/2014)

---

I just can't seem to find the info I'm looking for...

Currently our RS, AS, and IS share a single server. Is it possible/recommended to install them each on...

This should get you started...

select 'DROP PROCEDURE [' + routine_Schema

+ '].[' + routine_name + ']'

FROM INFORMATION_SCHEMA.ROUTINES

where routine_name like 'Easy_UpdateSchemaTemp%'

this will output the drop procedure statements you need. You...

ramana3327 (10/15/2014)

---

Hi,

When I see linked servers under the server objects node from Server A, there is a linked server created to Server B.

Under that Linked ServerB, I saw server type...

IT sounds like the package is using SSIS configurations to get the server name for the file path. Open the package in Visual Studio and from the SSIS menu,...

I get error

Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

because "Column" is a reserved keyword and needs to be delimited if you want...

acrutchley (10/10/2014)

---

Hi,

I have a requirement to parse IIS logs into a database, the IIS logs will be coming from multiple server/directory location.

So far I have come up with the...

Try running management studio "As Administrator" and then connecting to SSIS.

The current secondary does not need a maintenance plan - it is not updateable and attempting to do index maintenance would require updates to be done.

The results of any index...

The "command" column actually contains the full text of the restore command. You will need to use something like

SELECT session_id as SPID, command, aa.text AS Query, start_time, percent_complete,

dateadd(second,estimated_completion_time/1000, getdate())...

No - you cannot do this. The processes that are executed by SQL Agent are not ever associated with any display device.

johnnyrmtl (10/1/2014)

---

Hello all,

This is my first experience with this type of installation and it seems a bit tricky .

I have two nodes of a windows 2012 cluster with an install...

As far as I am concerned, this is another dodgy question. The sample data includes 4 rows only. Personally, I read the suggested answer and treated the extra...

I am not sure that you can add a tooltip to the labels on an axis. You can change the font size which might help. You can also...