Question : I installed SQL Server + SSMS for my univ class and ever since then my disk space is […]
Tag: ssms
How to find column which causing “Conversion failed” error
Question : I’ve run into quite a lot of issues specially when it comes to conversion errors: convert(datetime, [fieldname]) or […]
cross database trigger: server principal is not able to access the database under the current security context
Question : I have a two databases Source and Target hosted in the same SQL Server 2008 R2 instance. I […]
SQL Server Failed Login – SQL Server login (not windows) – Random times
Question : We have the following situation and am wondering if anyone can suggest a way of determining the cause. […]
Can I get SSMS to show me the Actual query costs in the Execution plan pane?
Question : I’m fixing performance issues on a multistatement stored procedure in SQL Server. I want to know which part(s) […]
Differential Backup since a date
Question : Hi is it possible to do a differential backup in ssms 2014, so that it gets all changes […]
Wingdings font in SSMS’s column
Question : I do want to create a column which should has check marks and cross marks. Here is the […]
Disable SQL Server 2012 Management Studio remote access
Question : I am trying to disable SQL Server 2012 Management Studio remote access from other servers. I have unchecked […]
SQL Server Management Studio for a remote database
Question : With a SQL Sever database which is on a remote hosted dedicated server I can work using SQL […]
cannot read property user access. this property is not available on sql server 7.0
Question : I want to know the .mdf file path from property tab of a db, but it was throwing […]