yes

double checked in the windows components and ASP.NET is installed. I even installed smtp and a bunch of other IIS components. I think i will try uninstalling IIS and reinstalling...

Wrox has some good books. For sql 2005 there is a book for every part of it. db engine, SSIS, reporting services, etc.

once you start using it, it will come to you after a while. some things are better than SQLEM and QA others are annoying.

only think i can say is with...

how is the driver install with Sun? With HP you boot with CD, tell it the OS and then it installs everything for you and tells you when to put...

what kind of error? and i don't see where you are inserting the data into a temp_table anywhere

in BOL there is a script to run to enable database mail for a user

as part of the process that updates that table you can have it run that script...

it was with the cursor

db has around 300 tables and most go through OK, but it gets stuck on a different one all the time

i was on a webinar with EMC/VMWare and they specifically said don't do SQL or Exchange. The ideal for VMWare is web servers, application servers, boxes you have to host...

i think i tracked the problem down. for some reason it's doing index scans when sending the commands to the subscriber. when i run the same update on the publisher...

this is strange

i use a cursor to build a bunch of update commands and dump them into a temp table to simulate the commands the distributor is sending.

through management studio...

did some testing this weekend in production and in a test environment with a copy of the db from last week.

in both cases when replicating the table in question we...

yes, no luck

we also deleted and recreated it from scratch and that didn't help either

what creating an SSIS package? you can put all the commmands in there and do it in a few steps

i installed it on my PC and a reporting server that i set up for myself and is not production. For prod we are going to install it in QA...

we've been having similar issues and we solved it in two ways

first we noticed there are now indexes in the distribution db. we set up a job to maintain those...