Geeks With Blogs
Clara's Notes on Technology Notes to me and the world August 2007 Entries
Drop All Objects
Here is a little script I find useful. It drops all tables, views and stored procedures in a database. exec sp_MSforeachtable 'DROP TABLE ? PRINT ''? dropped'' 'GO /* Drop all non-system stored procs */declare @name varchar(128)declare @SQL varchar(254) SELECT @name = (select top 1 name FROM sysobjects WHERE type = 'P' And category = 0 order by name)while @name is not nullbegin select @SQL = 'drop procedure [dbo].[' + rtrim(@name) +']'exec (@SQL) print 'Dropped :' + @name SELECT @name = (select top ......

Posted On Sunday, August 26, 2007 7:14 PM

The maximum nametable character count quota (16384) has been exceeded
It has been a while since I last posted, but I haven't stopped working :) I am currently on a project involving WPF and WCF. While I am not a big fan of WPF, but I quite like WCF. During the development of our project we run into a very annoying problem with WCF. After some help from Microsoft, we found a solution at last. The problem is very easy to describe. On the one side, we have a WCF service running. On the other side, we have a client with a reference with to this service. Now and then, we ......

Posted On Monday, August 20, 2007 6:36 PM

Copyright © Clara Oscura | Powered by: