No , this is same but i also tried to changes user name like

i rename DB\XXX with BK but still select suser_name() gives DB\XXX

What i got from other posts and your query is,...

Here DB stands for "DOMAIN" and XXX stands for my profile name . is there any chance that

login and user can be different ?

If we are backing up the TLog.

Will it reclaim the space ?

cant we use DBCC shrinkfile option to regain the space ?

Read below posts

http://www.akadia.com/services/sqlsrv_logins_and_users.html

http://www.sqlservercentral.com/articles/Administration/beginningsqlserverloginsandusers/1460/

my guess is you are not getting

Db_size corectly as i think ramesh's query will return same size for both max and min.right ?

can u provide some sample data ?...

declare @sql nvarchar (200), @col varchar (100)

set @col = 'acct_id'

SET @SQL = 'SELECT acct_num FROM account where ' + @COL + ' = 1000'

print @SQL

EXEC(@SQL)

see above example...

can you elaborate min and max ?

First , Are you using sql 2008 ?

and second thing ( blind guess) use sa(administrator) account to run it

Why you want to skip empty file

i dont think there is any point to keep them ?

the error posted by you bascially general info , we get in may job failure

post the complete error and what you are trying to do in that...

try sp_readerrorlog

Tell me what you are doing in that plan

have you migrated it from other location ?

Find eBooks Here

http://www.red-gate.com/about/book_store/index.htm

Try this

declare @tbl table ( logdate datetime, processinfo nvarchar(20), login_text nvarchar(max))

insert into @tbl (logdate, processinfo, login_text)

exec sp_readerrorlog

select * , '[' + SUBSTRING( login_text , PATINDEX ( '%CLIENT:%', login_text)+7,...