Yes, Enterprise endition of SQL Server 2005 supports task scheduling.

Except Express edition, all other editions support this.

Suresh

Don't work hard, work smart.

Try PerfMon

Suresh

Hi Chirag,

Run following query and see what is already exising.

select * from sys.objects where [name] = 'PositionInsert_sp'

It is not SP that is already exising. It could be a table, ....

Suresh

Thanks Gail Shaw,

The value of Readahead Pages/Sec is going above 2,000.

There are 50 DBs of different size. Max 30 GB

Not very active in the night. During non business hours also...

What is the filename extention of your backup files? Manitenance plan cleanup task deletes only .BAK/.TRN files.

Workaround is use FORFILES.EXE. Create a .BAT file and schedule it.

How do you backup without affecting the maintenance plan?

Schemabinding does not enhance UDF's performance.

It will make sure that the columns refered in the UDF/view are not dropped.

You can do this using Access.

Create ODBC linked table and queries.

TRUNCATE command

is the fastest way to delete ALL the rows from a TABLE, without filling up the transaction log.

1) Use DBCC CHECKTABLE to check the health of the table.

2) Use DBCC SHOWCONTIG to check the index fragmentation.

You can certainly write a scipt and schedule it.

MSDB database has details of all the backups done.

Check the following tables:

select * from msdb.dbo.backupfile

select * from msdb.dbo.backupset

select * from msdb.dbo.backupmediaset

select...

Also use

1) Query Execution Plan

2) SET STATISTICS IO/TIME ON/OFF

Right click on the publication you have created, select Properties, click Articles,

clear the check box "Show only selected objects in the list"

then select the table that you want to...

Use Notify Operator Task.

Did the Maintenace Plan run?

Check the history.

Have you mentioned the correct file path and extention.

Check how many days are there (default is weeks)

It should work.

It is very simple...