as Sean alluded to , there's several ways to get the name; you could join to sys.objects, or use the built in functions like object_name:

SELECT OBJECT_SCHEMA_NAME(OBJECT_ID) AS SchemaName,

...

my old shop used it for two reasons; regular expressions for doing ETL on staging tables(no SSIS in that shop...everything is TSQL), and a custom implementation of AES encryption; the...

I don't believe the permissions are that granular; as i understand it, once you grant ALTER, that's ALTER any object.

I believe you can only do by granting ALTER, and then...

performance will ALWAYS suck on this: it requires a table scan due to the LIKE operator, which would have to check every value for values that contain or end with...

now if you want to view the trace results, i like to create a view for each trace: unfortunately, i think it has to have a path variable to be...

paulaalkz 9229 (2/19/2014)

---

Hello. querying sys.traces I found out today that Spotlight Quest is running two rowset traces. I can view the events and columns it is capturing but I wonder...

ownership chaining, and it's the default behavior.

if you grant EXECUTE on a procedure to a user with no other permissions, as long as the stored procedure only touches objects in...

use the metadata to build a query;

probably featuring a UNION ALL if you want them in a single resutl set

SELECT

'SELECT ' + schema_name(schema_id)+ ' AS SchemaName,* FROM '

...

do you have any plugins like SSMS Tools installed? I can't prove it, but it seems to me that my connections get disconnected when not used for x minutes, and...

if you have users explicitly created without logins, then there's is no password. users don't have passwords, only logins;

I've create users to run EXECUTE AS on occasion, and of...

If you want thenlogin to see data then youd have to add a user for the login and grant it either specific select permissions or db_datareader.

sounds like there's a problem with the logic in your process.

a job should change...

the above are not necessary to make other objects...

take a look at this post i made a few years ago, it's got a nice example of a couple of schemas you can fiddle with.

http://www.sqlservercentral.com/Forums/Topic1216364-1550-1.aspx#bm1216431

sysadmin overrules all; any restrictions that you add on a sysadmin are ignored/cancelled out by that ring of power.

normal users, then yes, the most restrictive wins, but you can't add...