Deleting inaccessible Sql server jobs

hi all,
we have renamed a server which had sql server on it, all the databases are
still on it and their is no problem accessing them at all, and now after this
the sql server jobs which were on this machine and were running before the
name was changed are crashing everytime they run, when i tried deleted them
since i dont need them any more it pops up and error, i am not even able to
disabled or modify them as well. Can any one out their tell how i could
delete these jobs from the sql server tables in the database. The error
message that i get evertime i try modifying\ deleting anything on the job is
error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSX server.
the job was not saved.
thanksThis problem could be attributable to the originating_server now differing
from the actual server name.
UPDATE msdb..sysjobs SET Originating_Server = Servername
The Microsoft KBase resolution is here :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281642
--
HTH. Ryan
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:03A8C8C8-2A05-4660-BD88-15EB2B74F164@.microsoft.com...
> hi all,
> we have renamed a server which had sql server on it, all the databases are
> still on it and their is no problem accessing them at all, and now after
> this
> the sql server jobs which were on this machine and were running before the
> name was changed are crashing everytime they run, when i tried deleted
> them
> since i dont need them any more it pops up and error, i am not even able
> to
> disabled or modify them as well. Can any one out their tell how i could
> delete these jobs from the sql server tables in the database. The error
> message that i get evertime i try modifying\ deleting anything on the job
> is
> error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSX server.
> the job was not saved.
> thanks

Deleting inaccessible Sql server jobs

hi all,
we have renamed a server which had sql server on it, all the databases are
still on it and their is no problem accessing them at all, and now after thi
s
the sql server jobs which were on this machine and were running before the
name was changed are crashing everytime they run, when i tried deleted them
since i dont need them any more it pops up and error, i am not even able to
disabled or modify them as well. Can any one out their tell how i could
delete these jobs from the sql server tables in the database. The error
message that i get evertime i try modifying\ deleting anything on the job is
error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSX server.
the job was not saved.
thanksThis problem could be attributable to the originating_server now differing
from the actual server name.
UPDATE msdb..sysjobs SET Originating_Server = Servername
The Microsoft KBase resolution is here :-
http://support.microsoft.com/defaul...b;en-us;Q281642
--
HTH. Ryan
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:03A8C8C8-2A05-4660-BD88-15EB2B74F164@.microsoft.com...
> hi all,
> we have renamed a server which had sql server on it, all the databases are
> still on it and their is no problem accessing them at all, and now after
> this
> the sql server jobs which were on this machine and were running before the
> name was changed are crashing everytime they run, when i tried deleted
> them
> since i dont need them any more it pops up and error, i am not even able
> to
> disabled or modify them as well. Can any one out their tell how i could
> delete these jobs from the sql server tables in the database. The error
> message that i get evertime i try modifying\ deleting anything on the job
> is
> error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSX server.
> the job was not saved.
> thanks

Deleting inaccessible Sql server jobs

hi all,
we have renamed a server which had sql server on it, all the databases are
still on it and their is no problem accessing them at all, and now after this
the sql server jobs which were on this machine and were running before the
name was changed are crashing everytime they run, when i tried deleted them
since i dont need them any more it pops up and error, i am not even able to
disabled or modify them as well. Can any one out their tell how i could
delete these jobs from the sql server tables in the database. The error
message that i get evertime i try modifying\ deleting anything on the job is
error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSX server.
the job was not saved.
thanks
This problem could be attributable to the originating_server now differing
from the actual server name.
UPDATE msdb..sysjobs SET Originating_Server = Servername
The Microsoft KBase resolution is here :-
http://support.microsoft.com/default...;en-us;Q281642
HTH. Ryan
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:03A8C8C8-2A05-4660-BD88-15EB2B74F164@.microsoft.com...
> hi all,
> we have renamed a server which had sql server on it, all the databases are
> still on it and their is no problem accessing them at all, and now after
> this
> the sql server jobs which were on this machine and were running before the
> name was changed are crashing everytime they run, when i tried deleted
> them
> since i dont need them any more it pops up and error, i am not even able
> to
> disabled or modify them as well. Can any one out their tell how i could
> delete these jobs from the sql server tables in the database. The error
> message that i get evertime i try modifying\ deleting anything on the job
> is
> error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSX server.
> the job was not saved.
> thanks

Delete relationship?

How do I delete a relationship between tables in SQL Server 7.0?
I previously had a relationship between two tables, but I renamed the field
and table of one of the tables and the old relationship still points to the
old field name and table. How do I remove the defunct relationship?
It doesn't show in my diagram because the old table no longer exists (well
it does but it's been renamed).Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name>
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the
> field and table of one of the tables and the old relationship still points
> to the old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>|||ALTER TABLE tblname DROP CONSTRAINT constraintname
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the fiel
d
> and table of one of the tables and the old relationship still points to th
e
> old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>

Delete relationship?

How do I delete a relationship between tables in SQL Server 7.0?
I previously had a relationship between two tables, but I renamed the field
and table of one of the tables and the old relationship still points to the
old field name and table. How do I remove the defunct relationship?
It doesn't show in my diagram because the old table no longer exists (well
it does but it's been renamed).Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name>
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the
> field and table of one of the tables and the old relationship still points
> to the old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>|||ALTER TABLE tblname DROP CONSTRAINT constraintname
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the fiel
d
> and table of one of the tables and the old relationship still points to th
e
> old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>

Delete relationship?

How do I delete a relationship between tables in SQL Server 7.0?
I previously had a relationship between two tables, but I renamed the field
and table of one of the tables and the old relationship still points to the
old field name and table. How do I remove the defunct relationship?
It doesn't show in my diagram because the old table no longer exists (well
it does but it's been renamed).
Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name>
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the
> field and table of one of the tables and the old relationship still points
> to the old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>
|||ALTER TABLE tblname DROP CONSTRAINT constraintname
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the field
> and table of one of the tables and the old relationship still points to the
> old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>

Delete relationship?

How do I delete a relationship between tables in SQL Server 7.0?
I previously had a relationship between two tables, but I renamed the field
and table of one of the tables and the old relationship still points to the
old field name and table. How do I remove the defunct relationship?
It doesn't show in my diagram because the old table no longer exists (well
it does but it's been renamed).Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name>
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the
> field and table of one of the tables and the old relationship still points
> to the old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>|||ALTER TABLE tblname DROP CONSTRAINT constraintname
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the field
> and table of one of the tables and the old relationship still points to the
> old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>

Delete relationship?

How do I delete a relationship between tables in SQL Server 7.0?

I previously had a relationship between two tables, but I renamed the field
and table of one of the tables and the old relationship still points to the
old field name and table. How do I remove the defunct relationship?

It doesn't show in my diagram because the old table no longer exists (well
it does but it's been renamed).ALTER TABLE tblname DROP CONSTRAINT constraintname

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the field
> and table of one of the tables and the old relationship still points to the
> old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>|||Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name
"Steve" <steve@.hello.com> wrote in message news:43301ef3_1@.x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
> I previously had a relationship between two tables, but I renamed the
> field and table of one of the tables and the old relationship still points
> to the old field name and table. How do I remove the defunct relationship?
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).