By Javier Callico on 1/27/2009 12:00 AM

Today I needed to delete all foreign key contrains in a SQL 2005 database in order to be able to sync it using the Visual Studio Data Compare Tool. I found a script doing almost what I needed but after running it I noticed that it also dropped indexes and defaults in all the schemas. I made some changes to accomplish the following:

1- Drop foreign key contrains only.

2- Filter by schema.

3- Don't execute the drop statements automatically just print them.

Read More »

By Javier Callico on 1/8/2008 12:00 AM

These are the steps that worked for me:

1. Uncommented the line "extension=php_curl.dll" in php.ini file.
2. Copied libeay32.dll and ssleay32.dll to C:\WINDOWS\system32. 

Note that these two dlls can be found on the PHP folder under the dlls folder. Adding this folder to the Windows PATH variable should also work.

You can use this simple test script - which retrieves and displays yahoo.com homepage - to verify that CURL is now working:

<?php
$ch = curl_init("http://www.yahoo.com/");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_exec($ch);
curl_close($ch);
?>