Before I make a suggest let me please clarify something.

You state they want the count in the header row. Exactly what do you mean?

Do...

Although I think Michael has a very good method the problem is that it generates a lot of extra information that would be better compartmentalized into multiple functions rather than one....

Just to throw in here, I would 1 probably do the extra work in the presentation side and not in the SQL Server but here is another option to do...

Read the remarks of sp_repladdcolumn and see if it applies. I think your issue lies in the remote table, did you adjust the column there as well. If nothing else...

Yes MS lincenses based on physical processor and not logical so you count the number of processors you installed and not the count the OS reports. Even if you had...

Sorry although it is a good article you the description is too grey and too broad to be effective. A DBAA should be more of the same person as a...

Well you cannot prove a negative, all you can do is check the EventLogs and any other log information you have available around the event. If you have nothing then...

I saw one tool several years ago but it was pricey. How many objects are you talking?

Lot's of options just depends on the featurs you will need and the cost you are willing to put out. Visio works fine for my needs.

Many places could have been wrong including a nearby router could have been the root issue. Problem is no way to really say how to prevent the unknown.

From SQL BOL "CREATE PROCEDURE"

A stored procedure can have a maximum of 2,100 parameters.

I think the conversation has brought up some key points. People use words like Guru and such with their own view of what it means.

As long as you can produce a valid key if ever questioned I would make a note of the issue on the box and keep the valid key in a...

With this line

6/25/2007 04:00:10                    Add      The project has been paused, (80041811 - The disk is full and the specified operation cannot be done.  ) 

I would check the free space...

Sounds like you application is trying to create an invalid cursor for the data on the server side. Does the database you connect to get some data from a remote...