March 12, 2013 at 7:11 am
Hi All
When I open an Integrity check task from a server (SQL 2008 R2) with my SSMS(SQL2012) on my PC the task shows loacal DBs in the database drop down. Any ideas.:w00t:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
March 13, 2013 at 10:15 pm
Can you post a screenshot?
Just a shot in the dark, but if the server name referenced by the task is . (dot, meaning local server) or localhost then when opening it on your machine it will resolve it as being an instance on your machine. If you have SSMS on the server, try it from there.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 15, 2013 at 5:08 am
saw that but isn't it suppose to run under the server context where you open it?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
March 15, 2013 at 9:44 am
It depends on whether someone ever changed the default connection in the MP.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply