Hello,

If you are not getting any errors then …. on a data load process that I recently worked on, the Import SPs logged their completion to a Central Table. If...

Hello,

You could try replacing the Right Function with the following:-

substring(firstname, CharIndex(' ', firstname)+1, 200)

Note that this code assumes a first name is never longer than 200 characters.

Regards,

John Marsh

Hello again,

Did you try setting up a Mapped Login when creating the Linked Server?

Also do you get any Login Errors reported in the SQL Server Logs on the Branch...

Hello again,

Did you manage to get the query working Okay, or are you still having problems?

Regards,

John Marsh

Hello,

May be take a look at this MS Article:-

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

Regards,

John Marsh

Hello,

Just to check a couple of things:-

- Are you experiencing this issue when trying to create a Linked Server to your Branch SQL Server from your Server SQL Server?

- Which...

Hello

Could you please post the Error Number and State as these help in diagnosing the root cause of the issue?

Regards,

John Marsh

Hello,

There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.

Regards,

John Marsh

Hello,

I don’t understand exactly your question but when ANSI_Nulls is On, then direct comparison of Null values do not return True.

May be look at the Books Online Topic “SET ANSI_NULLS...

Hello,

I suspect you want to be using CharIndex to find the location of the Space and then SubString to extract the Firstnames.

So may be something along the lines of:-

Select

lastname,

case when...

Hello,

Would SQLH2 be the kind of thing that you are after?

Please see http://www.codeplex.com/sqlh2

Regards,

John Marsh

Hello,

I have had to do the same kind of thing myself and what we chose to do was, to pre-process the data with a .Net Assembly to split the names,...

Hello,

Obviously I don’t know the structure of your DB, but would it not be possible to somehow replace the Cursor and Dynamic SQL with a Join on the NoSeriesMaster_Prefix table?

Regards,

John...

Hello,

Would it be possible to move this information in to a Data Warehouse, which would be better suited for analysis and reporting purposes. If the DW was on a separate...

Hello,

I would choose side-by-side in this case.

May be take a look at this MSDN article regarding points to consider for the upgrade:-

http://msdn.microsoft.com/en-us/library/cc966519.aspx

Regards,

John Marsh