Hi,

i have installed the ssms 17 and ssms 17.1 from given link
but again i have opened ssms
it is opening in sql server 2012 only.

how...

thanks for sharing
can i download ssms from below link

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup

i have tried to get the code but unable to get complete output.

both the keys

for production which is preferable

Thanks

I want to show the failed jobs step I'd in the result set.

How to add this to my script

yaa I am using both

is there any options to do this

Hi,

I have setup with 4 node active passive cluster services.one 1 node is active and remaining 7 are passive.i want to fail over active node to other node.which node can...

hi,

I have ran the following command

ALTER SERVICE MASTER KEY REGENERATE on the master database again I am getting below error

Msg 15320, Level 16, State 12, Line 1

An error...

what is advantages of Always On over SQL Server Clustering

Hi,

I have tried to shirnk the database also below error I am getting

The transaction log for database 'New' is full due to 'AVAILABILITY_REPLICA'. (Microsoft SQL Server, Error: 9002)

Hi,

I have manully faill overed server B as primary server.after some time my customer asked to bring the Server A as primary.so how can I proceed. presently server A is...

WE ARE USING 2 NODE CLUSTER

Have you placed this expression in the flat file connecion manager.

Hi,

i am inserting large procedures and queires into the execl sheet.due to procedures length issue it is not fitting in the excel sheet.