Thanks Mani,

It will copy only one ssis package at a time. What if I have 100 SSISI package. Can I move MSDB database to another server to copy all the...

They are sql 2005 partitioned views

Wow, Wierd. When I open SSIS package on other machine , and double cliick on Maintenance Cleanup Task and there is one additional check box called :Include first level subfolders...

Thanks for your comments,

Actually, I created a SQL Login account on remote server and mapped that to local account on the local server under Linked Server Properties and is working...

Thanks a lot.

This script looks great. I wil create a job and run on Saturday and Sunday to catch the process which fills the transaction log to 90 GB in...

Does the recovery process fills the transaction log. ?

and also is there a gurantee that database will be in a perfect shape. the reason I am asking if we stop...

I am able to extract data from XML files using SSIS package through XML Source component. It looks ok but there is little problem about datatype. Default datatype for one...

Here is the XML file. How can I use insert statement to parse into column

-

...

I new to xml. Here is my xml file. How can I use your insert function to parse into columns.

-

...

Thanks a lot but how to parse into columns.

The wired thing is when I use my desktop to run distributed query gives me an error but when I use remote link server to run the query works fine...

Thanks guys,

I am able to shrink the log files now after stopping SQL Server Services.

I don't have backup becuase of the development server and also the files are huge and cannot take backups.

After deleting the file, I detached the database and now cannot attached...

No. I deleted the file after stopping sql server service. I physically delete the file from the folder.

File is deleted and have no backups.