Thanks for posting a create table script. Not exactly sure what output you need, but a Recursive CTE is a way of avoiding dynamic SQL (bear in mind that it's...

No. There are no solutions that can be implemented entirely within SQL Server that will be able to capture the event of a row getting inserted into the Oracle database...

If you need to fire a trigger when the row is inserted in Oracle, then you need to create the trigger in Oracle, not SQL Server. You can create a...

Actually, it's more likely to be a 407 if it's proxy authentication required.

You do have a Bing Maps Platform account and are providing the authentication for this as per the...

The error suggests you're behind a proxy server that requires authentication (Such as Microsoft ISA Server) and you're trying to access an external web service.

So in your CLR code,...

Do they need to be stored in the database at all? Do you require that level of referential integrity for binary files?

If not, then I'd probably approach this by putting...

Firstly, I think it's important to point out that the database layer probably isn't the best place to implement this.

Some general points:

1) Forename, Surname and Address Lines should be held...

If you still have the query that was causing the error, paste the text into something like Notepad++, then go to view->Show Symbol->Show All Characters.

I'm guessing that there's some...

Personally, I'd abandon the idea of using pure T-SQL for this.

If you've got SQL 2008 Enterprise Edition, consider using the fuzzy lookup task in SSIS. Play around with match confidence...

From Exchange 2003 onwards, I don't think you can use anything as simple as a linked server connection.

You'll probably have to design a .Net application that performs a two way...

You've clearly put SQL 2008 SP1 in the subject line and posted this in the SQL 2008 forum, but the error message seems to be from a SQL 2000 DTS...

The backup came from a SQL Server 2008 R2 instance and you're trying to restore it to a SQL Server 2008 instance - you cannot do this.

Your options are:

1) upgrade/create...

I think the answer is no, not without changing the code. This error is not suppressed by changing the compatibility mode.

Style codes are used to convert dates to a particular...

If it's a dedicated box, only running the core SQL services, then I'd agree it probably handles the amount of memory to allocate to SQL Server fairly well.

However, if you...

DATEDIFF returns and integer, but you've declared the variables you return the results of the function to as DATETIME. These integer values are then getting implicitly converted to a datetime,...