Andrew Stevenson's WebLog

Write Here Write Now


.Net Languages


Asp.Net (Misc.)

Asp.Net Controls

Bad Patterns

Err What?

Files and Folders


IE Add-Ins

Methods for the Madness


See Clearer, C#

Test Driven

August 2006 - Posts

Who decides "off topic"?

I'm wondering who decides that a post is off topic.

I wrote my first blog entry in a long time today was confused when it didn't show up on the main site.

After trying to figure out if I had not published it properly or set some specifc property, I eventualy noticed the two links for On Topic Only and All Posts.

I don't need the entry to show up on the main page, but it doesn't seem to be further off target than some of the other things that are in the main feed.

Edit : I think I figured it out, use the "Asp.Net" tag :P


Posted Thursday, August 10, 2006 4:57 PM by AndrewSeven | 1 comment(s)

Filed under: ,

Deleting the diagramming objects from Sql Server

Maybe there is a more direct way to do it, but the scripts below will delete the objects that are created for database diagrams.

I delete then because when I have no diagrams in the db and when I run Scriptio, it includes them in the script. They are marked as system objects, so the "delete" option does not appear in the Sql 2005 Management UI.

Note that this does delete any diagrams you might have in your db.

DROP PROCEDURE dbo.sp_alterdiagram
DROP PROCEDURE dbo.sp_creatediagram
DROP PROCEDURE dbo.sp_dropdiagram
DROP PROCEDURE dbo.sp_helpdiagramdefinition
DROP PROCEDURE dbo.sp_renamediagram
DROP PROCEDURE dbo.sp_upgraddiagrams
DROP PROCEDURE dbo.sp_helpdiagrams
DROP FUNCTION dbo.fn_diagramobjects
DROP TABLE dbo.sysdiagrams

Posted Thursday, August 10, 2006 9:49 AM by AndrewSeven | 1 comment(s)

Filed under: ,

More Posts