Justin Cooney
Web Development Tips and Examples
Category: Database
-
Sometimes using the SSMS GUI table designer is a hassle when compared with directly querying the table structure using a simple SQL statement. For example if you are right in the middle of editing a stored procedure and want to know the data types and sizes of some columns for a table or two, then…
-
A fairly common task is to add or remove user or group permissions to a SQL Server Stored Procedure, and also to maintain a list of database objects and the permissions associated with them. The syntax for these actions has remained fairly similar throughout the various versions of SQL Server, although SQL Server 200 and…
-
The other day I was working on a Windows 2003 SP2 server that was no longer displaying anything other than the Windows desktop. I could not bring up the start menu or even see the bottom menu bar. This naturally was a problem because I wanted to set up a new Web site on the…
Justin Cooney 