Run below Query. And once the query executes completely, go through the SQL Server Error log to see the results. declare databases cursor for select…
Command: xp_readerrorlog parameter 1, parameter 2, parameter 3, parameter 4 Parameter 1: To specify the errorlog number. Starts from 0. 0 = current, 1 =…
Did you come across any situation where you wanted to make sure that the password you set for a SQL account is what you really…
SOLUTION: 1) Go to MSDB– Security –Users — UserName — User Name Properties — Assigned the ‘TargetServerRole’ in msdb 2) Run the query select pr.name,…
SYMPTOM Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)’ could not be installed. ERROR ———————————————————————————————— Product : Database Services (MSSQLSERVER) Product Version…
Question After connecting to SQL Server using SQL Server Management Studio, I am not able to see the green play arrow on the SQL Server…
If you wanna add a shared disk to the two nodes of a cluster to be built inside a VMware, Follow below steps. If your…
At first I thought starting SQL Server in Single user mode is easy in Windows 2008 fail-over cluster. But I was wrong, If I just…
Why do we need this? By default, you might be having the stock media package which will give you a SQL server without the latest…
Symptom: Shows errors like below on your Joomla, Drupal or in any other php coded webpage. Deprecated: Function ereg() is deprecated in … Deprecated: Function split() is…
You must be logged in to post a comment.