Jeff the funniest thing is this table does not have any indexes on it.. Nor does it have a primary key... Having no indexes makes the queries run slowly...

This...

The table is 135 GB in size. There are 5 columns all of which have datatype int and varchar(15).

I would keep George's suggestion as an option (Inserting into a...

Yes.. Tried that but it returns the following message...

Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

There are no matching rows on which to report.

Correct me if...

Let me put it this way.. I have a table abc and I need to know the groups/users who can access the table abc...

Like mascot said a Log file size of 4 GB is acceptable for a 133 GB database. I believe the issues you are facing is the updates/inserts are taking longer...

The table access in a database can give you an idea when your database was last used. Make sure the server has not been restarted recently.

/*

When was my table last accessed ??

Note: If SQL Server is restarted, the information from DMV's is reset.

*/

--For all DB's in Server

CREATE TABLE #USEDDB

(

dbname varchar(50),

[object_name] varchar(50),

user_seeks int,

user_scans int,

user_lookups int,

user_updates int,

last_user_seek...

Check if the user you are using is an Orpahaned user ?

sp_change_users_login 'report'

Hi Eswin,

Here is a query to collect details of all tables, their data/index space usage and % space they occupy in a database. Check out if this can be of...

Could you give us some more information...

There can be many reasons why the maintenance plan has failed with the error msg that you have given...

Configuring Database Mail is very straight forward.

Check out this link http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/[/url]

You need to get the smtp server details from your administrator. Make sure no firewall issues exist and you...

Copy the files to the server on which you are trying to restore - it's the recommended way.

If you try to restore it from a shared location you can...

You can collect the information you want(Uptime, Errorlogs, Diskspace, Db Status, Db Size etc..) from every server and put it into a centralized server using Integration service or even VBScript...

Once...

I've seen Reporting service come under Drive:\Microsoft SQL Server\MSSQL.3\Reporting Services

on more than one ocassion...

Folders LogFiles, ReportManager, ReportServer and RSTempFiles comes under this...

I believe when you install SQL Server and...

As you are backing up to a network drive make sure the user running the backup job has the required permissions on the network drive.. If this Job has been...