
How can I determine installed SQL Server instances and their …
I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this w...
sql - Find all tables containing column with specified name - Stack ...
Find all tables containing column with specified name Asked 14 years, 9 months ago Modified 5 months ago Viewed 4.5m times
How to find server name of SQL Server Management Studio
Apr 18, 2013 · I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server …
sql server - Get size of all tables in database - Stack Overflow
Oct 25, 2011 · Here is another method: using SQL Server Management Studio, in Object Explorer, go to your database and select Tables Then open the Object Explorer Details (either …
How to Identify port number of SQL server - Stack Overflow
Oct 18, 2013 · This caused my SQL Server Management Studio to malfunction (due to a null number bug in Visual Studio 2010). It was able to connect and list tables, as well as open an …
How to retrieve the product key of a SQL Server installation from ...
Dec 20, 2018 · I have multiple versions of SQL and understand that product key registry paths changes for each version. We don't want to hard code the path, hence I'm searching for …
SQL Server query to find all permissions/access for all users in a ...
Aug 13, 2011 · I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored …
How do I see active SQL Server connections? - Stack Overflow
Jan 21, 2019 · I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, …
How to find all trigger associated with a table with SQL Server ...
Apr 17, 2015 · I created a trigger for a table in SQL Server and it works for me. My problem is: How do find it and modify it? I use this query to find my triggers: select * from sys.triggers This …
How to find SQL Server running port? - Stack Overflow
Yes I read this How to find the port for MS SQL Server 2008? no luck. telnet 1433 returns connection failed, so I must specify other port. I tried to use netstat -abn but I don't see sqlservr...