Posts

Showing posts from February, 2012

For disabling all the constrains (foreign keys) of a Database

use this command to disable all the constraints: EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' and after deletion or any operation on database set the constraints in by this command EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
Post a Comment
Read more

Displaying report name or anything only at the last page of report.

For displaying report name or anything only at the last page of report. then click on the text box, go to the properties panel at the rite side. there is an option of " Hidden ". write this expression in the hidden values expression is :  =IIF(Globals!TotalPages=Globals!PageNumber,False,True)
Post a Comment
Read more

Reseed the identity of database table

For setting the identity column of a table of database to 1 again then use the following command: DBCC CHECKIDENT ( TableName )
Post a Comment
Read more