Hi,My table has 100 records, i want to truncate that, so i used truncate table Tablename, but it gives me error Cannot truncate table 'XYZ' because...
I have 185 mdb files, i want to transfer all these at once in database, how can i do it,if anyone have any code for this, please help me
Hi,How can i find out login information from server, who logged when?can i restrict the access of database from users?
if i shrink sql server 2005 database, will it affect on indexes.
Hi,how can i found particular table's column has index or not
Separate names with a comma.