Thanks Markus for the script and the tool.

When I ran the script and the tool for a role in my DB it just showed me the GRANT EXECUTE & GRANT...

Thanks everyone.

I used the SP mentioned in this article: How to send e-mail without using SQL Mail in SQL Server.

I created an SP that checks sysjobhistory and sysjobs...

Thank you all.

The problem was resolved by adding an SPN for the account under which the MSSQLServer service was running. Following command was used:

setspn -A MSSQLSvc/<ServerName>.<domain>:1433  <AccountName>

Thanks,

RSingh

SQLServerToolKit is an amazing tool. Toad for SQL Server is also a useful tool. Thanks a million David for sharing these tools.

RSingh

Sorry Steve.

I posted in SQL 2000 admin forum first. Upon realizing that this is a thread related to SQL Server 2005, i posted here.

Thanks for the reply in the other...

Thanks everyone.

Cary - You are also absolutely right. The log backups of the database had not been taken since long. A subsequent log backup after the first one was quite...

Thanks to everyone who replied.

Actually I was mislead by the following statement:

"Full Backup

The full backup does just that – it backs up all the data in the database. Every table,...

Dear Sanjay,

.gz is a zip format and thus will not be recognised by SQL Server. You will have to first unzip the file using gzip or gunzip utilities and get...

You can filter your results by DatabaseID or DatabaseName.

I prefer filtering by DatabaseID (DatabaseID equals <YourDatabaseID> rather than DatabaseName since I have noticed that sometimes SQL Server doesn't filter by...

Congratulations on achieving the 400k mark.

I wish and hope that SSC will be reaching 500k mark sooner than it reached 400k from 300k.

Kudos to the hard work put in by...

Thanks Lowell for the reply.

When I ran your query it returned 0 rows.

But I modified it a little and it helped me:

select sysobjects.name as TableName,

      s.groupname as Data_located_on_filegroup

   from...

YES.

Since you are using 32-bit SQL Server you still need to enable AWE. You can do away with enabling AWE only if you are using 64-bit SQL Server.

On Windows Server...

Thanks Yelena for the reply.

But i forgot to mention that i had alread tried the following:

Thanks everyone for the reply.

Here is some additional information in this scenario:

1. The recovery model of the DB is set to SIMPLE.

2. The table in question doesn't have any Primary...

Mike,

Thanks for the reply.

The count of rows for >= '20050501' is again 75 million.

Wouldn't it be again time consuming to Select so many rows into another table and then creating...