I had a requirement today to delete all data from a sqlser ver database. This database has about 350 tables with a lot constraints. I manually started identifying the order of deletion absed on the constraints and realsied that this can't be done in a day. So I hit the good old google for help.
Here I found a very detailed explanation of how to easily achieve this by Susan Sales Harkins. Read More
Subscribe to:
Post Comments (Atom)
Rerunning a SSRS subscription report
Yesterday I had a situation where a couple of SSRS reports failed due to a network upgrade. The SSRS report was not able to access the SQ...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
-
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
No comments:
Post a Comment