All that I know of is ORACLE or SQL-NET.

Clustered indexes provide some of the best performance gains, provided it is correctly selected. The leaf nodes of a clustered index contain the actual data. This means that...

Creating a clustered index on a column with low...

You also need to open up udp 1434. The browser service uses this port to determine the port numbers of remote named instances.

more info:

http://msdn2.microsoft.com/en-us/library/ms181087.aspx

Yep. I think it makes the naming convention...

NP, thanks for the feedback.

Is the sql browser service running? The browser service is able to resolve the ports dynamically, without the use of an alias.

You need to tell SQL that your inserts are unicode. To do so apply the N before all strings.

N'Konto ksiegowe R.O.V.'

I dont know of a way to determine the newest file in a directory without performing some advanced scripting. You still have options here, but I do not know...

This is as simple as right-clicking on...

Same concept but a little different twist.

You should use the foreachdatabase.

EXEC master..sp_MSForeachdb '

USE [?]

IF DB_ID(''?'')>4

BEGIN

IF EXISTS(SELECT 1

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = ''Customer'')

BEGIN

PRINT ''?''

END

END

'

You have to do some fancy manuvering. This link will walk you through the process 1 step at a time.

http://agilebi.com/cs/blogs/jwelch/archive/2008/02/08/adding-headers-and-footers-to-flat-files.aspx

How will the file be named and do you transmit more than one file a day?

Please note the department and facility are not the column names. They are referenced in the table treatment by the lookup code. The department and facility have same medical record...