personally I usually put the results of a proc into a temp table, like this:

CREATE TABLE #WHORESULTS (

[WHORESULTSID] ...

i have yet to find a situation where a trigger featuring a cursor cannot be replaced with a set based operation. Usually a trigger might have a cursor because the...

you cannot get it to prompt for a value. it's not designed that way...it is designed to run unattended.

what you can do is make the job check a value in...

well, because Express does not HAVE analysis services or SSIS, getting an error message about being unable to analyze them for upgrade is a non issue.

I don't see anything preventing...

the devil is in the details...

what is the real name of the proc?

for example, you know that anything that starts with "sp_" is assumed to be in the master database...maybe...

sp_depends is 100% accurate for tables functions and views. you cannot create any of those things with a dependency to another object unless the object exists.

because of the way...

also i'm under the impression that verswion is more tied to the SQL the db is restored on...i took my SandBox from 2005, restored it on my sql 2008, and...

also consider this: change the presentation so it is not user centric...make it functionality centric.

a tree view with branches and sub branches of your modules and sub modules would probably...

from a security presentation standpoint, I'd think that seeing 22 rows one for each security module, and having usually 4 security points, but sometimes 7 or 8 points would be...

ok i see what you mean now;

i think the solution is to simply sp_helptext sp_helpuser, copy the parts of the code you DO want to use, and use THAT in...

Joe Celko (7/14/2010)

---

SQL is not a text language. Get a copy of Mellisa Data or other address data scrubbing tools. They will get you to CASS and 9-1-1 Standards much...

i can't duplicate the issue;

i can certainly insert the EXEC SP_HELPUSER into a table, but what do you mean by a database alias?

do you mean where you rename...

well...you're going to present someone with a grid with 700 + columns? why? I would simply NOT do that.

maybe a redesign should be called upon to revisit why the data...

Julie try this function agaisnt your data.

this strips out everything that is not a number and not a character...so spaces, control characters, brackets or whatever get stripped out;

that seems to...

failrly straightforward requirement Bosco. they will not get any rights you don't give them. if they connect with SSMS, you cannot hide the existence of other databases, but they can't...