Sunday, February 26, 2012

Error Message. Please help

This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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 already = exists"

Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0--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.googlegroups.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.googlegroups.com...
> > Try refreshing enterprise manger.
> >
> >
> > Regards
> > Amish Shah
> >
>
>|||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...
>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...
>> > Try refreshing enterprise manger.
>> >
>> >
>> > Regards
>> > Amish Shah
>> >
>>|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Any suggestions?
Thanks
"Shayaan Siddiqui" 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 =already exists"

Thank =You

--=_NextPart_000_0008_01C653E0.B89F5FB0--

No comments:

Post a Comment