Viewing 15 posts - 9,496 through 9,510 (of 13,469 total)
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...
May 13, 2010 at 8:45 am
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
...
May 13, 2010 at 7:48 am
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,...
May 13, 2010 at 7:23 am
D.Oc (5/13/2010)
Steve should ban those words (URGENT or IMMEDIATE HELP or NOW) to appear in the title.
No! those are my favorite threads!
"URGENT" posts are like a train wreck or...
May 13, 2010 at 6:41 am
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...
May 13, 2010 at 6:32 am
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...
May 12, 2010 at 9:27 pm
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...
May 12, 2010 at 11:49 am
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...
May 12, 2010 at 6:59 am
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...
May 12, 2010 at 6:08 am
Robb Melancon (5/11/2010)
... The calculations are more involved than simple summing ...Robb
if you can do it to one row, even if you are doing it in multiple steps now,...
May 11, 2010 at 7:59 pm
satya.sakamuri (5/11/2010)
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...
May 11, 2010 at 11:59 am
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...
May 11, 2010 at 9:53 am
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...
May 11, 2010 at 9:34 am
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...
May 11, 2010 at 9:28 am
satya.sakamuri (5/11/2010)
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...
May 11, 2010 at 9:06 am
Viewing 15 posts - 9,496 through 9,510 (of 13,469 total)