Thanks Anthony, I got your point. I was just worried because I was not taking any log backup of Database1 on reporting server, still it was showing in backupset. ...

Thanks Jan,

I had a same issue. It is working fine with your solution.

Thanks Chris, I had a same issue. It is resolved with your solution.

Use below script to generate drop script.

SELECT 'DROP TABLE [dbo].[' + name + ']' FROM sys.objects WHERE type='U' and schema_id = 1

-- replace dbo with your owner/schema name...

One possible alternative could be

SELECT TABLE1.* FROM TABLE1

INNER JOIN (

SELECT TABLE2.COLUMN1

FROM ( SELECT MAX(TABLE2.COLUMN2) AS [Key] FROM TABLE2

--WITH (NOLOCK)

GROUP BY TABLE2.COLUMN3 ) AS A,

TABLE2

--WITH...

Use TRUNCATE TABLE

User TRUNCATE TABLE

Thankx guys.

I have got one interesting video on this. It worth viewing for lookpup tables manipulation. Find the video at below link

http://www.sqlbits.com/Agenda/event3/Small_Problem_-_Simple_Solution__Lookup_Tables/default.aspx

Thanks..

But it is not even working after changing the compatibility mode.

This domain users are valid one. I am doing this on development server not on production. Assiging the SQL user has resolved the problem...

I think this becase ALTER TABEL.

Database storage for TEXT and VARCHAR(MAX) are different (for TEXT it is LOB and pointer in table structure and for VARCHAR(MAX) it is table...

I guess it is the problem with values inside [col] column. Some how it is exceeding the INT size limit. Please make sure [col] is INT not BIGINT.

Another solution is

SELECT TOP 1 * FROM MyTable

WHERE statut < (SELECT MAX(statut) FROM MyTable)

ORDER BY statut DESC

I my view dm view gives the result based on the database usage. So if you execute some query on adhoc basis for many time, then also it creates entry...