I get an the following when I run the query.

[Microsoft][ODBC SQL Server Driver][Sql Server]Internal SQL Server error.

When I use the code formated above I get the following

Server: Msg 8624, Level...

You are correct, the ( open paren was dropped as I tried to format the data. If you look at my previous post, it was in fact a...

Sorry, I don't see the Code option in the IfCODE shortcuts

Sorry about the confusion. The 'group by' clause which is causing the problem is the very last use of 'group by', just before the 'order by' clause at the...

I believe that it does, but when I try to check the permissions of the role the user is assigned to Enterprise manager hangs and never comes back with the...

I made the change in EM and tried building the DB.  I worked like a champ.  Thanks to all for your suggestions.

Wow,

You guys really can beat a dead horse.  Just kidding!  The reason I am asking is that I have a SQL database one an...

Can the identitity property be disabled on multiple tables at the same time? Use this command: SET IDENTITY_INSERT OFF

Thanks for your replies.

I will take it all under advisement.

I thank everyone for thier responses to my query, but I am still unclear on one aspect. 

It is my understanding that DBCC shrinkfile can only shrik a file to...

Thanks for your reply.  This article in books online was very helpful.  However it leads me to expand my question.  I would first like to explain my situation a little...

The issue is resolved after a reboot last night.

I created a SQL job that ran every one minute to delete from <trace Table> where textdata=''

This took care of the issue and limited the size of the table, however...

This is the best way that I have found to move a Tempdb to a new drive location when a drive fails.  Scroll down on the article until you see...

Phil,

In this case unfortuanatly I am constrained by the application which I am using.  While the architecture you suggest does make much more sense from an insert and IO perspective, unfortunately...