Author Archives: uday arumilli

Truncate Table with Foreign Key constraint

Truncate Table with Foreign Key constraint This post helps you in automating the process of Truncate Table with Foreign Key constraint”. We recently working for a client on data migration project. There was a requirement for truncating tables. But we … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , | 1 Comment

How to Truncate only the Selected Tables from Database

How to Truncate only the Selected Tables from Database How to Truncate only the Selected Tables from Database? This stored procedure helps you out in truncating the selected tables. These tables has to be passed as a string parameter to … Continue reading

Posted in SQL Scripts | Tagged , , , , | Leave a comment

How to rebuild Master Database in SQL Server

How to rebuild Master Database in SQL Server We recently resolved a request from a client that he is not able to access a SQL machine. We have logged into the sql box and we cam to know that the … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , | Leave a comment