Hi,

U say that when u run the DTS manually it runs fine and when u schedule it it gives error.

If u loged in sql server with ur admin account mapped...

Hi,'

Do u want to do this for one table or for number of tables.

if u have to do this for all the tables then use variables and query to sysobjects...

Thanx, Phill

Hi Ranga,

Use sp_who .This will give u the information. about the accounts.

from

Killer

Hi ,

U are right chris.

from

Killer

Hi Farad,

If i understand ur question then u need that if the CPU process timing is very high or cpu id using full resources then the heavy report should be...

Hi,

Restore is good what about the Logins.

Tranfer all the logins also.If u have replication set create the script of it .

If u have scheduled jobs script the jobs or tranfer...

Hi Phill,

Thanx, I did not think on that point.

Search out in Google for barcadero (DBArtisan).

HTH

from

Killer

Hi Veeresh,

As per my knowledge u cannot query all the tuples without a join.

A tuple is used to define a slice of data from a cube; it is composed of...

Hi,

Sorry i did not understand the question.Pls be more descriptive.

As i understand u need information about logfile

dbcc loginfo

HTH

from

Killer

Hi Veerersh,

What version of oracle do u have .

As i have oracle 9i , oracle 10g , Sqlserver 2000 and Sqlserver 2005 (Beta).

We use oracle migration work bench for conversion.

It...

Hi,

As per BOOKS ON LINE . The Artical truncating the log file gives us information that all the space is freed except the Active portion of the transaction log...

Hi Eric,

Eric it sounds like skeptical.But dont worry u are secure and make it more secure.Update urself with the rights u had issued to ur users.Block all the free ports...

If u execute any DML command on a table and at the same time u issue another command on the same table .

SQL Server put a lock on that table becasue the...