Yes. Each NVARCHAR column could require up to 8000 bytes each.

Show how you are pulling out the values from the initial values.

Leading zeros or trailling zeros? looking at the data, I'm thinking trailing.

Lynn Pettis (4/8/2009)

---

Tara (4/8/2009)

---

Ok,i'll put in with some example.

I have tableA with CCode

ID CCode

1 98773

2 68790

3 62098

4 ...

If that is the only option, that may be what you need to do. As it is using SQL Server, you may want to verify with them that they...

Only suggestion I can come up with at this time is try using the Activity Monitor and look at locks by object.

I'll need to do some more research to see...

You don't rollback an install of a service pack. That usually requires a reinstall of SQL Server. This is why you want to test the service pack on...

You said the computer is not Internet capable, is it on a local area network?

It may be possible to download and install the SQL Server Express management tools (Gail, am...

Give this a try:

with GoodCerts (

CertNo,

StringYear

) as (

select

CertNo,

StringYear

from

#tblData

WHERE

...

Other than "Don't do that", not a clue at the moment. For clarification, are there ANY differneces between the servr that freezes and the one that it didn't freeze....

Sample data, expected results based on the sample data? Would be of great value.

They may have purchased it from the vendor. That would explain how SQL Server was preinstalled.

Nooooooooo! Please not that!!!!!

Okay, my testing confirms that it should have gone away. How did the application disconnect from the database? Was it a clean connection or is it possible that...

I missed th 2 'C'. Sorry. Still looking at an alternative solution.