Removing foreign keys

Hi everyone,

I've been using VS.NET to design and implement my SQL databases. This has been simple and effective.

I've deployed the database onto the production database server and it's been performing without a hitch for some time now.

My problem is that I now need to remove a foreign key relationship on the production database as I have had a relationship between two tables but now not wanting the relationship since the data that had the relationship is now not wanting to be compulsory. I've had a look in the system.foreignkey (I think) table but I can't make head or tail of it.

Long story short, how can I find and remove the relationship from Query Analyser / Enterprise Manager ? I know how to do this in VS.NET diagram (just delete the relationship) but when you open the production database in VS.NET the diagram is no longer there.

Any help will be appreciated!!

Thanks!
AndrewFixed - was browsing around in VS.NET on the server, right clicked on the table in question, and found the relationship tab, deleted relationship.

Thanks!
Andrew

Removing deployed reports

Hi All,

I deployed many reports on sql server reporting services. I want to remove some of the unnecessary reports. How to remove it?

thanking You,

Thanks,

Muniappan Kandasamy

SQL 2005? If so, in SQL Server Management Studio you can attach to your reporting server instance and then select the report and set its hidden property to true, or delete it outright:

On the login popup, check out your list of Server Types provided, you should see a 'Reporting Services' item. If you are already in the Mgmt studio, on the object explorer, click the Connect button and in the dropdown you'll see a reporting services item. Once you are in, you should be able to find your report objects and do whatever you need to them.

Cheers!

Wayne

|||

Thank you

Removing deployed reports

Hi All,

I deployed many reports in sql server 2005 reporting services. I want to remove some of the unnecessary reports. How to remove those reports?

thank you

thanks,

Muniappan Kandasamy

1. Open report manager (http://localhost/reports).

2. Navigate to your report server project.

3. Click the Show Details button.

4. Check the reports you want to delete then click delete.