Wouldn't option two limit my WHERE clause runtime, as the view CHECK OPTION would limit how many records are scanned.

Main Table - Data for 2 years, 2004 and 2005

View ONE...

All the tables except TRANS_ITEM have a unique ID, however the TRANS_ITEM table have many TransID to ProductID, thus TransID is not unique in the table. And thats my point.

So...

How does one post examples of a database relationship diagram ??

You must use ADO to capture the error when running the stored procedure from the client. Google ADO error capture stored procedure. The difference btw ADO and DAO errors, is...

I found this use of a WHILE clause, what do you think ?( By: ikramkahn )

DECALRE @somevar varchar(30) --optional filter paramter

DECALRE @maxrow int

DECALRE @ii int

DECALRE @param1 int

DECALRE...

Thx for Help EXCELLENT forum

Big Cheers

I do have dynamic SQL used, that explains a few things...

Cant find anything on this in BOL, can you ??

Thanks for help, worked great !

I found this script named : ..."To compare object permissions with 2 databases"...it does what I ask except...it does not seam to list my USER tables. views and procs, only...

Thanks heaps

Thats where I learnt it, I was just after a second opinion, to see if I have done good !

Thanks worked fine !

Nope I got it wrong above.. do this

1) Use NT Windows trusted security for entry into the server

2) Make sure PUBLIC 'database role' permissions are turned off (see...

...'I assume that you are talking about putting the code into a sp). '..

YES, and thanks for help

I dont have MS Visual Studio .NET

I am using MS Access as a Client.

Any other ideas