in @subject ???

i'm not sure about anyone else, but i've never seen an email client that has formatting in the subject header - only in the body text.

if you are thinking about this then you should realy look at Citrix Metaframes as well. you can run your application as a seamless published app. (or on a citrix...

i've just re-read some of the posts - you say that on some days it is the correct size ?

are you doing any overnight batch processing - a reindex...

here's something else to try -

use DBCC cleantable on all of your tables to see if there is any space to free up (after your migration from sybase)

this...

try casting as a char(8) and then passing as a string to vb

or in vb use formating to add back the trailing zeros

it's for the same reason that Query analyser...

this works using the top method

i have used a query to pick the top column from each table in the database - replace with your own table names and foreign...

select sysobjects.name,max(syscolumns.name) from sysobjects,syscolumns where sysobjects.id=syscolumns.id group by sysobjects.name

this finds the max value, not the TOP value. might be applicable to you though

no problem -

although looking at this in retrospect i think we could have done a lot better.

at least it will work though!!

oops just spotted your mistake

update VT_MailInfo set Inf_EmployeeNo=(select Pers_EmployeeNo from VT_PersonelData where Pers_FirstName=@FirstName and Pers_LastName=@LastName and Inf_DupMail=1) WHERE ......

hey i'm not that old!!

but i'm findig these QWERTY keyboard things a bit awkward compared to puch cards and kimball tags

what i meant was that you are running the update against ALL of employees without checking to see if they have the DUP flag set -

your cursor picks up...

it covers most of the things in the BPA, and the baseline security analyser, but also a few other things all in one package.

with the manually written recommendations it also...

i can't see how, perhaps it may allow you to change it. depends on how your services are set up

if they are set up to run under local admin or...

there is little linux utility disk that you can download from the internet.

boot from the disk and it will discover your local admin passwords and accounts from windows machines....

heh...

update VT_MailInfo set Inf_EmployeeNo=(select Pers_EmployeeNo from VT_PersonelData where Pers_FirstName= @FirstName and Pers_LastName=@LastName and inf_DUP_MAIL=1<-----THIS BIT HERE ???)