It's clear about CLUSTERED index.

But I's still confused about "covering index".

Let's go back to my scenario.

BAP_PROD_2006.dbo.cust_agrmnt_dim.CUST_AGRMNT_NUM

is now has an index

Is this enough for this particular BAP_PROD_2006.dbo.cust_agrmnt_dim table

or I need...

Sorry GSquared,

Are you suggesting to have CLUSTERED not NONCLUSTERED index

on the same columns I did? Or use a different column?

And what is "covering index" ?

How do you do that?

Oops!

Actually the second run took only 6 sec.

So it probably built an execution plan and now it's faster.

So I'll try to add indexes to

all BAP_PROD_2006 tables and see what...

Gail,

Once again, Thank you so much !

I like to have scripts for every action.

Is it:

alter database [BAP_PROD_2006] set offline

alter database [BAP_PROD_2006] set online

How do you take the database offline?

Is it detaching?

I tried to start a couple of time from Surface Area Configuration

and on second attempt it started.

BAP_PROD_2006 is back!

Thank you so much! I owe you lunch... 🙂

Gail,

How can I rename...

I looked at the EERORLOG and there is a whole bunch of network issues.

2008-08-08 10:05:17.72 Server (c) 2005 Microsoft Corporation.

2008-08-08 10:05:17.72 Server ...

Here is what I did.

I shut down the service.

I moved "BAP_PROD_2006_Log.LDF"

to

H:\Microsoft SQL Server\MSSQL\Data

and renamed it to

"FG_Lof.ndf"

The name is wrong but it's probably too late to change it now.

This was the...

I'll try this now.

Thank you.

Currently they run them manually.

They open SSIS in Development Studio and execute it.

So if BUILTIN\Administrators does not exist in SQL Server 2005

(they probably removed it)

it means your Windows Admin is not SQL sysadmin anymore?

But if you are Administrator on Windows box and...

Guys,

Time is not in sync on two servers.

That's why.

We should not use code like

"...INSERT Import_Log(time) VALUES(getdate())..."

because we're running job steps on different servers.

Import_Log should have:

( [time] [datetime] DEFAULT getdate()...

Guys,

Actually what I suggested before is not good.

It will create SQL Login on 2005 but the way I

implement this is not good.

The drawback is that using this option you...

I figured it out.

My Step 5 should be:

and it fixes a link between SQL Login "yegorov" and User "yegorov".

(updates SID)

So to summarize.

After restoring database "Common2"...