cold cloning means, cloning teh server with a bootable disc

so there is no OS nor database running while the cloning is in progress,

Once completed, this will make a Virtual machine...

Ann Cao (11/22/2010)

---

Thank you, that's what I think too.

I will do the restore for user databases, then script out the logins and jobs.

The other difference for both the server, is...

Hi Dave,

I have tested it on the actual data thats in our table,

It Contains approx. 110.000 records,

With an increase of approx. 10.000 a year

i have also created an test index...

Hi Dave,

Thx a lot for the link, it was just what i needed.,

Amazing how you guys can come up that quickly with the right link for a certain problem.

I did...

Hi Paul,

Seems idd like a verry clever idea.

Gonna save this post for later use, could come in handy.

Ps: didn't you miss deleting the triggers also once the view isn't needed...

Tnx Gila,

If exist ( Select confirmation from expert)

Do not rewrite you procedurs

else

AI AI AI

You made my day

Didnt know that about the select * vs...

Hi hunterwoord,

Are you sure thats the way SQLServer works.?

Cause i was thinking that when one was testing with IF EXISTS this would just be a logical question and that Sqlsvr...

No, impossible, cause lowercase 'mm' will give you minutes in stead of months

its just the mm that would have to be in...

tnx Mark

This idd did the trick 🙂

Seems to me that this puzzle has been solved.

tnx a lot,

Wkr,

Eddy

Hi Mark,

Actually i should need to detect wheter there is some kinda overlap,

If it is (true/false) then i can not proceed with the calculation but give some message back to...

Mark,

THANK YOU VERRY VERRY MUCH!

This returns the correct numbers,

I have manualy checked every record in the provided detail and calculated myself first then referenced to the results and they match...

Hi Mark,

When i try your code with real production data it seems not to be correct

When i see Activity DAT_ID:2 fields: DAT_BEGIN_DATE & DAT_END_DATE

i see that the driver was in...

Hi Mark,

Tnx for your help,

The provided code seems to do the trick, for witch i send you a lot of thanks,

I'm really not strong when dates come into play.

The code...

Hi,

I'm having kinda same issue, but different though 🙂

fist i got SSMS 2005 installed and everything worked fine,

Then i installed SSMS2008 so i could make some tests on our...

Or maybe they are using something like:

C.Name CONTAINS ....

wkr,

Eddy