Check the DisallowAdhocAccess property of the provider (under Linked Servers in Object Explorer).

I'll close by just saying it might be easier in the long run if you moved your efforts...

johnnycash (5/16/2012)

---

So my question is, is there a script, tool, or else that can scan the objects, find and replace the name reference? I don't have the time nor...

I think all that was pointed out with respect to syscomments is that it will not contain the entire proc definition in a single row if the proc definition contains...

When you drop a Script Component onto a Data Flow design surface you are asked what type of Script Component to implement. You would want to choose Transformation. This Script...

What are you trying to do?

ChrisM@Work (5/16/2012)

---

Stewart "Arturius" Campbell (5/16/2012)

---

This is overridden using the MAXDOP as part of the index creation command and...

Same as when upgrading from 2005 to 2008R2:

Upgrading SQL Server 2005 Log Shipping to SQL Server 2008

Please do not cross-post, it just fragments replies and wastes people's time. Direct all replies here:

http://www.sqlservercentral.com/Forums/Topic1300592-1281-1.aspx

Sure, it could be done using PowerShell. Here is a link to get you started:

Executing SQL the Right Way in PowerShell[/url]

Sorry for the late post that looks like a dupe. I had a window sitting in Reply-mode and got distracted. Happy you got it sorted.

WebTechie38 (5/16/2012)

---

Hello,

I am trying convert a stored procedure into an SSIS package. I thought SSIS would do a better job. Honestly, I'm starting to hate SSIS.

I have a...

Might I suggest another option?

CREATE TABLE #Temp

(

ResultColumn1FromProcedure INT,

ResultColumn2FromProcedure INT

-- etc.

);

INSERT INTO #Temp

(

...

I prefer to use PowerShell + SMO to do work like this. SMO is what SSMS uses when you right-click an object and choose to script it. The SMO object...

That looks correct. You could change the middle call to only show you the max memory setting so it's easier to see what it was before the change...and then maybe...

That looks like VBScript. You posted in a PowerShell Forum. You may have better luck looking online for a VBScript Forum, I do not know of one here on SSC.