I agree, but It always depends on the requirements.

Hi,

You can create multiple steps in a single job. so by creating multiple steps you can move your 4 jobs to single job.

You can use one more parameter for controlling the output from first proc. And set a default value and will get all four results by default.

Thanks for the reply Eugene Elutin.

Is there any other way without configuring Ad Hoc Distributed Queries option?

Thanks

Hi,

You can also use table variables for better performance but it has some limitations like,

1. Transaction logs are not recorded for the table variables. Hence, they are out of scope...

Hi,

You can script all the linked servers at once from SSMS -> Object Explorer Details (Press F7) ->Server Objects ->Linked Servers and select all the linked servers ,right click...

Hi,

Below link may be useful for you, i haven't gone through in detail 🙂

http://www.sqlservercentral.com/scripts/generate+jobs+scipts/68105/

Hi, you can also use the command osql -L running from command prompt.

To list out all the instances to a text file, run below command at command prompt.

osql -L >...

If you are using excel 2007 , i.e .xlsx format file, use below code.

SELECT * INTO ExcelTable FROM

OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\test.xlsx', 'SELECT * FROM [Sheet1$]');

Note: To be able to import directly to...

Thanks for your reply.

If possible please post some code. Suggest me list of steps. Is it possible to connect Exchange server 2007 using SSIS?

Thanks.