- 0x8007232B DNS Name Does Not Exist Error on Windows Activation
- How to update a column with incrementing numbers
- How to get top N rows for each group?
- How to put a column into a delimited form
- How to export results of a stored procedure to a txt file
- Parsing delimited words from a column
- How to get N-th max value
- How to get a random row from a table
- How to dynamicaly rank rows
- How to get just date or just time from a datetime value
Change display of system tables in SQL Server Enterprise Manager
By default, SQL Server Enterprise Manager automatically displays all of the system databases and their objects. If you don't want to see the system tables, you can hide them by editing your server's registration properties.
To edit your server's registration properties, begin by opening SQL Server Enterprise Manager. In the console tree, right-click on your server; from the shortcut menu, choose Edit SQL Server Registration Properties. Uncheck Show System Databases and System Objects, then click on OK.
Now when you view the tables in a database, you no longer see the system tables.
Source: Joe Froehlich