Interesting Michael, by not letting your developers use views, you do kind of

keep their hands tied as far as being able to not run an open ended query, but...

Guard I think I did you a disservice by misunderstanding your initial question, and going off post with my answers. I apologize. As to your question I have seen a...

Ok, you can join a table UDF to a query. Try this :

 

USE PUBS

GO



IF EXISTS (SELECT * 

   FROM   sysobjects 

...

It's a joke, well not really anymore with the economy the way it is. If anyone

sees a 6'3 300lb man out on the side of the freeway holding a...

I see said the blind man. Interesting issue. How do you store the permissions? Can you post the DDL? I have never tried to do row permissions...

Will post it in a sec. Searching for it right now.

Tim C.

//Will write code for food

based upon from BOL :

quote:

---

Bit (dec) Bit (hex) Statement permission

1 0x1 SELECT ALL

2 0x2 UPDATE ALL

4...

quote:

---

tcartwright

are you talking that at functional level I will create an XML file and then I will openxml in stored procedure...

You don't want to use : PERMISSIONS() from T-SQL?

Tim C.

//Will write code for food

quote:

---

You're just trying to show off...

---

LOL, no, I actually like to share my...

My function lets you script all objects OR all objects of a specific type. Example :

object.ScriptDb "DB", "D:\SQL", , , TssSQLDMOXfrFile_SingleFile

generates all the objects with the default options in a...

I have a com object that I wrote that encapsulates DMO that does this very thing that I can email to whomever wants it. Also Bill Wunder has a DDL...

No its not a definite no, but using xml template queries I am not sure how

else you could do the sort. If using a stored proc, you could pass...

EXEC sp_MSforeachdb @command1 = "PRINT '/*CHANGING ? OWNER TO SA*/'",

 @command2 = "EXEC ..sp_changedbowner 'sa'" 

Tim C.

//Will write code for food

quote:

---

(3) DNS reverse lookup only works if the following is true. One, the client is connecting with the actual system name....