have a look at a product called LOG P.I.

this can disect logs - but a better method is to create some triggers on your tables that audit deletes into a...

no problem at all.

you although only restore your user databases - the master database controls all sorts of info about your server and a SQL2000 and SQL7 master databases...

this data is stored in pages of data in the SQL data file.

max size for data is 2GB and can be accessed as if it were a normal varchar/nvarchar field....

why not just script out the objects by right clicking on the database and clicking on generate scripts.

you can then select all objects (including users) and your database is scripted...

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...