I agree to all the above posts.
Apart from those, also would  like to suggest change the priority of the where clauses (i.e. interchange the conditions put the second...

for sql 2008 onwards, free space on drive + percentage

SELECT distinct(volume_mount_point),

total_bytes/1048576 as Size_in_MB,

available_bytes/1048576 as Free_in_MB,

(select ((available_bytes/1048576* 1.0)/(total_bytes/1048576* 1.0) *100)) as FreePercentage

FROM sys.master_files...

May I know why shrinking is not an option here? Is it because db in simple recovery mode

You may take help of external tools of sql server like PA (Performance Analysis tool) by Dell

Hi,

Is it possible to update stats for a specified date range, like for a month? in SQL Server 2008?

If so, please can you guys share the query..with an example

thanks,

Rinu

Also , SQL server Agent is responsible and take care for all the sql jobs and maintenance plan jobs that occur in the server. So if you have a scheduled...

1) You may have to delete the job and re-create it with small steps and verify its running fine.

2) Check if your SQL Agent is properly configured

3) Check for SPs

I have noticed the most likely issues with linked server performance, relates to

1) network delays

2) IO related waits.

Probably you need to figure out where the issue is occurring, running...

Yes..data reader access will have select permission on the objects of the database.if you like to give only select permission on views then would have to explicitly give the views...

I would suggest you to move the data file of model db to another location(drive), and then start the SQL Services and then try attaching the database. Also check event...

One point could be added, ie the disk space consumption will be more so the cost involement will be higher compared to smaller databases

Think you should be looking at the security options

thanks alot for your replies..

thanks, i will check with the suggestions specified,however, can you tell me if I run a trace can I find out how this is happening, also what options I need...

HanShi (10/6/2008)

---

If the login is originated from your computer and the error is captured every 5 minutes, it could be a scheduled task.

Else I suggest to look with task-manager on...