i learned too late that the SSIS job doesn't transfer passwords. Had to manually assign the password on like 20 SQL Logins on Friday.

little line about stopping replication for the install

anyway it went pretty bad. we ended going back to SQL 2000 on this distributor upgrade. I think what we are going to...

one limitation is you can't upgrade from SQL 2000 Enterprise. We have it in QA and I had to uninstall and install SQL 2005 from scratch. Good thing is that...

you have to look at your data types in columns and the number off rows you expect. Once you get this number, double or triple it to get some breathing...

you can try to set the recovery mode to simple, run your job and then set it back to full

how long is lots of time?

i've seen indexes take hours to create on large tables

i had some weird errors similar to this when installing SP1. When I set up our QA servers i keep them in windows authentication until i need to activate the...

i played with mirroring and got it to work with separate principal, mirror and witness servers all running SQL 2005 Enterprise

has anyone else done this? I'm looking where to get the software needed to connect to Informix from SQL

can you help a brother out in getting some Informix ODBC drivers? We need to import some data into SQL from Informix and I'm trying to track down the drivers.

i found that sometimes unless you copy the install files locally to the server you are installing, it errors out with a permissions issue or something similar.

everyone knows that all developers are evil

I think it's more of the same MS battle beween the GUI and the command prompt/scripting. Back in my MS Exchange/AD days I knew...

easiest way to check

get a PC, record the IP

try to access the extranet

check FW logs to see which ports are being used

create rule to open the ports

test again

the one article they had here said the success rate is like 75%. otherwise you have to make it up from scratch again, which is what i'm doing

i think you have to check off workstation components to make sure it's installed