Tag: SQL Server
-
SQL Managemnet Studio (SSMS)- Retrieve Unsaved Scripts
While working with SQL Server Management Studio (SSMS), we can have crash issues. This causes loss of our scripts / queries / query windows data. Sometimes we get “Not responding” error message and restarted again after automatically closed. We can’t stop this. This will be frustrating to re-write all statements again. So, there are some…
-
Exception- The definition for user-defined data type ‘MyTypeList’ has changed.
The definition for user-defined data type ‘MyTypeList’ has changed. Exception when we rename or changed any User defined TYPE and it used in stored procedures. Stored Procedures which is using this type variable will not run and throwing the exception. If we have large numbers of SP then it will to time consuming or irritating…
-
How to check SQL Job is in running state?
Method 1: System Stored procedure: sp_help_job, returns information on the job, its steps, and more. EXEC msdb.dbo.sp_help_job @Job_name = ‘Your Job Name’ Method 2: IF EXISTS(SELECT 1 FROM msdb.dbo.sysjobs J JOIN msdb.dbo.sysjobactivity A ON A.job_id=J.job_id WHERE J.name=N’Your Job Name’ AND A.run_requested_date IS NOT NULL AND A.stop_execution_date IS NULL ) PRINT ‘The job is running!’ ELSE…
-
SQL SERVER – Installation Failure Database engine services failed.
Sometimes when we install SQL Server or Add any new SQL Server Instance on Windows Machine, we can see the database errors listed below. To resolve these errors we are trying to repair existing installation or do something else. If nothing happens then we are trying to install it completely from control panel, but it…
-
How to Create Multiple SQL Server Instances on Same Server
When you install SQL Server, the installation creates an instance (DEFAULT OR SQLEXPRESS) of SQL Server. In my case I have created instanace named DEVSQL. Some times we do need to create multiple instances based on requirements. To create more instances, start the setup again. The following screen appears when setup starts for the SQL…