Execute Script Error Resolved In SQL Server Management Studio

Execute Script Error - Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was 'Insufficient memory to continue the execution of the program. (mscorlib)'. You might be wondering why I would even have such a large script to

Shrink Bloated Development Databases – Save Precious Space

Shrink Bloated Development Databases - Last night I noticed that the space on my C drive was running slightly low. When this happens, I usually go and look in the temp folder to see what unnecessary space hogs are hiding there. After clearing this folder I realised that the amount

Prevent Accidental Table Data Deletion In SQL Server Management Studio

Prevent Accidental Table Data Deletion - How do we secure our production database against simple errors that could cause quite a problem. As a developer, I mainly work on my database while being in a development environment. It is only after the development is one that some of the work

Automate Standard Comment Blocks For New SQL Queries

Automate Standard Comment Blocks - If you write a lot of SQL stored procedures or functions in SQL Server Management Studio, you might like this tip. Many companies require a standard comment format at the beginning of a stored procedure or function. What would be the easiest way to always have

Customizing SQL Server Status Bar – Know Your Connection

Customizing SQL Server Status Bar - Sometimes I work on a server that has live databases mixed in with test databases. You can obviously see the problem here. Let's delete some test data. Oops, wrong database. Well there is a solution. SQL Server Management Studio allows us to identify the connection.

Easily Generate Table Change Scripts In SQL Server Management Studio

Something I found frustrating when designing databases, were the frequent changes made to tables. Managing the scripts can become quite tricky, especially if you are still in the design phase. This is made worse by code changes or change requests to existing data structures. Sometimes a person gets so caught

Script Table Data In SQL Server Management Studio

Script Table Data

How Do I Script Table Data In SQL Server Script Table Data - I have used other tools to do this for ages. I can't believe that I never knew that it existed in SQL Server Management Studio. Well ok, in my defence it isn't quite the most 'In-your-face' setting. Nevertheless, it