Check the Login failure error from sql error log and identify the status there after.

This may help

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

I have checked the execution plan and it seems to be decent, using the index seeks on other two indexes other than the ones we rebuild for it. the percentage...

Typo at last corrected.

I would like to set a policy for backup process that database backups( any type, FULL/LOG/DIFFERENTIAL) should only be triggered by DBA group and not by any...

This script takes backup file path from backupmediafamily table and tries to restores backup to db db_toberestored with out validating the existence of backup file.

declare @path varchar(250),@dbtype varchar(5),@dbname varchar(20)...

hope this thread is relavent to the your error

http://support.microsoft.com/default.aspx?scid=kb;en-us;322140

When you are able to grant permission, Am sure definitely the users part of developer would have db_owner privileges.

I think there is limitation for the objects created under dbo schema...

No because for other login login2 I could see successful logins then after and still it display bad password count as 5.

You could refer sys.database_files or sysfiles.

for current db(2000):

select RTRIM(CONVERT(VARCHAR(50),sf.name)) [filname],

[filesize]=(sf.size/128),

[maxsize]=(sf.maxsize/128),

fileproperty(sf.name,'SpaceUsed')/128 AS SpaceusedMB

,(fileproperty(sf.name,'SpaceUsed')*100)/(sf .size) as PercernUtilization

from sysfiles sf

for current db(2005,2008):

select RTRIM(CONVERT(VARCHAR(50),sf.name)) [filename],

[filesize]=(sf.size/128),

[maxsizeMB]=(sf.max_size/128),

fileproperty(sf.name,'SpaceUsed')/128 AS SpaceusedMB

,(fileproperty(sf.name,'SpaceUsed')*100)/(sf .size) as PercernUtilization

from sys.database_files sf

for all dbs...

you can use loginproperty in sql 2008.

http://msdn.microsoft.com/en-us/library/ms345412(v=SQL.100).aspx

select loginproperty('sunsql','DaysUntilExpiration') as Daysexpiration

select loginproperty('sunsql','badpasswordtime') as badtime

select loginproperty('sunsql','badpasswordcount') as badcount

select loginproperty('sunsql','PasswordLastSetTime') as PasswordLastSetTime;

there is alimitations here -> will be used only for...

[font="Verdana"][font="Verdana"][font="Verdana"] Can you check where are the two users running reports from? I suspect it would be from their desktops.

And user name xxxx\xxxx some times could be local system account...