that stored proc is used inside other system procedures...if you were to drop it, i guarantee you will, at a minimum, break replication, the SQL Agent, scheduled jobs,let alone lots...

I'm afraid the answer is "it depends"...we'd need to really see the procedure to give you a peer review and tell you what we thing is good, bad, or could...

you need to replace vbCrLf with the html break tag <br /> & vbCrLf, whether in the data source at SQL, or in the textbox/panel you are loading the data...

ok one imporvement i see is some out of date statistics on the Table CorrespondenceLog;

the estimated plan expecting 4 rows, but the actual ended up using almost 12 million.

can you...

great greg...can you post an Actual execution plan? that's where a few more details will help as well

ok i see what you are saying...you have a slow query, and at least a portion of the slowness is probably attributable to the grabbing lots of rows with ...

SQL Server indexes are constrained to a maximum width of 900 bytes; so you could include *part* of that text column, potentially;

typically when you have to search a text/varchar(max) column,...

i wouldn't say bad practice; you'd have to review the logic to determine if the data REALLY needs to go into a temp table (like it's being further processed or...

lol this made me think and change my signature!

I was going to do the expected response like "Well every app [font="#FF0000"]I[/font] create is perfect", but i couldn't keep a straight...

ok, i think you can simply alter the column.

ALTER TABLE MyTable ALTER COLUMN MyNTextColumn VARCHAR(MAX)

let us know if that fails, it worked on a simple test table i created...but if...

here's the full reference to Cast And Convert; it's good to read, it's something you end up using a lot

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Select

convert(nvarchar(max),TheNTextColumn) AsColumnName

From TableName

i've used this for pipe delimited; does this help?

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns ORDER BY object_name(object_id), column_id" queryout C:\Data\Objects.txt -t"|" -c -T '...

where is the DECLARE @Number bigint statement?

where is the SET Number = CONVERT(bigint,????) statment?

what you posted is disconnected from my perspective...iu think you need to show more of the offending...

so you can only have 365 records per year(or really one record per day)?

that's what a primary key based on just the days would limit you to? does that...

you'll need a larger data type...bigint might hold it.

the largest int is ~2 billion...your value's a few orders larger than that.

select convert(bigint,2011060910105711742)