Wow, I have several tables with 7000000 where I had to add a column. I didn't see this happen in my case, was like 15 minutes or so. Oh well,...

No I don't know of a way based around what you are proposing. However, you might try exporting to a text file in fixed width columns based on the data...

Try reinstalling your NIC drivers. If the buffer is too large the driver may be screwing up packets. Might be server side or client side. ALso, as you stated you...

Check them out or look at Transcenders. But be carefull as it is quite easy to learn the questions and not understand the answers.

Most of the companies I have dealt with are good (ICON, New Horizons, Techtraining). But not sure of anyone who might be in your local are. There is a set...

I personally like the Exam Cram and other exam related books from Wrox Press. Find them usefull even after the test.

See additional comments in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8158&FORUM_ID=10&CAT_ID=4&Topic_Title=SQL+PROCEDURE+QUESTION&Forum_Title=Certification

I have to agree with Scorpion_66, why are you using a cursor instead of set based. Set based in most all (but not all, there are always exceptions) will outperform...

Can you post the details of how you are running it? Could be something simple that you just overlooked.

Also, when running do you have it set up to log information...

Try setting timeout property of your connection. But when a user is using the form they should never leave it unfinished or unattended for security and integrity. However, if you...

The key problem is the UPDATE clause in your piece. Instead drop the column with alter statement then add back again with

ALTER TABLE table1 ADD column1 int DEFAULT 0...

SO you are saying that it references col2 first then col1 or exactly what. If you PK is defined as Col1, Col2 and there is an index for that then...

Have you checked you return on jobStatus to make sure you are getting a value back?

Also, what happens in Job A to need to have it start job B?

This should do it.

SELECT UCASE(LEFT(col,1)) + LCASE(SUBSTRING(col,2,LEN(COL) - 1))

But the problem I see with COALESCE is yuo example requires all non-null fields concatinated as a string to get all the non-null resutls. However you don't think that looks...