Friday, February 17, 2012

ERROR sql2005 sobre win2000 ad server

hi
when i try to save a maintenance plan
i get an error like
"GUID must have 32 characters y 4 hyphens"
"xxxxxx-xxxxx-...-xxxxx"
this occurs in production
( sql2005 over win 2000 advanced server )
but, on dev environment
( over win 2003 server )
works fine
any idea ?
thanks
--
atte,
Hernánbajopalabra wrote:
> hi
> when i try to save a maintenance plan
> i get an error like
> "GUID must have 32 characters y 4 hyphens"
> "xxxxxx-xxxxx-...-xxxxx"
> this occurs in production
> ( sql2005 over win 2000 advanced server )
> but, on dev environment
> ( over win 2003 server )
> works fine
> any idea ?
> thanks
>
That sounds like a custom message coming from a trigger. Are there
triggers on that table in production that aren't in development?|||no triggers
this is the real error
"GUID should contain 32 digits with 4 dashes"
when trying to save the more easy simple plan
it seems to be a bug
both sql servers reports
different MDAC versions and files ...
could it be the point ' the MDAC '
atte,
Hernán
"Tracy McKibben" <tracy@.realsqlguy.com> escribió en el mensaje
news:ucm2uMVlGHA.5044@.TK2MSFTNGP02.phx.gbl...
| bajopalabra wrote:
| > hi
| > when i try to save a maintenance plan
| > i get an error like
| >
| > "GUID must have 32 characters y 4 hyphens"
| > "xxxxxx-xxxxx-...-xxxxx"
| >
| > this occurs in production
| > ( sql2005 over win 2000 advanced server )
| >
| > but, on dev environment
| > ( over win 2003 server )
| > works fine
| >
| > any idea ?
| > thanks
| >
|
| That sounds like a custom message coming from a trigger. Are there
| triggers on that table in production that aren't in development?|||bajopalabra wrote:
> no triggers
> this is the real error
> "GUID should contain 32 digits with 4 dashes"
> when trying to save the more easy simple plan
> it seems to be a bug
> both sql servers reports
> different MDAC versions and files ...
> could it be the point ' the MDAC '
>
Apparently this is a known bug that is fixed in Service Pack 1
http://support.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.tools&tid=ea561347-3d88-41c2-b475-88bfd478c3ce&p=1|||i think it's fixed on win2003
but not on win2000
i tested in both servers
i found a workareound
as i read on another newsgroup
if i create the plan via wizard
there are no problem
later, i can change the plan as i wish
very rare thing...
atte,
Hernán
"Tracy McKibben" <tracy@.realsqlguy.com> escribió en el mensaje
news:uJc89oVlGHA.3776@.TK2MSFTNGP03.phx.gbl...
| bajopalabra wrote:
| > no triggers
| > this is the real error
| >
| > "GUID should contain 32 digits with 4 dashes"
| >
| > when trying to save the more easy simple plan
| >
| > it seems to be a bug
| >
| > both sql servers reports
| > different MDAC versions and files ...
| > could it be the point ' the MDAC '
| >
| >
|
| Apparently this is a known bug that is fixed in Service Pack 1
|
http://support.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.tools&tid=ea561347-3d88-41c2-b475-88bfd478c3ce&p=1
|

No comments:

Post a Comment