i don't think this was the problem, or have i misunderstood.

isn't the problem making them HIDDEN, so that users don't get confused with so many choices

I recommend the Osborne (mcGraw Hill) books, and also the microsoft press books, although they might be a bit heavy for beginners.

your most important areas for SQL server are understanding...

in that case (depending on the qty of data and the read/write ratio)

i'd place the data on the raid 5 and the T-logs on the raid 1

although beware, if you...

Alex,

there are several issued here. cost and good design.

i recommend the following

system drive -Mirrored (place Sql server system databases on this drive also)

data drive - Mirrored and striped...

i know in crystal reports there are plenty of options for filtering out system views, stored procedures etc etc...

are there such options in business objects? sounds like you coud escalate...

you checked all the database roles?

including DENY_DATA_READER and DENY_DATA_WRITER

this sounds like the problem

you only need to grant them the single role of Database_owner and they have all the permissions you...

To be honest - i can't think of a way to do this

in the past when writing bespoke apps i have created a view that runs along the lines of...

i've also found that importing to Access first and then to SQL improves the process.

et voila.

my logo and hyperlink!!

That's correct. if you want a field to not allow duplicates (that isn't the entire primary key) then you need a contraint.

if you are in the UK...

antares is right.

what happens if more than one person have the page open, do they all process the data?

how about using the page to append to a Holding table...

True.

Just waiting to sort out all the other stuff as well (like a company logo etc...)

just for you i'll sort it out today!

or did you mena that the transaction log becomes fuill because of the amount of data that you are manipulating? if so switch to SIMPLE recovery mode and checkpoint the...

you've obviously got to keep the data until you have migrated it into the new table.

you should still keep your invoice table with the fields invoice_no,invoice type

then how about...

where did you decalare the @counter variable used in the following? unless i'm being really stupid here.

update STable

set counter = @counter,

@counter = @counter + 1

where sid=@sid

and STypeID=@STypeID

have you also...