I was able to trace it through the profiler... just the question is... how do you determine if connection pooling is working or not? Right now each query from the...

Basically I'm answering my own question... the answer is because the ANSI SQL92 configuration for ANSI PADDING... we have it set to be on. The article below accurately describes how...

From the developer's perspective, if you are really trying to avoid scope creep then those moments of having a user pass on a request like that can be detrimental to...

Thanks... we'll have to check that out... because we were querying a table that has over 100k rows and the result set can be a few hundred.

Mohammed thanks for the article... A lot of information to digest but it really does get the accurate point across.

Thanks again

Thanks for the tips... I will have to confer with the rest of the dept about the RAID configurations. Also I've noticed that if I'm not working with a X64...

all intense purposes... the task was to move away from declaring the column a char or varchar so we wouldn't have to validate the time in the code of the...

No need because the column is intended to just store the time portion... The date is stored in a different column that is indexed..

Granted I could of have stored the...

You are welcome, I spent about a day trying to figure that one out until I tried the QBE in Enterprise Manager... sometimes it's good to let sql2k do the work for you HA!

Yeah I figured it out...

CONVERT(DATETIME, '1899-12-30 11:00:00', 102)

will give me my desired result

thanks

Right, we currently use a user table... plus from the application stand point, the connection to the Database is through the SA account. We are figuring now that it might...

interesting, the triggers still didn't fire... we just did a complete import of all tables.

what I'm trying to is a data conversion from a non window's based db into an existing SQL DB... I truncated the whole SQL DB so all the tables are...