Check in the extended options, there are some things that don't get scripted by default.

Debra Owens (1/25/2008)

---

After running several test the top 1000... will not work with the query.

The user name and date is being queried, member quired is not one of the 1000...

Per BOL:

CHECKSUM satisfies the properties of...

While I agree with Steve that we can't help you answer this specifically - don't fall of the marketing nonsense that the SAN will "automagically" or somehow auto-sense what you...

Well - if you want to me acknowledge that writing procedural code is easier to do in a procedural language than in a set processor...Well - sure...:)

And - what other...

I think you're running into SQL Server not being able to detect that the two pieces of code are the same, and is not able to appropriate parameterize (using "simple"...

True - but the "ease of coding" in CLR vs T-SQL in that case comes from having access to custom libraries (the encryption/decription namespaces, etc..) in CLR, which aren't...

Well - it seems to think that you are, which is why the error is there. Sounds like you started to set it up, but haven't finished, so you...

If the persons calling this aren't dbo's, why not define user-specific functions or prcedures for them.

a.k.a. bob.myfunction(), jody.myfunction(), etc...?

Or - instead of checking by person, perhaps...

Of course - if these are SQL tables linked in, you can't alter them at all from within Access. The most you could do is to "ask SQL Server"...

And - there's NO guarantee that it won't return the same number twice... The larger the set of numbers, the more likely it WILL duplicate the number.

Try this instead:

select...

I'm just amazed at how many people right here have reported that they've had it happen to them. Maybe we need more DBA's in HR or Payroll....

The closest I've...

First - don't cross-post. Having the SAME question posted 4 times is wasteful, doesn't help you cause at all (especially when you post them in non-relevant subject areas)....

First - don't cross-post. Having the SAME question posted 4 times is wasteful, doesn't help you cause at all (especially when you post them in non-relevant subject areas)....

First - don't cross-post. Having the SAME question posted 4 times is wasteful, doesn't help you cause at all (especially when you post them in non-relevant subject areas)....