Contents tagged with SQL server
-
Creating a secure SQL server login - CHECK_EXPIRATION & CHECK_POLICY
In SQL Server you can create users using T-SQL or using the options provided by SQL Server Management Studio.
-
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486)
-
SQL Server Management Studio query template
Last day I was working on SQL server and I got this strange error
---------------------------
Microsoft SQL Server Management Studio
---------------------------
Cannot find template file for the new query ('C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql').
---------------------------
OK
At first I thought my SQl server installation was corrupt. I changed few settings, tried to repair but no use.
Solution:
Actually the solution was very simple. I just created an empty file SQLFile.sql in the designated folder and then it started working. Now this gave me a new idea. I could add my own template and every time I open SSMS I will get this template. Phew