Just another method>> Why don't you use File System Task to move the file. It is easier that way. Also, what Are you trying to do with the file? Read...

Did you fin d a way to solve this yet. I am migrating next week and I am trying to keep out of any problems. Your knowlege and/fix of this...

Thanks a bunch! That did help a lot in fact. Good Whitepaper.....

Thanks again. I will deeply look into what you have stated and do some thinking here. At the same time, I do respect your views. I will try my best...

Millions of thanks to you Micheal. But I am also wondering what will happen if something goes wrong? How and what are the practices I should take to roll back?...

Also, any specific advise on configuring both filegroupd and partition? I read many articles but often get confused about what are the steps to watch out for??

Thought of the same thing too. Thanks a bunch! But one thing though, will there be any other problem when doing the detach/attach process (I am definately backing up the...

Thanks Buddy! I am gonna try it out. Hopefully it works!

I see what you are saying, but I think my view is proper in that case right? Do you think? Any better way to accomplish synchronization between both table and...

Here is the modified code:

CREATE VIEW [dbo].[AAA] with SCHEMABINDING as

SELECT

I.ID as ID,

I.RootID as RootID,

BI.Age as Age,

I.Sub as Sub,

I.Usage as Usage,

I.Report as Report,

LI.Location as Location,

SL.SubLocation as SubLocation,

from...

Guys..... I know it would be easier to just give away the code. But it is the company policy that I should not. Let me try to modify somethings and...

Thank you everybody above. Thanks a bunch guys for the quick help!

Yap. That's what I thought. But what about dedication of the CPU's What do you think? These people here are planning on spending real big money for this one. I...

Quad Core 4X2

16GB RAM

300 GB Hard Drive (8)

RAID 5

Okay, after that, I have to delete data that is more than 12 months from today. whatever is older than a year today have to be deleted. How do I...