Thanks Jack, awesome information and we seem to be thinking somewhat alike (I was going with making to permissions app myself and integrating it with the c# app that we...

Let me jsut throw something else out there... those permissions needs to be able to be set by the directors of the shop (without the intervention of the it group...

We are opened to anything at this point. I have never read and even less implemented anything of the sort.

You have anything I can read up on the subject?

Open access with the ms shortcut (not double-clicking on the db file)

Then open a database and browse to that db, in the options open it as single user or exclusive...

Another bit of info, as far as I remember, if the ldb file is in use, it cannot be deleted (easily anyways) without closing the access applications using it.

Only if sql does a clean shutdown... and that all other connected apps to the mdb file are closed. Then if the lock is still on then you have...

I'll let the gurus in the matter answer that one... my knowledge of bcp stops at spelling it ;).

Is this a valid option : create an ssis package that does...

a simpler option would be this : WITH EXECUTE AS dbo... this solves most of the problems especially with dynamic sql (or you'd have to give the rights to the...

Another point is "how dumb does the dba think you are"?

I mean if you are trusted with maintaining the system, the data and full access to the core of the...

If it's worth beating to death on the forums, it means that th ecommunity needs to hear it... people wanting to hear what you have to say or needing to...

Or maybe I'm too quick at my work and I have to keep busy!

That or I don't have a life outside of SSC :w00t:.

Steve Jones - Editor (12/1/2008)

I'd bet it's...

Here's the official MS answer :

Hi, Thanks for your feedback. The behavior you are seeing is by design. Using assignment operations (concatenation in this example) in queries with ORDER...

I don't really see how much testing this would require...

SET @CI = 'CREATE NONCLUSTERED INDEX #IX_TmpTable_spName ON #Temp ('

if @parm 1 IS NOT NULL or @Param2 is not null

begin

SET @CI...

Just an idea... are you able to conditionnaly choose which index to build depending on what conditions are set to be used in the query?

Here's the idea...

create index on PK...