if you go to the MS Certification site you should find something. Personally I think most of the classes are worthless. with something like SQL you aren't going to learn...

is this with windows 2000? you need IE6 and I forgot what else for the client tools

are you running SP4 with the hotfix? when you select @@version it should return 2040 which is SP4 plus the hotfix.

I have the MS training kit for 70-431 and we are testing it at work. there is also the small red book with only practice questions that is pretty good...

i have some family up in Larimer County and I look at the local listings on Monster when I visit. Compared to the number of listings around NYC, doesn't look...

are these spids that are not disconnecting or are they running long queries? Is there a difference in the query execution?

If you can restore a month old copy (pre-SQL 2005)...

i never liked classroom training

i say hack your way with whatever databases you have available. instead of using the GUI, learn to write everything in SQL on your own for...

MS has online labs now for SQL 2005, just get certified in that. i was thinking about SQL 2000 cert, but won't do it now that 2005 books are out

just checked our BB database. for around 100 users it's 2.56MB.

at least in our case I think MSDE is OK

the upgrade is kind of flaky and i had it where i thought i was upgrading when i installed another instance

best way to check is in your start menu. if...

I think it's whatever OS you have. Pretty sure you also need Windows 2000 Adv Server or Windows 2003 Enterprise also.

if both servers are mixed-mode, what about using a local SQL account for authentication and passing it in the script?

one interesting bug I've found with MS is if you have...

officially our policy is for Access to use our R/O copies, but we have an unknown number of MS Access apps floating around that departments created themselves that update the...

i had a similar issue on some very large archive databases we have a few months back and we use Veritas which uses the SQL API's anyway. Sun, our support...

put the data into SQL, back up db, back up the access files and keep the tapes or whatever somewhere safe

easier keeping the data in one location than keeping track...