@Gila

Then why this code be executed successfully.

IF 1 <> 1

BEGIN

BACKUP DATABASE tempdb TO DISK ='D:\tempdb.bak'

END

SELECT MAX(CAST(SUBSTRING(bookid,3, LEN(bookid)) AS INT)) from tablename

First thing which is already mentioned that, its not working properly as it dealing FK as PK too, and second thing, what if, i have more then one filegroups ???

http://connectsql.blogspot.com/2009/07/how-to-install-sql-server-management.html