I've had this in my powershell library for a long time; i use this powershell script to export everything out via SMO as individual files

http://www.sqlservercentral.com/Forums/Topic1240480-1351-1.aspx

the Redgate GUI has a wizard does a decent job of allowing you create SQL Jobs to regularly schedule the Full / Diff / Log backups , all based on...

it's built in, here's the best link i found when i googled that for you.

Add or Delete an Indicator (Report Builder and SSRS)

does the storedprocedure ServerB.MyDatabase.MyStoreProcedure itself use an additional call to a linked server, by chance? so it double hops?

i often get a similar error message when i create a new linked server, where i forgot to set the rpc and rpc out to true;

Executed as user:...

pretty sure the misisng pice is the service, if you've toggled both rpc settings in your linked server.

On the Target/linked server, Remote desktop over to it andopen services....it has a...

ahh, sorry.

DESC or DESCRIBE TableName will get you some information, not sure how pretty it will be over a linked server, but that's what you want to try.

you can use the two built in procedures which are used specifically for interrogating linked servers.

EXEC sp_tables_ex [OracleLinkedServerName] will get you started, but from there, you need to find a...

i think if you don't use the schema, and leave everything in dbo, you'll be fine.

as soon as you go cross schema, the user needs access to the underlying tables.

leaving...

the Database Master key always has an symmetric_key_id = 101, i read someplace, so my scripts all use that:

IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)

BEGIN

...

they are already sortable varchar values, so how do you want to sort them differently than the natural order by text via ORDER BY [ColumnName]?

the order you pasted them...

ok, confirmation.

Step 1: i enabled the DAC in facets on my test server. no restart or anythign required.

Step 2: i created this procedure with encryption.

--#################################################################################################

--developer utility function added by Lowell,...

if you connect via a Dedicated Admin Connection, i believe encrypted objects are visible as decrypted, specifically so you can debug and review.

not quite true, now that i'm testing...

you didn't login with that user.

execute as tests permissions on objects, it does not test whether they can login.

you literally have to connect via windows, as that user, and see...

you need to use Registered Servers and Central Management Server to help you administer your SQL servers.

both of them allow you to run the same script across all the servers...