Stuart Davies (9/21/2009)

---

Hi Silverfox,

I've updated the stats and this reduces the value to be nearer zero but still a lrage negative value.

dbcc sqlperf(logspace) gives :

DB ...

have you updated the usage for this database, I have seen similiar in the past where the stats/usage returned are totally out of sync.

what does dbcc loginfo and dbcc sqlperf(logspace)...

That was an update to the site, to fix duplicate names, the original owner kept the name, everyone else with the same name, had a number added to the end...

Looks ok, is reporting services working ok?

gmamata7 (9/19/2009)

---

Hi,

We have a Separate Dedicated Drive (T:\) for TempDb on SAN. Both tempDb.mdf & tempDblog.ldf are on Drive T:

Is this correct configuration OR still I need to place TemDblog.ldf...

If you right click on the database select properties, look at permissions. you will see the user that you granted the select permission to.

if you click on that user, then...

how did you test it, remember that allocating permissions this way, it will not show correctly in the GUI. but the permissions would have been allocated

Melton (9/20/2009)

---

SQL is not ment to run in that manner. Each edition you installed is fighting for memory on your system and process. There is not real point...

Electrix (9/21/2009)

---

That is the problem with native folder share. When you fail over the folder share and permissions does not carry over to the new node. That is why you...

There are better ways of doing it but

USE [databasename]

GO

GRANT SELECT TO [username]

try that and let me know if that works for you.

Can you post the error and maybe what the job is...

Jeff has a valid point.

How much space is left on the drive that tempdb is on. and what is the size of the tempdb database.

As mentioned before in previous posts.

GRANT EXECUTE...

I would leave it there, it is there for a purpose in case you ever use policies, which is an integral...

shivani.suri2 (9/18/2009)

---

Hi,

I have some queries regarding auditing in SQL Server 2008.

These are:

1. What is the difference between auditing with SQL trace and auditing with SQL Server Audit feature?

2. Are audit...