New answers tagged

1

You can't. When you upload data source and report definitions to the report server it does store their information in the dbo.Catalog table which you can see using Convert(Xml, Convert(Varbinary(Max), Content)) and as it's XML you can use XPath to pull out the fields you're interested in. The problems really begin once you modify anything on the SSRS web ...


2

Get SSRS Datasources from ReportServer I would also like to include the 'Connection String' at least How can I display Data Source details with a SQL query? TSQL for getting the Connection String of SSRS Data sources -- Transact-SQL script to get connection string of all SSRS Shared Datasources. /* Let's say you want to move a database to an ...


0

If the stored procedure only returns one result set, and you know the column names in advance, then you can create a temp table and Insert #TableName Exec ProcedureName. You would then select the value you want into a variable from the temp table, and run the procedure again. If it only returns one result set but you don't know the column names in advance, ...


2

You can use sp_start_job stored procedure to start a job from any server using the server_name parameter. Passing nothing to this parameter means the job is on the local server but you should be able to pass your remote instance name and have it call the job on that server. The only thing I think is you might have to use a run as condition on the job ...



Top 50 recent answers are included