I stumbled on a thread at MSDN titled “How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?” when trying to… Read More »How to delete/drop/select all the tables from SQL Server Database?
Another error that came my way this morning was the SSPI context error when trying to connect to a SQL server. A colleague was trying… Read More »[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
Aside from BMC Remedy, another product that I’ve recently had to learn more about is Microsoft SQL Server. From writing my first stored procedure, to a… Read More »How to list all databases on a SQL Server
To change the default port for SQL Server 2005 follow the steps listed below: Open SQL Server Configuration Manager which is found under Microsoft SQL… Read More »Configure SQL Server 2005 to Listen on a Specific TCP Port
To change the default location of SQL 2005 files, follow the instructions below: Open SQL Server Management Studio Right click the server name and choose… Read More »Changing the Default Location of SQL 2005 Files