Skip to main content

Featured post

How to Insert line break in Text component in React Native

Hi, I was developing an application in react native.I have to handle lots of text data in this small react native application.I have used  Text component in react native many times. While working on this application,i had a requirement to display some text content with line breaks.I will explain it clearly with an example.I want to display a text as shown below  Welcome Please subscribe my channel I wrote react native code as shown below <View> <Text> Welcome Please subscribe my channel </Text> <View> When i run these lines of code,It will display text as shown below Welcome Please subscribe my channel   - instead of displaying in two lines with line break,it displays in a single line.So i have to find a solution to insert line break in Text component in React Native.After lots of research,i found a clean solution as shown below <View> <Text> Welcome{"\n"} Please subscribe my channel </Text> <View> Here ...
Read more
Labels

How to Find SQL Server Running Port Number Using Stored Procedure xp_readerrorlog

Let me introduce a procedure that can be used to get SQL Server running port number in different MSSQL Server  versions 


                            xp_readerrorlog 


Let me write the SQL Query to execute the above stored procedure 


USE MASTER 

GO

xp_readerrorlog 0,1,N'Server is listening on'

GO




    This MS SQL stored procedure can be used in most of the SQL Server versions like
   
  • SQL SERVER 2005
  • SQL SERVER 2008
  • SQL SERVER 2012
  • SQL SERVER 2014
  • SQL SERVER 2016
  • SQL SERVER 2019

So try to use this SQL Query when you need to find SQL Server Port number in your system



Labels: