iqtedar (11/11/2008)

---

i did check that..it mostly talks about using performance dashboard rpt..i would like to know how to calcultae buffer cache hit ratio using dashboard and also to calculate pages/sec...

The 1 stands for the option to delete files in subfolders and was introduced in SP1. Since you're on RTM it doesn't work using subfolders but as long as your...

Try this:

SELECT j.name AS JobName,

SUBSTRING(CONVERT(CHAR(8),next_run_date),7,2) + '-'+

SUBSTRING(CONVERT(CHAR(8),next_run_date),5,2) + '-' +

SUBSTRING(CONVERT(CHAR(8),next_run_date),1,4)+ ' ' +

SUBSTRING(RIGHT('000000' + CONVERT(VARCHAR(6),next_run_time),6),1,2) + ':'+

SUBSTRING(RIGHT('000000' + CONVERT(VARCHAR(6),next_run_time),6),3,2) + ':' +

SUBSTRING(RIGHT('000000' + CONVERT(VARCHAR(6),next_run_time),6),5,2)

AS NextRun

FROM

...

Did you check that the file exists at that location ?

If somebody moved or deleted the file while SQL Server was stopped, you will get this error.

You should use the ISNULL function to replace NULL values with an empty string.

Select status + ' - ' ISNULL(remarks,'')

First thing you should try to find out is which query\process is causing the growth. Most likely some process which stores a lot of data in temporary tables g.e. a...

Sorry, no answer here either, only want to comment on David's suggestion. David if you recover the beackup on 2008 so that the version upgrade succeeds and when take another...

In SQL 2005, I would advise to use the DMV's sys.dm_exec_connections and sys.dm_exec_requests. The first will give you all user connections, while the second will show only the active connections.

Here...

Barry,

you must...

MS offers a performance dashboard report collection here.

While it might not be exactly what you're looking for I think you can get some usefull ideas for your own reports by...

Openmanagemt studio and make a object browser connection to your server.

The right-click on the server name and select properties.

Go to the page Database Settings and there you will see the...

I'm not 100% sure, but I would think that the default values are read from the configuration of the SQL Server instance. Each instance has a default location for data...

Jpotucek (11/10/2008)

---

My problem is, I cannot drop the users from my 2005 DB because I get this errror:

Msg 15138, Level 16, State 1, Line 3

The database principal owns a...

It sounds like you tried to add a group to a database, without first creating a login for the group.

Since it's possible in SQL 2005 to create databases users...

Instead of deny INSERT/UPDATE/DELETE revoke those permissions. So the users which have been granted those right either individually or through some other group will be able to insert/update/delete, but those...