hi,

SSIS is NOT backwards compatible, How can I fix It.

thank's

thank's all.

so if I read a table that I not change, I read it from the buffer or from the data file ?

ok, how can I know the defult time that sql define for checkpoint ?

I ask you this because when I run some Insert query into table, I sea the values...

? "At some point later .... ?" - when this is happen

thanks

I am in the devlopment Forum ...

hi, I try agin to be more specific...

I Insert a value in my variable called - app.

now, i want to exec this sql statement, that use this variable app :

declare...

hi,

I mean somthing like that :

CREATE TRIGGER ddl_trig_database

ON ALL SERVER

FOR CREATE_DATABASE

AS

BEGIN

declare @db nvarchar(200)

declare @STR

...

hi, here is all the details the type of the triggrt is database, that should run whenever anyone create a new database.

the trigger need to backup the new database that...

I read you advice. but I mean that the user will be able only to update the table of extended properties.

hi, thank's i try also your code.

finally, i sucess to fix iu with this code :

create PROCEDURE ywork @domain nvarchar(100),@db_name nvarchar(100)

AS

declare...

you righ't, I fix it but I still have a error - property cant be updated or deleted.

property 'Domain' does not exist for 'object specified'.

this the new code :

CREATE...

yes, thank's.

I create this stored procedure below, but I get this error when I try to update the properties :

property cant be add. property 'Domain' already exists for 'object specified'.

the...

ok, thank's a lot. I understand what you are trying to tell me.

u will look for another solution.

yes, I mean to input data in report and update database by this input by ssrs.

it is possible ?