Sufian, You cannot rollback a restore because it is a transaction.

Phil, you are right, in fact it is the most exciting thread I have ever been on!!!!

I will be here all night if Sufian keeps on posting....

Sufian, can you please answer Brian's question: "When you do have a successful log file backup, how large is it?"

How do you dump transactions of...

Man....I'm too late!!! I miss all the great stuff. Anyway....

Mohammad, what kind of DBA job is this? 200GB of log in 2mins??...you're kidding me!!!.

What kind of users do you have??? They must be real...

......sql server has identity column.

cheers.

I hope this help!

 declare @objid int,   -- the object id of the table

   @indid smallint, -- the index id of an index

   @groupid smallint,  -- the filegroup id of an index

   @indname sysname,

   @groupname sysname,

   @status int,

   @keys...

I know this can be a real pain sometimes.

When you edit/save and run the dts in the gui it will run the latest version.

In EM you need to refresh the...

sometimes we may forget....

exactly what phil said, what's the datatype for TableName? 

if your global variable is a string type you shouldn't have any problem.

What I did was:-

1.create a data.INI file which contains something like this:

[section] --name of the connection

server=servername

dbase=dbname

uid=username

pwd=password

[section2]

.....

2. load this file into dynamic properties task.

when you excute this step you will see...

As you already know if your field1 is a text/image type you can not do a straight compare ie. using '='

you can use datalength(field1) to get the size but not very...

how about stored procs?

DSP is right!!!

General speaking, you can save package as another name and then delete the old parcel.

One way is updating dts package names in dts tables including all versions.

one way is save your packages with passwords, user enter the password then can do edit/save/exec.

Another way is grant user with execute on sp_add_dtspackage, sp_get_dtspackage, sp_enum_dtspackages. Can be very harmful if user is 'not...

deallocate your cursor before exit function.