Some people feel the only option for setting the ports is from the server directly. You don’t need to literally logon to the Windows Server where SQL Server resides in order to […]
Reorganize all the FullText Catalog or Index with this simple script. Hope this is useful.
Want to find all the Full Text Indexes across every database? You could do one at a time, but that’s annoying, and there’s always a better way of doing it. So… to […]
Here’s a quick script that will create a login, and automatically add it to every database ( specified through a wild card of your choice ), and grant two roles read only, […]
Here’s a quick script to get the Data File Size using just the backup file. Basically; this is good to do before you run a Database restore so you can see where […]