How to detect that a sqlserver table row has foreign keys and cannot be deleted?

What is the best way to detect that a sqlserver table row has foreign keys and cannot be deleted?

Thanks,

Keith

sp_table_constraints_rowset 'yourTableName'

How to detach deleted databases?

I asked this question in the Tools General forum but received no response. Does anybody is this forum know how to resolve this problem? Here it is again with a bit more info:

When I ran sseutil -l, I discovered several databases that were still attached. However, they were old test projects that had previously been deleted. How do I detach them if they no longer exist? Using the detach command will not work because it just gives me a message: No valid database name matches the value specified.

Apparently, this question is too difficult. Doesn't anybody have a clue on how to do this?|||Did you try using
sseutil.exe -d<nameofthedatabase>
?
HTH, Jens Suessmeyer.|||Yes, of course. That's the problem. The test databases no longer exist so sseutil can't find them. So it won't detach them.

How to delete orphaned maintenance plan jobs in SQL Server 2005

Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
first. Now I can not delete the job. Is there any way I can delete the job?
Thanks in advance for any help!
I was getting "the maintenance plan related to this job doesn't exist" error.
I set up another maintenance plan and ran it. Now the orphaned job got
cleaned up. So I am all set. Thanks so much for your help!
"Tibor Karaszi" wrote:

> What error message do you get?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:36E58102-BCFE-4E3B-8412-8861F915F616@.microsoft.com...
>
>

How to delete orphaned maintenance plan jobs in SQL Server 2005

Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
first. Now I can not delete the job. Is there any way I can delete the job?
Thanks in advance for any help!What error message do you get?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:36E58102-BCFE-4E3B-8412-8861F915F616@.microsoft.com...
> Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
> first. Now I can not delete the job. Is there any way I can delete the job?
> Thanks in advance for any help!
>|||I was getting "the maintenance plan related to this job doesn't exist" error.
I set up another maintenance plan and ran it. Now the orphaned job got
cleaned up. So I am all set. Thanks so much for your help!
"Tibor Karaszi" wrote:
> What error message do you get?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
> news:36E58102-BCFE-4E3B-8412-8861F915F616@.microsoft.com...
> > Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
> > first. Now I can not delete the job. Is there any way I can delete the job?
> > Thanks in advance for any help!
> >
>
>

How to delete orphaned maintenance plan jobs in SQL Server 2005

Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
first. Now I can not delete the job. Is there any way I can delete the job?
Thanks in advance for any help!What error message do you get?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:36E58102-BCFE-4E3B-8412-8861F915F616@.microsoft.com...
> Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job
> first. Now I can not delete the job. Is there any way I can delete the job
?
> Thanks in advance for any help!
>

How to delete an orphaned push subscription

On server1 I created a push subscription to server2. I deleted the
subscription from server1, but server2 still shows it.
I have referred to SQL Server 2000 Books OnLine topics "How to Delete
a Push
Subscription" and "How to Delete a Pull Subscription", but they are of
no help because they only show how to remove it from server1.
Does anyone know how to go about fixing this?
Thanks!
If the database on server2 is not a subscriber to any other publications and
doesn't itself have any publications, then try running
sp_removedbreplication.
HTH,
Paul Ibison