exec sp_helpdb varuna

or

exec sp_helpdb varuna70

returns blank.

thanks,

Luiz Carlos

Jules,

In reports there is a database called reportservertempdb.

There is a table that stores the reports with expiration date.

Try this:

use reportservertempdb

go

create trigger snapshotdata_ins on snapshotdata

for insert

as

delete snapshotdata

Thanks Grasshopper,

Worked fine. Helped a lot.

I have a report "Suplie order" with the custumer data.

In this report "Suplie order" , i have to subreports "Products" and "Services"

In the main report "Suplie order" i want to...

Apelou, perdeu.

Thank you anyway.

Thank you RGR´us.

But a equation isn´t that simple. Where have ABS, sin, cos, or, and, not, (x*y)^n, etc. and much more. I will have to store a dictionary in a...

Thanks Marshall.

Any idea for a strong protection?

Thanks again Marshall,

But look

calcula_formula '10+10/3TRUNCATE TABLE cfop'

Results

(1 row(s) affected)

Server: Msg 4712, Level 16, State 1, Line 1

Cannot truncate table 'cfop' because it is being referenced by a FOREIGN KEY...

Because de caracter ";" is not necessary.

Ex.:

calcula_formula '10+10/3TRUNCATE TABLE cfop'

Results

(1 row(s) affected)

Server: Msg 4712, Level 16, State 1, Line 1

Cannot truncate table 'cfop' because it is being referenced by a...

Thanks Marshall, but how could i "just searching for semicolons"?

Thanks a lot.

I did this.

create procedure dbo.calcula_formula

(

@formula varchar(2000)

)

as

/*

CONTROLE DE VERSÕES

VS. QUEM DATA O QUE

1.00 LCF\luiz 30/05/06

*/

begin

 set @formula = replace (@formula, '--','+')

 exec ('select ' + @formula )

end

select 'ALTER TABLE ' + so.name + ' DROP CONSTRAINT ' + sc.name

from sysobjects as so

inner join sysobjects as sc on sc.parent_obj = so.id

where sc.xtype = 'C'

order by so.name