GilaMonster (3/2/2012)

---

If it belongs to a database that was detached, the ownership could be solely to the SQL Server process. See if you can take ownership, if you can, see...

Thanks, I figure it out, you are right , it comes with SQL 2008 or later.

Thanks, I am going to migrate to a new server that installs a new instance of SQL server 2008 R2

Is this document also applies to 2008 R2?

Thanks

what is the common practice, if there is a master package and some child package, do you just log the master file, or do you also setup the log file...

I did try it, and see they are not in recycle bin.

But I just want to verify it, sometimes it is good to just delete into recycle bin in case...

Thanks, I will study it.

May come back with more questions.

Thanks, but I am not sure if this is...

This other server that is your report server is different. In that case, you need to make sure you have your reporting services key backed up (can be backed...

Thanks, when you say change the compatiblity, you mean change to 2008 (100) correct?

Also I have another server, which hosts reporting server and its databases, I need to upgrade it...

The job is running a SSIS package.

Is there a way excute ssis in a stored procedure?

Thanks

But we have 3 peoples may take turn to run the job.

And I don't want give them rights to view or run other jobs because this is a production server

Thanks all.

Nicholas Cain (2/16/2012)

---

Here's a real quick way to check space using powershell within a function http://sirsql.net/blog/2010/11/23/quick-powershell-disk-space-check.html.

This can be easily adjusted to load the information into a database for storage, alerting,...

Thanks all

Thanks, I also find this article.

http://www.networkworld.com/community/node/44827