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
Thanks for your suggestion man, actually what happened here i have 10 million rows in table and i have updated 1 column for all rowswhich is of...
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
we can do it in many ways,
Steps to remove duplicate tables:
Suppose your table name is tblMain....
Separate names with a comma.