My guess is the client does not want to see stored procedure code (documented or not). They want to know the logic of the procedure. Since this is a "data...

Good question and actually makes sense if you think about it. The check constraint is checking for values. From BOL

CHECK constraints enforce domain integrity by limiting the values that...

Are you getting an error message? "Not working for me" doesn't give me much to go on. 😀

Here is a decent example of getting your connection established. http://support.microsoft.com/kb/306125

sabahsuhail_fjwu (10/15/2011)

---

Sean Lange (10/14/2011)

---

Why do you care about encrypting a timestamp column?? timestamp (or rowversion) is a deprecated datatype anyway and should be avoided for new development. http://msdn.microsoft.com/en-us/library/ms182776%28v=SQL.105%29.aspx

Encrypting this seems...

SQL_By_Chance (10/15/2011)

---

Sean, Thanks for your help.

The ";" after Rule_DB is making...

The point is the "generic" way you will not return any rows when the where clause does not find anything which is specifically what the OP is asking for.

Performace Guard (Shehap) (10/14/2011)

---

I see the below one is mcuh fastrer + ore simple since it saveds us from creating any additioanl ables and inner joins as...

Tallboy (10/14/2011)

---

Thanks again SSCrazy.

I have linked tables working now between access 2993 and sql server 2008 and for me that's a big step forward.

Although all my tables are...

Thanks for the reminder Lowell. I sort of vaguely remembered there was view with that info but couldn't think of it. Now I don't have to.

That looks like a pretty good approach to me. The only thing I would do differently is to use the Delimited splitter from Jeff's article. It is crazy fast and...

Why do you care about encrypting a timestamp column?? timestamp (or rowversion) is a deprecated datatype anyway and should be avoided for new development. http://msdn.microsoft.com/en-us/library/ms182776%28v=SQL.105%29.aspx

Encrypting this seems like overkill because...

Here are the articles from BOL.

Save DTS package: http://msdn.microsoft.com/en-us/library/aa216436%28v=SQL.80%29.aspx

Open DTS package: http://msdn.microsoft.com/en-us/library/aa216421%28v=SQL.80%29.aspx

Been awhile since I did that but I think there is an option to Save As .dts or something along those lines. I remember saving them to a file with...

It is pretty hard from here to get a real understanding of what you are doing but it does seem a little odd ball. Of course what application doesn't require...