"Invalid Bracketing of name"

I imported this data base from access 97 to access 2000 and it works but when I try to add any thing it gives me the "Invalid Bracketing of name" error the orignal sql has 7 UNION SELECT statements simalar to the two shown hereand works fine
but we will need to add more tables shortly
can any guru help please

SELECT U.[Machine Name], U.[Part Number], U.Description, U.Programs
FROM [SELECT
"Mori" as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM Mori
UNION SELECT
'LE' as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM LE
]. AS U;This is bad SQL syntax. Try using:SELECT U.[Machine Name], U.[Part Number], U.Description, U.Programs
FROM (SELECT
"Mori" as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM Mori
UNION SELECT
'LE' as [Machine Name],
[Part Number],
[Description],
[Programs]
FROM LE) AS U; If it complains about the semi-colon at the end, remove that too.

-PatP|||Originally posted via PM by vern1959
THANK YOU FOR THE HELP
WERID THING THOUGH I CHANGED THE [] TO () AND DELITED THE
. JUST BEFORE "AS U" IT RUNS GREAT WHATS WERID IS WHEN I SAVE
AND EXIT THE SQL EDITOR AND RE OPEN THE SQL TO EDIT IT
THE [] and " . "are back and any attempt to edit causes the original error
"BUT" when I replace the () and delite the " . " it work but saves as described above again is this normal ? Vern posted this as a PM, but I'm responding here in case others are reading this thread or have comments to offer.

I've never seen that behavior in Access-2000 before. This smells of DAO, which was the default for Access-97, but I can't remember having seen it there either.

-PatP

error al crear plan de mantenimiento

Hola,
Estoy creando un plan de mantenimiento para una base de datos SQL Server
2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye lo
basico, reconstruir indices, chequear integridad, actualizar estadisticas,
etc.
Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar
terminar se produce el siguiente error. Busque en la pagina de Microsoft en
el link indicado y no dice que no me puede brindar ninguna ayuda. ¿alquien
sabe que podria estar pasando?
De antemano gracias por su ayuda.
Edmundo J. Davila
ERROR
---
TITLE: Maintenance Plan Wizard Progress
--
Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
--
BUTTONS:
OK
--Check out "microsoft.public.es.sqlserver" for Spanish.
Apply SP2 to your SQL Server 2005 if you have not.
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
> Hola,
> Estoy creando un plan de mantenimiento para una base de datos SQL Server
> 2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye
> lo basico, reconstruir indices, chequear integridad, actualizar
> estadisticas, etc.
> Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar
> terminar se produce el siguiente error. Busque en la pagina de Microsoft
> en el link indicado y no dice que no me puede brindar ninguna ayuda.
> ¿alquien sabe que podria estar pasando?
> De antemano gracias por su ayuda.
> Edmundo J. Davila
> ERROR
> ---
>
> TITLE: Maintenance Plan Wizard Progress
> --
> Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> --
> BUTTONS:
> OK
> --
>|||As far as I know I have SP2 already installed. Am I right?
SELECT @.@.VERSION
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 2)
"Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
> Check out "microsoft.public.es.sqlserver" for Spanish.
> Apply SP2 to your SQL Server 2005 if you have not.
> --
> Ekrem Önsoy
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL Server
>> 2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye
>> lo basico, reconstruir indices, chequear integridad, actualizar
>> estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar
>> terminar se produce el siguiente error. Busque en la pagina de Microsoft
>> en el link indicado y no dice que no me puede brindar ninguna ayuda.
>> ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>|||Hola Edmundo
The Service Pack 2 in that message is for Windows. To figure out from that
string if it is SQL Server 2005 you have to look up the build number in a
list, or know the date that SP2 came out. In fact, SP2 came out in March
2007, and your Oct 14, 2005 date indicates you are running the RTM release
with no service packs.
In SQL 2005, an easier way to tell which service pack you are using is the
following:
SELECT SERVERPROPERTY('ProductLevel')
Also, take a look at the KB article:
http://support.microsoft.com/kb/321185
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:DF091B8A-52EE-4C1D-A9A2-246C0DA9FD66@.microsoft.com...
> As far as I know I have SP2 already installed. Am I right?
> SELECT @.@.VERSION
> Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> "Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
> news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
>> Check out "microsoft.public.es.sqlserver" for Spanish.
>> Apply SP2 to your SQL Server 2005 if you have not.
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL Server
>> 2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye
>> lo basico, reconstruir indices, chequear integridad, actualizar
>> estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar
>> terminar se produce el siguiente error. Busque en la pagina de Microsoft
>> en el link indicado y no dice que no me puede brindar ninguna ayuda.
>> ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>>
>|||I appreciate your help. I'm downloading SP2 for SQL SERVER 2005.
Do you agree that not having SP2 installed is causing the error when I try
to create the maintenance plan?
Edmundo
"Kalen Delaney" <replies@.public_newsgroups.com> escribió en el mensaje de
noticias news:OvN%23t5EMIHA.4688@.TK2MSFTNGP06.phx.gbl...
> Hola Edmundo
> The Service Pack 2 in that message is for Windows. To figure out from that
> string if it is SQL Server 2005 you have to look up the build number in a
> list, or know the date that SP2 came out. In fact, SP2 came out in March
> 2007, and your Oct 14, 2005 date indicates you are running the RTM release
> with no service packs.
> In SQL 2005, an easier way to tell which service pack you are using is the
> following:
> SELECT SERVERPROPERTY('ProductLevel')
> Also, take a look at the KB article:
> http://support.microsoft.com/kb/321185
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:DF091B8A-52EE-4C1D-A9A2-246C0DA9FD66@.microsoft.com...
>> As far as I know I have SP2 already installed. Am I right?
>> SELECT @.@.VERSION
>> Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
>> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
>> (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>> "Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
>> news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
>> Check out "microsoft.public.es.sqlserver" for Spanish.
>> Apply SP2 to your SQL Server 2005 if you have not.
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL
>> Server 2005. Tengo una instalacion en 64 bits. El plan de mantenimiento
>> incluye lo basico, reconstruir indices, chequear integridad, actualizar
>> estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar
>> terminar se produce el siguiente error. Busque en la pagina de
>> Microsoft en el link indicado y no dice que no me puede brindar ninguna
>> ayuda. ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or
>> batch. (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>>
>|||I'm not sure. I don't use maintenance plans, but I do know there were some
bugs in them that were fixed in SP2. It's almost always good to have the
latest SP when trying to troubleshoot problems like this.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:9DF8857C-2878-47E8-9BDC-72DC8FAD00A9@.microsoft.com...
>I appreciate your help. I'm downloading SP2 for SQL SERVER 2005.
> Do you agree that not having SP2 installed is causing the error when I try
> to create the maintenance plan?
> Edmundo
> "Kalen Delaney" <replies@.public_newsgroups.com> escribió en el mensaje de
> noticias news:OvN%23t5EMIHA.4688@.TK2MSFTNGP06.phx.gbl...
>> Hola Edmundo
>> The Service Pack 2 in that message is for Windows. To figure out from
>> that string if it is SQL Server 2005 you have to look up the build number
>> in a list, or know the date that SP2 came out. In fact, SP2 came out in
>> March 2007, and your Oct 14, 2005 date indicates you are running the RTM
>> release with no service packs.
>> In SQL 2005, an easier way to tell which service pack you are using is
>> the following:
>> SELECT SERVERPROPERTY('ProductLevel')
>> Also, take a look at the KB article:
>> http://support.microsoft.com/kb/321185
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:DF091B8A-52EE-4C1D-A9A2-246C0DA9FD66@.microsoft.com...
>> As far as I know I have SP2 already installed. Am I right?
>> SELECT @.@.VERSION
>> Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
>> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
>> (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>> "Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
>> news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
>> Check out "microsoft.public.es.sqlserver" for Spanish.
>> Apply SP2 to your SQL Server 2005 if you have not.
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL
>> Server 2005. Tengo una instalacion en 64 bits. El plan de
>> mantenimiento incluye lo basico, reconstruir indices, chequear
>> integridad, actualizar estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y
>> dar terminar se produce el siguiente error. Busque en la pagina de
>> Microsoft en el link indicado y no dice que no me puede brindar
>> ninguna ayuda. ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or
>> batch. (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>>
>>
>|||You can not create Maintanence Plans if you do not have SSIS installed or if
you don't have SP1 of SQL Server 2005 is installed.
If you apply SP2, you'll be able to create maintanence plans without having
SSIS installed.
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:9DF8857C-2878-47E8-9BDC-72DC8FAD00A9@.microsoft.com...
>I appreciate your help. I'm downloading SP2 for SQL SERVER 2005.
> Do you agree that not having SP2 installed is causing the error when I try
> to create the maintenance plan?
> Edmundo
> "Kalen Delaney" <replies@.public_newsgroups.com> escribió en el mensaje de
> noticias news:OvN%23t5EMIHA.4688@.TK2MSFTNGP06.phx.gbl...
>> Hola Edmundo
>> The Service Pack 2 in that message is for Windows. To figure out from
>> that string if it is SQL Server 2005 you have to look up the build number
>> in a list, or know the date that SP2 came out. In fact, SP2 came out in
>> March 2007, and your Oct 14, 2005 date indicates you are running the RTM
>> release with no service packs.
>> In SQL 2005, an easier way to tell which service pack you are using is
>> the following:
>> SELECT SERVERPROPERTY('ProductLevel')
>> Also, take a look at the KB article:
>> http://support.microsoft.com/kb/321185
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:DF091B8A-52EE-4C1D-A9A2-246C0DA9FD66@.microsoft.com...
>> As far as I know I have SP2 already installed. Am I right?
>> SELECT @.@.VERSION
>> Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
>> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
>> (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>> "Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
>> news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
>> Check out "microsoft.public.es.sqlserver" for Spanish.
>> Apply SP2 to your SQL Server 2005 if you have not.
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL
>> Server 2005. Tengo una instalacion en 64 bits. El plan de
>> mantenimiento incluye lo basico, reconstruir indices, chequear
>> integridad, actualizar estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y
>> dar terminar se produce el siguiente error. Busque en la pagina de
>> Microsoft en el link indicado y no dice que no me puede brindar
>> ninguna ayuda. ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or
>> batch. (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>>
>>
>|||Kalen,
After installing SP2 for SQL Server 2005, the maintenance plan was sucefully
created.
Just for curiosity, why don't you use maintenance plans?
Edmundo J. Davila
"Kalen Delaney" <replies@.public_newsgroups.com> escribió en el mensaje de
noticias news:udpb3fFMIHA.3940@.TK2MSFTNGP05.phx.gbl...
> I'm not sure. I don't use maintenance plans, but I do know there were some
> bugs in them that were fixed in SP2. It's almost always good to have the
> latest SP when trying to troubleshoot problems like this.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:9DF8857C-2878-47E8-9BDC-72DC8FAD00A9@.microsoft.com...
>>I appreciate your help. I'm downloading SP2 for SQL SERVER 2005.
>> Do you agree that not having SP2 installed is causing the error when I
>> try to create the maintenance plan?
>> Edmundo
>> "Kalen Delaney" <replies@.public_newsgroups.com> escribió en el mensaje de
>> noticias news:OvN%23t5EMIHA.4688@.TK2MSFTNGP06.phx.gbl...
>> Hola Edmundo
>> The Service Pack 2 in that message is for Windows. To figure out from
>> that string if it is SQL Server 2005 you have to look up the build
>> number in a list, or know the date that SP2 came out. In fact, SP2 came
>> out in March 2007, and your Oct 14, 2005 date indicates you are running
>> the RTM release with no service packs.
>> In SQL 2005, an easier way to tell which service pack you are using is
>> the following:
>> SELECT SERVERPROPERTY('ProductLevel')
>> Also, take a look at the KB article:
>> http://support.microsoft.com/kb/321185
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:DF091B8A-52EE-4C1D-A9A2-246C0DA9FD66@.microsoft.com...
>> As far as I know I have SP2 already installed. Am I right?
>> SELECT @.@.VERSION
>> Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
>> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
>> (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>> "Ekrem Önsoy" <ekrem@.btegitim.com> escribió en el mensaje de noticias
>> news:BCB3A255-D9C3-4EEF-BB8A-D32D4D94404A@.microsoft.com...
>> Check out "microsoft.public.es.sqlserver" for Spanish.
>> Apply SP2 to your SQL Server 2005 if you have not.
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:2A52A12B-5A8F-4094-99BB-396731CD58F8@.microsoft.com...
>> Hola,
>> Estoy creando un plan de mantenimiento para una base de datos SQL
>> Server 2005. Tengo una instalacion en 64 bits. El plan de
>> mantenimiento incluye lo basico, reconstruir indices, chequear
>> integridad, actualizar estadisticas, etc.
>> Lo estoy tratando de hacer con el wizard, pero al llegar al final y
>> dar terminar se produce el siguiente error. Busque en la pagina de
>> Microsoft en el link indicado y no dice que no me puede brindar
>> ninguna ayuda. ¿alquien sabe que podria estar pasando?
>> De antemano gracias por su ayuda.
>> Edmundo J. Davila
>> ERROR
>> ---
>>
>> TITLE: Maintenance Plan Wizard Progress
>> --
>> Create maintenance plan failed.
>> --
>> ADDITIONAL INFORMATION:
>> Create failed for JobStep 'Subplan'.
>> (Microsoft.SqlServer.MaintenancePlanTasks)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> --
>> An exception occurred while executing a Transact-SQL statement or
>> batch. (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The specified '@.subsystem' is invalid (valid values are returned by
>> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>>
>>
>>
>