Ultimately I expect your program would prefer a single, comprehensive set of data. This can be accomplished using a UNION if you use CONVERT and AS on the columns to...

This sounds kind of like a good occasion for a linked server in SQL server or Oracle's equivalent should it have one (I would guess so). You can then code...

You can use osql as in the following post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=136563#bm136607

I seem to be getting a lot of mileage out of that post. 

The down...

YourCmd.cmd =

Query Analyzer may have different settings for QUOTED_IDENTIFIER and ANSI_NULLS that what the stored procedure is defined to use. Generate the SQL for the SP so that you can see...

exec sp_who

Assuming they are connecting to SQL Server using their own usernames instead of a shared username/password.

There are system tables, Enterprise Manager and other means of doing this as well.

(edited : Never mind. I didn't know FREETEXTTABLE was a full text search related function.    )

The problem isn't with that function. The actual problem...

If it is log space you are concerned with (I'm assuming you have tons of available page space if you haven't shrunk the file yet after deleting all that data)...

SELECT ISNULL( example, 1 ) FROM MyTable

Less ideal:

SELECT case when example IS NULL then 1 else example end AS example FROM MyTable

Those are the basics. ISNULL() is much preferred unless...

Consider adding an unofficial foreign key to the Permanent table. You can then use the @Temp table approach I posted earlier except between the INSERT into the Permanent table and...

You got me curious so I put the following script together. It generates SQL that will exec every Stored Procedure while reporting the execution plan (which doesn't ACTUALLY run the...

Per http://www.winnetmag.com/SQLServer/Article/ArticleID/23160/23160.html the xp_eventlog proc doesn't work in SQL Server 2000. If you really wanted to you could use xp_cmdshell to run some OS program that would strip out the...

If ForeignKeyField is available from PendingInfo I don't see why you couldn't do the following three statements:

INSERT INTO PermanentInfoTable SELECT IdentityColumn, Value1 FROM PendingInfoTable

INSERT INTO PermanentInfoChildTable SELECT ForeignKeyField, Value2 FROM...

I'm not sure I understand the problem. If you mean a CMD or BAT script why not just make multiple calls to osql, one for each output file?

Disclaimer #1: I've never used Oracle.

Disclaimer #2: I'm not sure what you do and don't know how to do.

Disclaimer #3: I've never actually tried to create an object via a...