Thank you Jack.

That's what I thought.

I decided to do my own investigation.

I created a Common2 database on SQL 2000 box.

1.

On this box on Server level I created SQL Login "yegorov"

without any mapping to databases.

SQL Server...

Actually I did a test.

I tried to create SQL Login "NewGuy"

and got error:

Error 15007: the Login "NewGuy" does not exist.

So first, one has to create a Login on a Server...

Hi Utsab,

Both old and new servers are on the same DOMAIN.

You wrote

Does it mean I...

Anjan,

So in your opinion you need to do some manual stuff

after Restore, like create a Role, for example, and add Login to this Role.

Basically it means sp_revlogin is not enough....

I installed new SQL 2005.

It's empty. No databases.

I want to bring over to this 2005 server all 2000 stuff.

Actually it looks like Restore created all Logins/Roles correctly in 2005.

I tested...

The issue has been resolved.

Apparently we were running Import process still in FULL INITIAL LOAD mode.

Clients table had 243,000 records and SQL code (I still don't like but I don't...

There was some offending transaction hanging.

Apparently it was DTSDesigner, LastBatch: today at 6:07 AM

SPID: 54. I killed it and Current Activity can be accessed now.

It actually was causing more problems...

Guys,

my debugging prints get buffered a lot.

Is there any way to flush them?

Hi Jeff,

First of all it's not my code.

I would never code like this.

It's a third party software we're using and

the vendor keeps telling us "it's your environment problems. tempdb size,

not...

Code is below.

Job slows down at

"Clients...Start-Batch Updates" point, CPU spikes to 100%,

after 11 hours it finally moves further and the job finishes.

CREATE ...

Actually the story continues.

Now one of next steps of that SQL Job (SSIS package) fails

with the same error

[Execute SQL Task] Error: Executing the query "insert vsImport.dbo.Import_log(message,[Table],[time]) values('Niad.dtsx started','Dundee-Custom-Entry',getdate())" failed with...

The issue is fixed.

I changed Default database

for "niadetl" SQL Server Login on Box 2 which is used to register Linked Server on Box 1.

Now it's "master".

I don't have any other solution other than add another job step

"Cancell_If_Time_Passed":

It's too many little steps now in the job

and...

Are you suggesting this:

declare @CurrentDt smalldatetime

declare @CurrentDtStr varchar(8)

set @CurrentDt = getdate()

set @CurrentDtStr = CONVERT(VARCHAR,@CurrentDt,112)

WHILE NOT EXISTS

(

...