SQLServerCentral / Discuss Content Posted by Paul Ibison / Article Discussions / Article Discussions by Author

Log Shipping vs. Replication

Paul Ibison — Wed, 09 Jun 2004 14:21:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/pibison

Coping with No Column Names in the SSIS OLEDB Data Source Editor

Paul Ibison — Wed, 27 Feb 2008 00:03:37 GMT

Comments posted to this topic are about the item [B]Coping with No Column Names in the SSIS OLEDB Data Source Editor[/B]

Script that talks to multiple DBs cant be put into a SP

Minnesota - Viking — Thu, 07 Apr 2011 15:39:26 GMT

I have a similar situation. I am running a script against our DW database. The script collects data from 3 different DBs and stores them in temp tables. Joins those temp tables and slects required results. I need to be able to put this script in SSIS to export it to a flat file. And I get the 'No available i/p columns' error. As per your suggested options i tried to put it into a PROC , but was not able to since [code="plain"]a USE database statement is not allowed in a procedure, function or trigger.[/code]How do i fix my problem. Thanks in Advance.

Altering a column on a Replicated Table

Paul Ibison — Wed, 05 Jan 2005 15:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnist

Retain NULL values vs Keep NULLs in SSIS Dataflows - Which To Use?

Paul Ibison — Wed, 13 Feb 2008 00:12:51 GMT

Comments posted to this topic are about the item [B]Retain NULL values vs Keep NULLs in SSIS Dataflows - Which To Use? [/B]

TRANSACTIONAL REPLICATION SQL SERVER 2005 ENTERPRISE

Brian Edward Allen — Thu, 18 Feb 2010 08:54:16 GMT

Disregard Please

Log Shipping

elchuru — Tue, 17 Mar 2009 12:09:52 GMT

Hi,I am new SQL DBA.Can anybody tell me how to bring secondary server online for production, if primary database goes crash/damage, which is participating in log shipping.How do we know log shippping failure occured?Thanks in advanceVijay

How to Short-circuit Where Clauses

Paul Ibison — Sat, 22 Sep 2007 12:41:42 GMT

Comments posted to this topic are about the item [B]How to Short-circuit Where Clauses[/B]

Simple Method for Importing Ragged files

Paul Ibison — Tue, 04 Mar 2008 21:55:27 GMT

Comments posted to this topic are about the item [B]Simple Method for Importing Ragged files [/B]

Receiving the following error when altering a column-- Error Cannot rename column because it is being replicated

Pam Ozer — Mon, 05 May 2008 05:06:54 GMT

I have a table that is replicated in two different publications. I need to rename the columns. I tried removing the tables from the replication and then altering the columns but for some reason the system thinks that the table is still being replicated. I found some documentation on this for Sql server 2000 but not 2005 and the fix for 2000 will not work in 2005. The error I am getting is Cannot alter column because table is part of replication but it isn't. It has something to with the system not dropping some information.Has anyone else had this problem in SQL SErver 2005?

High Availability (DR) Using SQL Server 2005 Transactional Replication

Paul Ibison — Thu, 17 Apr 2008 00:19:18 GMT

Comments posted to this topic are about the item [B]High Availability (DR) Using SQL Server 2005 Transactional Replication[/B]

Transactions in Transactional Replication

Paul Ibison — Thu, 03 Apr 2008 00:09:08 GMT

Comments posted to this topic are about the item [B]Transactions in Transactional Replication[/B]

Dropping all Triggers

Paul Ibison — Sun, 23 Sep 2007 10:55:34 GMT

Comments posted to this topic are about the item [B]Dropping all Triggers[/B]

Merge Replication - Manual Range Handling

Paul Ibison — Wed, 05 Jan 2005 15:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columni

Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0

Paul Ibison — Sun, 28 Oct 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/pibison/bulkinsertworkaround.asp