will look for a solution. but can you not just use a stored proc for this, coz it might be easier.

i would probably have an initial screen for putting the...

having the sum in your expression will not make much of a difference to what you want to achieve.

what problems is it causing?

yes, you should be able to. as long as you can do the reports properly, because thet are based on xml.

open the reports in notepad or any text editor...

we all wish m$ products could work seamlessly

Tools ->Email Accounts ->View or Change Existing -> [Select your Account] ->Click Change -> and wala you should see it. its a checkbox.

this is on outlook 2003

I have cached mode turned on, and I could not duplicate the error. Have you installed the service packs as yet?

Joseph's point is correct.

I just tested on my server.before i had security set to both, and then I set it to windows authentication only and had to restart it.when i...

I have win xp with latest update, outlook 2003 and sql 2000 with service pack 4.

i tried to setup with similar stuff like yours and it works fine.

this removes the...

in that case i would advise the solution suggested by Steve

i am using both types of authentication.

the problem you are having could be because you are on a different subnet mask.ask your sys admin or network guys.

i agree with jen.

but if you must you can put your table names old and new in an array and then probably use a cursor with your sp_rename

can't exactly understand what it is you want to do.

what is the current scenario, you can post you beaten down script to help me understand more

if you don't mind my saying, looking at your code i don't think you will achieve what you want because you have put wild character string [%] at the end.

what...

the database is in the folder where the rest are kept.when sql 2005 is being installed as is now the practise by ms, they put some of the sample files...

DECLARE @To VARCHAR(500)

DECLARE @MessageString VARCHAR(500)

DECLARE @User1Email VARCHAR(500)

DECLARE @Topic VARCHAR(200)

SET @MessageString ='This script will send an email'

SET @User1Email = 'someone@mars.com' -- use semi colon to seperate many email addresses

SET @To...