there you go Jeff; Call Microsoft and tell them that the premiere RE-BAR avoidance specialist is offering to rewrite any of their 194 stored procs at the everyday low price...

very wierd;

I have half a dozen DotNetNuke installations either locally, for friends, or on my hosted web site;

if you are in as sa or admin you should see everything;

when i...

ok a few ideas;

first to be clear, there is no way to update the data "before" a select statement gets called.

While I know it's possible for the data to be...

what have you tried so far?

you can find all the modified dates and creation dates in sys.objects;

filter the type column for types like 'P' and 'FN', etc

sp_helptext gives you the...

you have to create a trigger for each table you want to audit. it's rare that you really need a trigger on EVERY table...just specific ones is more common.

look in...

readonly permissions?

stored procs only have EXECUTE permissions...

do you mean to read the text of procedure from sp_helptext procname,

or

permission to execute EXECUTE the procedure, but have only READONLY permission...

I'm assuming 's one specific table right?

restore the backup under a different name... once it'se you can investigate what data is missing, and check other tables for missign data as...

here's a step by step, using the DATEADD function, which is hte better way to tackle this i think:

as far as positive or negative, you'd want to handle that as...

you are on the right track as using an identity to help generate the varchar; that's the way we've suggested it for similar issues.

like JKSQL said, the way to do...

here's an example:

create table test (id int identity, category varchar(100),

name varchar(100), allnames varchar(8000) null)

insert test (category, name)

select 'fruit', 'apple' union

select 'fruit', 'pear' union

select 'fruit', 'orange' union

select 'meat' , 'beef'...

the other important question is, how often does the remote data change? what is the time tolerence for the application(is it bad that the data is 1 min/10 min/1 day...

it sounds like if someone runs a SELECT command, you want to make sure you have the "latest and greatest" data from remote servers/locations, is that right?

instead of running yourstored...

just remove the GO just before the ALTER command:

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

changes to

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON

i would simply pass the ALTER...

excellent post by providing the table and data...thank you!

The thing is, DISTINCT is used against all selected columns...so if you select * from 3 tables, you probably are not going...

in SSMS or Query analyzer, you can't...as you identified, the GO statements start a new batch, and you can't interupt the processing of the batches without raising an error severity...