If you want a faster response to your questions, you can try Brent Ozar recommendation, check http://www.brentozar.com/archive/2009/12/i-need-sqlhelp/

Hi Krasavita,

If you are using sql 2005 or higher, you wil be able to see the space used by the transaction log. You can check it by using the disk...

Could you please be more specific. What do you want the package to do?

select 'EXEC xp_cmdshell '+'''Net Send '+rtrim(hostname)+' Please logoff from the system-Starting Sys. maitenance--DBA''' from sysprocesses

where db_name(dbid)='DatabaseNAME' group by hostname

--Execute Output of above command for e.g. EXEC xp_cmdshell 'Net Send...

Could you please be more specific.

I have not noticed. And I have been checking the forum quite often.

SQL 2000 has DTS. Which provide some functionality. So what do you want to do?

Great. Thank you!

Installing an instance of SSIS 2005 on the server where you are running SQL 2000. That means you need a license.

Jason, do you by any chanced know some links where I could find some more info about mandatory controls for SOX. Thank you in advance.

It's a pitty you did not share your issue and the solution. Others may benefit from it.

It is a risk to give db_owner permissions to a user. check this link: http://technet.microsoft.com/en-us/library/cc966507.aspx.

Instant file initialization maybe useful, check this link for more information.

Are you using SQL Server 2005 performance Dashboard?

You can set autogrowth to a specific size and depending on the database grow you may want to add extra files on the same filegroup but on a different...