I hear what you are saying about the objects, but for every database created there are 52 system objects added does this not create more overhead? 

I am not going to try to consolidate existing databases but I don't want to end with with 200 databases in a year or two.

I would use a case statement in your SP.

SELECT ID, TITLE FROM MyTable

WHERE

Closed_Date

CASE @Open

    WHEN 0 THEN

          Is Null

     ELSE

         IS NOT NULL

In addition you must use the alter statement.  You cannot just simply add the code into an existing SP.  So everytime you need to update that SP you have to...

You should only need two tables a job_description table (i.e. Engineer, programmer, tester, etc) and an employees table that stores the foreign key from the job_description table.

Edward M. Sokolove

We use this method to get a datadictionary and it's free. First you enter the text into each description field then run this stored procedure for every table.

CREATE PROCEDURE...

We developed a method that searches each web page and it looks for a certain keyword in the page. Then it finds all the stored procedures for the web...

All you would have to do is modify this stored procedure a bit to add columns (pass in a variable, etc. without using a cursor. I was just giving...

Here's how to delete all duplicates and leaving one in the table without reinserting the record.

*********************************************

Table Used in this example

*****************************************

CREATE TABLE [dbo].[Table2] (

[TID] [int] IDENTITY (1, 1) NOT NULL ,

[FName]...

I run a subscription based web site. Basically I build the front-end and back-end components, and the user rents or subscribes to the application and the fee would be...

You can run this in a job if you want. It will go through a table and delete all duplicate names. If you need to delete something else...

Here's how you do it in SQL Server. First populate your description field in the table design. Then use this stored procedure to retrieve a recordset of the...

Here's a way to do it without a cursor or temptable and no joins, you still have the issue of the varchar(8000). Just another thought.

DECLARE @I INT

DECLARE @MaxCount INT

SET...

Here's a solution I believe I found on this forum. This one checks for other common errors that people make when entering an email address.

--update tblevent set unclassifiedemail =...

That is a problem if you add servers frequently this is not the way to go, but if you have set servers (Devel, Test, Production) then this would work. ...