Viewing 4 posts - 1 through 4 (of 4 total)
June 10, 2014 at 3:48 pm
SELECT *
INTO dbo.YourTableName
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\Path;Extended
properties=dBase 5.0')...[FileWithoutExtension]
--
kb
Microsoft Knowledge Base Articles Monitoring | Apple Knowledge Base Articles Monitoring
March 24, 2007 at 2:39 pm
SELECT * FROM master.dbo.sysremote_indexes('YourLinkedServer','RemoteDatabase','dbo')
Tom
February 15, 2007 at 8:18 am
January 14, 2007 at 5:32 am
Viewing 4 posts - 1 through 4 (of 4 total)