I’ve bean using these for quite some time, and have used them again today so it came cross my mind to mention them on my blog.

Here goes nothing…

– Disable all constraints for a given table
ALTER TABLE [Some_Table] NOCHECK CONSTRAINT ALL

– Enable all constraints for a given table
ALTER TABLE [Some_Table] CHECK CONSTRAINT ALL

– Reseed the identity of a table back to zero (next record will have auto ident set to 1)
DBCC CHECKIDENT ([Some_Table], RESEED, 0)

– “Run” table constraints on a table to verify that everything is ok
DBCC CHECKCONSTRAINTS (’[Some_Table]‘)



hope this helps someone, it sure did me over the past years.

I’ve received a couple of mails from people asking what’s next for BlankModule, and when they can expect it.

The situation and the plans currently are to finish Web Deployment Project for the solution (actually the project is already done, it can build all the projects in solution, it can deploy their outputs to central dnn bin, it can zip your module and create both source and release versions of it, etc… What I am missing is some small details like will I make it as a separate targets file which you can include in your WDP or just make a done WDP, also decide about the output paths for zipped files and such… mostly it’s fine tuning, but it needs to be done).

After I finish that I will publish it as an addition to the tutorial (I expect to have it done next week) and proceed to the Visual Studio templates. I’ve found 2 great possible directions for the templates - one is to develop a wizard for the templates and make something that I call “smart” templates that you can configure to your liking at run-time, the other would be to employ GAT - which sounds like a great idea, but I still need to find out lots about it - so obviously my learning curve here is allot bigger. Depending on the direction I decide to follow I will know a little better when that part will be made public.


I’ve decided 2 very firm things for this project:

1. I will release something when it’s done, and before releasing it try to tweak it as much as possible to my liking (I am a very “details” kind of guy - I like everything to be as good as possible)
2. I will not promise you much - what I have promised I will do (although my passion for this has already driven me to talk to few people about possible future ideas)

so again, stay tuned… you will be the first to know when something is released.

Then read this post, it does a great job summarizing various debugging issues you might encounter:

http://blogs.msdn.com/mkpark/articles/86872.aspx


Courtesy of Rodney Joyce of http://www.smart-thinker.com

I’ve created myself a Technorati profile, here is the link to it profile:

Technorati Profile

P.S. Skip this post, it’s only to proove the service that this is my site. Sorry for the spam.

If you didn’t know, SQLPrompt is a great tool from Red-Gate which enables you to have intellisense for your SQL code in all kinds of development enviroments.

What you maybe didn’t know is that this tool also has Code Snippets, so besides beeing a great SQL intellisense tool, you can now define your own commonly used SQL snippets through this gem!

You can find the tool here: http://www.red-gate.com