The message is in both the windows event log & sql log.  We are using the NTBackup.exe and it is doing purely a windows backup.  A scheduled task fires a...

On our server, we mirrored the c drive.  On the external array, we went with Raid 10.  It seemed to give us better performance over the Raid 5 configuration.

HTH

John

It's normal.  The current activity window will show all current SQL Server connections.  So even though your application may be done running the query, it sounds like it still has...

Best practice says that the sql server service account should be a local administrator on the server.  That should give the login all the permissions it needs.  I don't believe...

So any object that is created by anyone within a database will have the same windows group owner?  Doesn't that mean that anyone within the group can then alter any...

Actually, that is exactly what I was planning on doing.  Now that I look at my post, I may have said otherwise.  I will be creating roles and then assigning...

Thanks for the suggestions guys!  And thanks for the links Brian.  I have a lot of reading to do.

John

I did try what you suggested.  I determined that the user had granted permissions to a table for the public role.  I then tried revoking the permissions as dbo but it...

I am not sure what was going on but I got a workaround.  I ended up copying the table and renaming it.  I then dropped the table, renamed the new...

It is also missing a closing ) on the first create table statement.  When I ran this code, it returned:

Server: Msg 170, Level 15, State 1, Line 11

Line 11:...

So do we but it didn't seem to be working correctly.  This way we know for sure that it is going to happen.

John

It seems that we have found the reason for the deletes to take so long.  The statistics were not up to date.  As soon as we updated the statistics, the...

We are using the Microsoft Business Intelligence Portal tool as a front end to our OLAP cubes.  It is a free downloadable tool from Microsoft.  It allows you to view...

Gary,

I tried what you suggested and no luck.  There is a primary key constraint that references the clustered index.  I am not sure if dropping the clustered index would make...

Can you deny permissions to the dbo of a database?  If you did, as dbo he could go back in and change the permission so he has the access he...