Kali.. yes the IMF uses a whole boatload of traits to determine the emails probability of being spam.. I think it would be pretty hard to craft an email that...

Wow.. I wish they would add some of our internal emails to the spam list!

Doh, I recalled incorrectly- they will indeed assume the most priviledged role.Sorry. anywho, according to those pages none of those roles can edit schedules of jobs that do...

There will be some performance degredation as SQL needs to encrypt and unencrypt on the fly and there may be a jump in size with the data being stored as...

We are indeed talking about the the same data.. however the 1st time you run the proc it has to do a bunch of disk IOs to grab all the...

If I recall correctly, SQL will use the most restrictive of the roles if a user is in more than one. Try just putting them in the Agentoperator...

I believe it is 2GB in bytes. If you have 4GB in the box you need to have the /3GB switch in your boot.ini to allow sql to grab...

well, on a 2003 box (and probably a W2K box as well)if you go to taskmgr and into the processes tab you can select options/ tools I think and...

The results you see from QA is the default when you have dynamic mem set. If you were to set a hard limit in EM you should see...

have you thought about using replication? There are also 3rd party products out there that can do realtime byte level replication across locations...its an investment so I guess it depends...

I am only guessing here.. But do procs 1 and 2 reference similar tables/indexes? Proc 3 seems to be consistent either way so I'll leave that out.. If...

SMS can generate a change script for you if you like.. Basically the script will generate the DDL for your "new" table (with the new column) and then it will...

BIDS (Business intelligence Development Studio) has within it a DTS migration wizard- open up a project and you will see SSIS Packages on the right had side- Right click and...

Sure.. Create a new job and Go to "Steps" and pick type: SQL Server Intergration services package. Then Pick the server that is hosting the package and then...

If you create a new dtsx package you can add a dataflow task and in the task there is an "excel" source. you can point it at your excel...