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 ???)

because it's a dial up or onsite service offered by our company to identify possible problems or areas of improvement.

international phone calls and flights tend to be a little more...

I'd be very tempted to replicate out to the branches. the only issue here is that your liscencing costs will quite high.

what kind of quantity of data will be stored...