Steve is right. There is more in life than our career. In IT, we do our best, work overtime and endure stress. No matter how much extra effort you put...

Hi,

Try this,

SET FMTONLY OFF

SELECT * FROM [LinkedSeverName].master.sys.sysaltfiles

Hope you find it helpful.

Regards,

Jasmin Tang

Hi,

You need to ensure that the file test.xls is in the SQL server's C: drive itself, not in the server/pc where you are executing the statement.

Hope you find it helpful.

Regards,

Jasmin...

Hi,

Try specifying the object owner, something like this, which works fine for me:

SELECT * FROM [LinkServerName].master.dbo.sysaltfiles

Hope you find it helpful.

Regards,

Jasmin Tang

Hi,

I have modified from the previous post by including holidays. You need to create a holiday table with the holiday dates stored.

DECLARE @dDate AS DATETIME

DECLARE @sContinue AS CHAR(1)

SET @dDate =...