Home > Archive > MS SQL Server > March 2006 > Error Message. Please help









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Error Message. Please help
Shayaan Siddiqui

2006-03-29, 11:23 am

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
amish

2006-03-29, 11:23 am

Try refreshing enterprise manger.


Regards
Amish Shah

Shayaan Siddiqui

2006-03-29, 1:23 pm

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.googlegroups.com...
> Try refreshing enterprise manger.
>
>
> Regards
> Amish Shah
>



jrpm

2006-03-29, 1:23 pm

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.googlegroups.com...
>
>
>

Shayaan Siddiqui

2006-03-29, 8:23 pm

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@microso
ft.com...[color=darkred]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
>
> "Shayaan Siddiqui" wrote:
>


Shayaan Siddiqui

2006-03-30, 9:23 am

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
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com