Author: Magnus

After setting up an aspx page that accepts IPN postings from PayPal on my domain, I got this error when trying to post IPN data:

The remote server returned an error: (999) No Hacking

Well, I didn’t have this problem with my previous hosting company, nor when trying on my local IIS web site. So I contacted Webhost4Life, on their live chat support. That didn’t help much. But I finally found the solution.

It turns out that Webhost4Life has a functionality called Security Guard. Turning this off for my sub domain did the trick.

You will find the Security Guard in your Control Panel, Security section.

I have been struggling with this for a couple of hours now. Now matter what options I set in the Microsoft SQL Server 2005 Import and Export Wizard, I cannot manage it to correctly transfer my identity columns.

It turns out that this is a bug in SQL Server 2005. There are a couple of proclaimed workarounds like this and this. However that didn’t work for me. I cannot uncheck the “Optimize for Many Tables”, because if I do, I get a lot of other key errors when the package runs.

So I stumbled upon this utility, the Simple SQL Bulk Copy.

It worked great! My tables containing identity columns was transferred correctly.

Maybe you have been in the same situation as I ? You need to bulk export multiple tables from SQL Server, and can’t find any option in the Import and Export Wizard within SQL Server 2005. At least I couldn’t find any out of the box functionality to do this. So I went ahead and wrote a small T-SQL script that uses the BCP command utility to perform this desired task.

SET NOCOUNT ON DECLARE @cmd NVARCHAR(2048) DECLARE @tableName NVARCHAR(2048) DECLARE @outPath NVARCHAR(2048) SET @outPath = ‘c:\temp\‘ DECLARE tableCursor CURSOR FOR SELECT [name] FROM sysobjects WHERE type=‘U‘ FOR READ ONLY OPEN tableCursor FETCH NEXT FROM tableCursor INTO @tableName; WHILE @@FETCH_STATUS = 0 BEGIN SET @cmd = ‘bcp [‘ + db_name() + ‘]..‘ + @tableName + ‘ out ‘ + 
      @outPath + @tableName + ‘.txt -t”,” -T -c -S‘ + @@servername PRINT @cmd EXEC master..xp_cmdshell @cmd, NO_OUTPUT FETCH NEXT FROM tableCursor INTO @tableName; END; CLOSE tableCursor; DEALLOCATE tableCursor; 

If you try to run this on a SQL Server 2005, you may encounter this error:

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’ because this component
is turned off as part of the security configuration for this server.
A system administrator can enable the use of ‘xp_cmdshell’ by using sp_configure.
For more information about enabling ‘xp_cmdshell’, see “Surface Area Configuration” in SQL Server Books Online.

In that case you have to unlock the possibility to execute xp_cmdshell usi
ng this script:

sp_configure ‘show advanced options‘, 1 GO RECONFIGURE GO sp_configure ‘xp_cmdshell‘, 1 GO RECONFIGURE GO