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...

never heard of this locking code before today. it looks like a calculated value created by the program ecoid.exe.

the program echoid.exe is not a Windows included executable, so of...

if you can do it to one row, even if you are doing it in multiple steps now,...

satya.sakamuri (5/11/2010)

---

Hi,,

could anyone help me how to identify which tables in your database may need additional indexes?

in my databse there are 200 tables ech contails aroud 15 columns adn...

my copy/paste of your query shows it to be syntactically correct; i don't see a problem with it;

if you change the query to a sample query, does it work and...

a basic example might be Addresses; a normailzed database would pull out CITY and STATE to seperate tables, so your ADDRESS table would have CITYID and STATEID instead of the...

database scope, i'm sure; did you open a new query window(which might be defaulted to the master database?

the query would fail because our ''WEB_CATALOG_IMAGES' table doesn't exist in master.

change the...

satya.sakamuri (5/11/2010)

---

Thanx Lowel,

i selected the database whic i want to perform inthe place master.

i was wondering do i need to create a new folder in the browse for a...