HI

INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=C:\Test\Book1.xlsx;',

'SELECT * FROM [Sheet1$]') SELECT EmployeeId from dbo.Employees

the Code is working Fine Thanks a lot you 🙂

HI ,

i Check with the team , the network connections are good, no chance to network fault

Excellent , Thank you very much , it is working fine :-):-) :-):-)

yes correct, the table have index, and SP's.

but my table is have the IDENTITY coloumn , it may reset? , for this it may cause any problem in feature .

yes , you are correct , i check the row count it is reduced as per our requirement but , the query is keep on running and it keep increase...

Thank you , i'll follow those things

ya sure

Thank you very much

Thank you very much

ok , i'll try the trace in the server ,plz let me know the Procedure and steps the inplement the in the server

Thank you

Hi , if we enable the trace in server side It will affect the performance,

So can you plz tell me is there any inbuilt SP in msdb to show...

Thank you very much

Is there any SP in SQL to store these infomations , without using login auditing .