Recently it happened to me. I was using a SandBox and Had sql server installed on it. I restarted this box and the SQL Services did not came up. I tried starting the SQL Services and was stuck with below error.
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')
Here is the small piece of code to get some handy information on databases on SQL Server Instance
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.
As a DBA Its very important to always keep an Eye on Disk Space usage.
The Below stored procedure will help you monitor the Disk Space Usage and trigger an Alert if the specified Threshold is reached which is less than 20% free space on all drives on Server.
Wondering How to Export Data to Excel from your SQL Server?
Below mentioned are detailed step by Step Instructions on How to Export Data to Excel from your SQL Server.
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.
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.
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
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.