Question : I have installed SQL Server 2005, but at the time of installation I forgot to change my password. […]
Tag: ssms
Looking for SQL Server 2000 DTS Components
Question : I am trying to upgrade a very old SQL Server 200 to SQL Server 2008 R2. We have […]
Proper way to export database to other servers
Question : I am using SSMS (I am a software developer, not a DBA) and in each application release I […]
.bak file not visible in any directory in SSMS
Question : I have a .bak file created today by someone else, manually created through SSMS 2008 R2. I’m trying […]
SQL Server Management Studio crashes when attaching an mdf file
Question : After the Windows 10 November update 1511, 10586 I cannot attach my databases with SSMS. It would just […]
How do I compare all tables with nonzero rowcounts (in an archive db) with tables of the same name in the line of business db?
Question : (Full Disclosure: I am a software tester who is out of my depth. Because I am unable to […]
Matching empty string is not working
Question : I have the following query SELECT Ice.IceId, Ice.Code, Box.Ice, LEN(Box.Ice) AS IceCharLength, DATALENGTH(Box.Ice) AS DataLength, Box.Ice, ASCII(Box.Ice) AS […]
Trigger to restrict users from creating a new table in the database
Question : How do I create a SQL Server trigger that will restrict any users from creating a new table […]
SQL SSMS want to shortcut “Edit View”
Question : I usually right click on a view or a stored procedure and then choose Script View -> Alter […]
Which permissions are required to view Windows Event Logs in SSMS?
Question : I’m trying to figure out which permissions are required to be able to view the Windows Event Logs […]