Sunday, February 26, 2012

Error Message. Please help

I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Try refreshing enterprise manger.
Regards
Amish Shah
|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>
|||I have found disconnecting from the server and/or shutting down EM helps.
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:

> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
>
>
|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You

No comments:

Post a Comment