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.

Goldie Graber (4/8/2009)

---

That won't work, Lynn. It doesn't take into account consecutive blanks.

For example if I use the following data, I still expect 1 as the answer but your query...

Global temporary tables (##temptable) stay around until SQL Server is restarted. Local temporary tables (#temptable) will dropped when the session that creates them ends.

Sounds like the client tools weren't install on the server. Was SQL Server installed as part of the application or separately? I guess what I'm trying to figure...

I would also like to verify what version of SQL Server you are running.

sward (4/8/2009)

---

Thanks for your replies. In answer to your questions see below:

* Are the 4 (source + 3 destinations) same structure?

--The destination tables have the same field names.

* Could you...