Under what conditions could you duplicate the problem? Just started showing up or only after you install .NET application extensions? Does everything function properly at the server for those items...

Cross post, please do not cross post, please see response under http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6401&FORUM_ID=23&CAT_ID=2&Topic_Title=parsing+a+column+to+replace+all+commas+with+spaces&Forum_Title=General

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

This should get it done.

--Should be able to change YourTableNameHere with your table name.

DECLARE @maxcol int

DECLARE @posmark int

DECLARE @col VARCHAR(255)

SET @posmark = 0

SET @maxcol = (select max([colid]) from syscolumns WHERE...

Several issues can affect this. One is an index is incorrectly reporting its' size. Delete all the indexes and add back then see if resizes. First however try DBCC UPDATEUSAGE...

Unions are really only needed to join to data sets that are similiar. Example may be a history table and a current table with the eact same columns you want...

Not impossible that the buffer has a limit. I have not read anything to this effect either but the best suggestion I can offer is contact MS as a bug...

Depends also on several other factors. If the application that is sending it to be stored and you want to avoid cost the look at Microsoft CAPICOM which supports several...

The problem with DBCC LOG is the output for the query is not text but varbinary/encrypted or something like that and I have found no details on this. Log Explorer...

If you can run this in QA

SET SHOWPLAN_TEXT ON

GO

YourQuery

GO

then post the output here and we can offer possible issue points.

"Don't roll your eyes at me. I will tape them in...

quote:

---

What's the diff between the dual-slower-processor or the single-faster-processor server?

---

Concurrent processing. An extremely expense process...

One thing of note. Of the size of the index taking from the database, a clustered index can in many situations save space. The reason for this is the way...

Ok so you submit to one variable and if you try to do IN (@myvar) it looks like IN ('1,3,10') now you can do this one of two ways.

Either use...

May or may not be depending on the install path. What I suggest do is test by renaming the folder and see if this causes any issues. If not then...

I scanned it one day and as Steve said nothing earth shattering. Most of the information can be found online but again this is an at your figertips source. Don't...

Also CONVERT can make it easier breaking pieces apart if you do this for viewing while you can store as one field or 2 like suggested before. However, do you...