as far as i know, you can get it only if they used their windows credentials to login to the server; if they logged in with a SQL login, it's...

you had joined them, thought that's what you wanted;

try a UNION ALL instead:

Select

Alias1.id ,

Alias1.type ,

Alias1.number ,

Alias2.ID_NBR ,

Alias2.PHONE_TYPE ,

...

a slight variation on your original code; all i've really done is present more data, so you can see the changed columns;

since you never showed the PHONE_NBR from the other...

restoration of items is something done from within TFS inteface in Visual Studio, and never at the SQL Server;

i'm pretty sure this is the steps:

in Visual Studio go to "Tools>>Options"...

well, i was looking at using the function is_rolemember(which returns 1 or NULL, not 1 or 0) and IS_MEMBER('af_developer'), but i think it finds explicit grants to roles, and not...

I don't think you understand the security model;

it is very common, for example, that an end user does not have any rights to tables, and all the operations occur only...

TheSQLGuru is right! this forum is one of my first items on my list of resources!

this...

I've been a member here for a while, and my skillset has matured in a large part because i answer questions here.

I'd love to see my first 20 posts here...

i think you could put the code in a stored procedure and use EXECUTE AS.

as an admin, creat ea procedure with the work inside it like this:

CREATE procedure pr_CallExternalProcess

...

wow that's a good question; i hadn't thought about auditing Reporting service instances....

do you think it would it be enough to use something like SQLRecon to find all SQL instances,...

No! those are my favorite threads!

"URGENT" posts are like a train wreck or...

there was missing commas and closing parentesis; Here is a syntactically correct verison of the above example, but I did not test ti to see if it worked:

declare @my_root_nbr int

set...

robert i've done this as part of the query before, but not as a feature of reporting services.

for example, i knew that i wanted exactly five columns of data, as...

here's what i use;

due to a naming convention, i know i can skip tables that begin with certain characters; you might have similar logic which designates which tables are lookup...

run the procedure sp_depends; it will show all tables,views, functions and procedures that depend on your table;

because of late binding on stored procedures, it is possible that a procedure has...