Last fleeting thought. I might explore replication. My initial and brief research indicates that filtered replication may be possible. If this is correct it may be easier than writing the...

Sorry I responded too quickly and my suggestion won't help since you need to purge the primary.

I have seen commercial applications that archive data into a separate but identically structured...

Can you restore a backup to your reporting server?

pietlinden (9/25/2013)

---

One option might be to use Access (shudder, I know) to create a linked table that only links to the data you want and then export that back to...

http://sqlmag.com/sql-server-reporting-services/ssrs-how-create-reports-user-protect-sensitive-data

There seems to be some important security considerations here.

I would attempt to pass the userid as a parameter to a stored procedure and NULL the column there rather...

http://www.mssqltips.com/sqlservertip/1084/dynamic-flat-file-connections-in-sql-server-integration-services/

Try this and let us know if you run into any issues.

What is the relationship? Can a customer have multiple accounts or can an account have multiple customers.

>> I am also assuming that it is trying to insert ALL of the...

>>Are there any potential problems I might face when upgrading the OS of an existing SQL Server install?

Quick update in case anyone comes across this in the future.

The integration services...

I would use the HTTP Connection Manager to import the file into a staging table.

http://technet.microsoft.com/en-us/library/ms137602.aspx

After this I would write a TSQL statement using the MERGE statement and either...

The advantages would be quasi-instantaneous notification and you would eliminate the possibility that the error would prevent some...

You would have to put the TRY/CATCH after each...

CREATE TABLE [dbo].[#Logs](

[Message] [varchar](300) NOT NULL,

[MessageType] [varchar](14) NOT NULL,

[Action] [varchar](120) NOT NULL,

[CallingProcedure] [varchar](50) NOT NULL,

[SuccessFlag] [char](1) NOT NULL,

[ErrorNumber] [int] NULL,

[ErrorSeverity] [int] NULL,

[ErrorState] [int] NULL,

[ErrorProcedure] [varchar](126) NULL,

[ErrorLine] [int] NULL,

[ErrorMessage] [varchar](4000) NULL,

[DateTimeStamp]...

And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50 different SQL statements and...

Thanks. I see now, the CONVERT does it all.

I haven't thought about or looked at this code in many years....but maybe it will help you. The parameters are in cells B2 and D2.

Private Sub CommandButton1_Click()

...