2 video have different like create login ravi with password = ‘Ravi@@123’ second video have ….. password =Ravi@@123’. No space so which one is right ??
In the first i have wrongly entered the login as loging. the Second one is right one.Giving space or not doesnt matter you are placing password inside quotations.
SQLCMD will be Present in Bin directory of sql version... In my case the below is the path C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn
it work at first thanks note some people might have problems with the name of the sql isntance so when starting on stopping service use like this net stop MSSQL$SQLEXPRESS our net start MSSQL$SQLEXPRESS /m"SQLCMD
Hello Anjali CMD is utility from windows... you can open it by cmd in search box or type cmd in run command. Make sure you have opened with Run with administrator privilege Thanks & Regards MS SQL DBA TECH SUPPORT
The title has a typo: "rest" instead of "reset"
Great video!
Thanks.... Corrected
You are master sir, Big thanks
Thanks for showing your appreciation
Helpful video..... 👍
Glad to hear that
You are a pro !! Thanks a lot !!
Glad it helped and your comment made my day
Very helpful, thanks
Glad it was helpful! and You're welcome!
It worked, thanks a lot
I'm so glad to hear that it helped you!
It’s not work for me can you help me please what is shift press go that means shift enter and type go and than press control enter ?
2 video have different like create login ravi with password = ‘Ravi@@123’ second video have ….. password =Ravi@@123’. No space so which one is right ??
In the first i have wrongly entered the login as loging. the Second one is right one.Giving space or not doesnt matter you are placing password inside quotations.
@@MSSQLDBATechSupport thanks for replying sir 🙏🙏🙏 what is shift press go that means shift enter and type go and than press control enter ?
In SQL CMD after the query we need to give go.. its not like ssms
if you press shift it will come down then u can type go and press enter
Does this work with SQLserver express 2014?
Yes why not....
It worked! Thank you!
Good to hear
Thanks harsha sir
welcome
SQLCMD is not recognized , where is this patch file
SQLCMD will be Present in Bin directory of sql version... In my case the below is the path
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn
Hi Harsha,
for named instance it is not working...
Hi Paramsh,
Here is the link for the named instance
th-cam.com/video/SiET2Yh_id8/w-d-xo.htmlsi=mUtOIaySQn3iih0T
@@MSSQLDBATechSupport Ty
☺️
it work at first thanks
note some people might have problems with the name of the sql isntance so when starting on stopping service use like this net stop MSSQL$SQLEXPRESS our net start MSSQL$SQLEXPRESS /m"SQLCMD
Welcome and keep visit the channel for more unique content
Thank you bro
Welcome
hi...can you tell me how to use smd in sql server 2019
Hello Anjali
CMD is utility from windows... you can open it by cmd in search box or type cmd in run command.
Make sure you have opened with Run with administrator privilege
Thanks & Regards
MS SQL DBA TECH SUPPORT