All cool stuff! Thanks!

So far what I did : I got ODBC to oracle

I was able to truncate table in Oracle from SQL DTS

it worked!

but then I am trying to...

for DTS - there should be some connection to Oracle server and database...using...? ODBC? don't know that part , I am not "very much" Oracle person

SSIS - it is in...

or is there another way exist? to copy the data from SQL 2000 to Oracle:hehe:

we found - the GUEST account was deleted from one of the system tables (I think tempdb) - we put it back = everything works now!

I selected EVENT for the object :  Object:opened . It says it will work when the object will be in use as in SELECT, INSERT or other statements (but it's...

OH! I FOUND SOMETHING!!!

from Internet :

I have come across what seems to be a bug in SQL 2K SP3.

When I have a job with multiple job steps and...

Only in the output script. In the Jobs - all steps are in the order. Like I said, later we were able to get successfull script.

I am just wondering...

or check this :

create table  MyTime (mytime datetime)

insert into mytime

values('12:25:35') ---and couple more values in the same format

select * from MyTime

declare @X int

set @x = (select sum(datediff(ss,'0:0:0',mytime)) from mytime)

select...

I tried this:

create table MyTime (mytime varchar(8))

insert into mytime

values('11:15:42')

select sum(datediff(ss,'0:0:0',mytime.mytime)) as seconds

from mytime

and that did not work. I found problems to convert to datetime from char or varchar, can...

Is the transaction backup coming from the maintenance plan job? there is the option "Backup file extension",  I have TRN, maybe you have IDF, check there.

Hi,

try to play with output, when you are running from QA this

create table Output(text varchar (100))

insert into Output

exec xp_cmdshell 'osql -S -dTEST_dev -i"D:\Data_load\TestScript.txt" -E'

if exists(select * from Output where...

Hi,

I have in our maintenance plan :

Check integrity first and it says "perform these tests before making backup", so I am thinking this plan is checking everything first.

You can do...

one more - before back to FULL I am shrinking db, just to save some space