Tag: Database
-
Check for Objects in SQL Server
Examples of how to check your SQL Server database for existing tables, stored procedures, indexes, etc. Use them before you drop/create/modify to avoid errors.
-
How to Run SQL Server Management Studio as a Different Windows User
If you’re using Windows Authentication for your SQL Server database you’ll need to run SQL Server Management Studio (SSMS) as that Windows account to test queries. SSMS normally runs as the user logged in to Windows, but there is a simple way to run it as the database access account. Just shift-right-click on a shortcut…
-
New Version of SQL Server To Launch in March 2012
They really feel like they just keep on coming. It feels like only yesterday that we finally upgraded to SQL Server 2008 R2 here. In fact, I think it was 6 months ago, in 2011. Not like I need to tell you, but it’s hard to keep up. But here it is. SQL Server 2012.…