That is correct - not really sure what happened when I posted! Apologies...

Here's a cleaner version...

SELECT????100???? [SortOrder]????,'BuildClrVersion' [SERVERPROPERTY]????,SERVERPROPERTY('BuildClrVersion')????[VALUE]

UNION

SELECT????200????,'Collation'????????,SERVERPROPERTY('Collation')

UNION

SELECT????200????,'CollationID'????????,SERVERPROPERTY('CollationID')

UNION

SELECT????200????,'ComparisonStyle'????,SERVERPROPERTY('ComparisonStyle')

UNION

SELECT????20????,'ComputerNamePhysicalNetBIOS'????,SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

UNION

SELECT????30????,'Edition'????????????,SERVERPROPERTY('Edition')

UNION

SELECT????30????,'EditionID'

????????,CASE SERVERPROPERTY('EditionID')

????????????WHEN -1253826760????THEN 'Desktop'

????????????WHEN -1592396055????THEN 'Express'

????????????WHEN -1534726760????THEN 'Standard'

????????????WHEN 1333529388????????THEN 'Workgroup'

????????????WHEN 1804890536????????THEN 'Enterprise'

????????????WHEN -323382091????????THEN...

A lock error certainly progresses the investigation!

Other procedures / jobs / DB requests occurring simultaneously?

Does the TempDB have space?

I think you'll be in a better position when you've maybe profiled...

There are other performance tools such as the Profiler you could look at.

How big is the database?

Indexing?

The questions could go on lol...

As a side note, I use the RAISERROR with...

What sort of help are you requiring?

Is it splitting the 25m records into 1m exports?

BCP performance?

A bit more information would be helpful.

Thanks

Evidence gathering is my first port of call.

Does the procedure fail every time it's run or intermittently?

Have you checked the SQL and Windows logs for around the time the issue...

Hi Matt,

You're right! There isn't a lot but I did come across this from Microsoft...

http://blogs.msdn.com/b/psssql/archive/2010/07/21/why-does-preemptive-os-getprocaddress-show-a-large-accumulation.aspx

Hope that helps.

Best regards

Robin

Hi Suresh,

I agree; script the tables using Oracle and check the syntax for DB2 compatibility, then obviously test in a development environment.

Best regards

Robin

SSIS can communicate with multiple data sources and of different types.

Providing you have the correct drivers and permissions you should be able to have SSIS communicating between the Oracle and...

Hi Lynn,

I can't remember where I got hold of this script but it does the conversion as you've asked:

SELECT J.[name] ...

Hi farmkittie,

Does this example help? Paste below in to SSMS and execute; you should see the service name in output.

DECLARE @output_file_name NVARCHAR(255)

SET @output_file_name = N'E:\SQL Server Backup\' + CAST(@@SERVICENAME AS...

If you have the SSMS Tool Pack installed...

1. Open SQL Management Studio

2. Click SSMS Tools

3. Click New Query Template

4. Edit the text in the Template Text window.

5. Click OK

All done!

Have you read the excellent "Stairway" series on the site dealing with Replication?

http://www.sqlservercentral.com/stairway/72401/

Might be a good place to start!

A bit more information would be helpful such as the background in which this error occurred.

We can only help with the information presented to us.

Just did a quick google search:

http://www.mssqltips.com/sqlservertip/1708/index-fragmentation-report-in-sql-server-2005-and-2008/

Anthony beat me to it!

I've used free Idera products in the past to monitor multiple servers, jobs and activity.