in the program group in the start menu, Business Development Intelligence Studio or BIDS

try reinstalling .NET2

i think you need to use SSIS to open it up from a SQL server

we have HP servers and we run the HP foundation agents software on them. We have simple traps for when sql starts and stops. for other things we use alerts...

if you search someone had a script here. otherwise you can do so via SSIS but the passwords won't get transfered

you need to turn on verbose logging to get more info

start a trace to see where the data is coming from

i would plan on having a few R/W servers and a series of R/O servers that the web servers would hit for data. how much changes do expect would determine...

i don't manage a hosted db, but i can understand it. you are signing a contract and they charge you based on their calculations of the resources you will use.

if...

for the curious we finally upgraded one of our distributors. ended up doing a move server to another machine. we tried a second in place and it failed. it really...

over the weekend we set up an older server we had as a distributor. Dual P3 1.4GHz and 1GB RAM. We are buying more RAM for it and for some...

are you trying to log in as sa or a sql id and it's still only windows security?

have you tried truncating? I think delete causes a lot more data to be logged in the transaction log

can you access the server via both IP's to access files or other simple things?

are you doing things in parallel now that you didn't do before? like large updates and reindexing at the same time?