Hi,

Would you run the DBCC CHECKDB with the REPAIR_REBUILD option (after recovery from a backup/HA solution)? I seem to remember that this was the preferred option the MS 2005...

:blush: I humbly...

Yep - it works fine... As long as you do not use an alias, and use the server name and it's the default instance it works fine. It listens by...

You could always run a server side trace looking for the events and especially the TM: Rollback Tran Starting/Completed event to spot if the transaction was rolled back

Hi,

That should show you the packages if you used the option to save them into SQL rather than via the file system. Did you deploy and use a manifest...

Use the following to verify that it exists on the server and make sure that the integration services service is running to view via ssms

SELECT

COUNT(*)

FROM

msdb.dbo.sysdtspackages

..or try checking the the Sql log 😉

Re:

Keep in mind that should you ever need to use the dedicated admin connection, the browser service will need to be running and 1434 will need to be accessible.

I have...

I may be thinking along the wrong lines but I think that you can use the dmv's to get this info utilising the cached plans for 'adhoc/prepared' plans. From this...

Hi Guys,

Nice script but I would not advise putting this on a production box due to the SQL injection risk of the

-- Execute passed SQL.

EXEC (@SQLToRun)

part of...

You could always try using SQL profiler when you open the report to capture the sql behind it and reverse engineer what you need 🙂

OPTION RECOMPILE is your friend in this case, if you can use it. or read up on parameterization.

Alternatively, I believe if you declare a new set of variables and...

Try creating a SystemDSN entry on the machine you are trying to connect from AdminTools > ODBC DataSource Administrator > System DSN

This can be a good initial test of connectivity

No worries.

Thanks for the responses but I'm not sure that I am being clear. Restoring clears the cache for the instance, so if you are hosting more than one client on...