How To Transfer Objects From One Schema To Another Schema In SQL Server

Ever wondered how to transfer all Database Object from One schema to another, well here is the small script, this will give you the script which you need to run. Make sure you take full backup before doing anything.

select 'alter schema [New_Schema] transfer ['+schema_name([schema_id])+'].['+[name]+']'
from sys.objects where schema_name([schema_id]) not in ('dbo', 'sys')

How To Schedule A Job In SQL Server Agent

Its one of the basic thing in SQL Server is to Schedule a Job, Most of the guys who work on SQL Server are aware of this, but still thought of putting across a step by step instructions on How To Schedule A Job In SQL Server Agent for NoVoice.

Connect to You SQL Server Instance as shown below for my I am connecting to my Local Instance and click connect.

Manually Run Trigger Schdeuled Subscribed SSRS Report

Ever wondered how to test a Scheduled SSRS Report or how to Manually Run/Trigger a Scheduled SSRS Report for testing or for re-sending needless to wait till the next schedule of subscription? Yes, this is achievable and can be done.

There are two ways you can accomplish this.

Every schedule subscription has a SQL Server Agent Job associated with it, one way is to find out this Job and run it.

Second way is to find the subscription ID of the scheduled Report and Trigger it using AddEvent Stored Procedure.

Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

You Have a SSRS Report on Report Web server which is running fine when you run from GUI.

But when you want to schedule the same report you might come across this error

"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid." Screenshot below.

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

You might receive this error when you try to open the Report Server Manager.

"The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help" A screenshot below of error

Unable to Connect to Named Instance of SQL Server

I came across a strange Issue today. I had a default instance of SQL Server installed on my Machine which was up and running and was able to connect to this Instance from Remote machines.

Now some testing purpose, I wanted another instance on Same Machine. So I installed the Same version of SQL Server Named Instance on the Machine, Rebooted the machine after installation. I was able to connect to Named Instance Locally. When I tried connecting to this Named Instance remotely, I was not able to connect.

Pages