Mini Post: Saving changes is not permitted. The changes you have made require...

Hey Everyone! (Capital 'E' since you are all that important!)

Welcome to or welcome back to SQL Something!

A real quick one today to maintain my quota: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Fig. 1: Oh Noes!

You may encounter this error when you try to make adjustments to columns of a table that has data in it. Examples are dropping/adding a column(s).

Simple enough to 'fix'.

Mini Post: Restore of Database Failed; Access is Denied

Happy New Year! (Albeit a little late!)

Welcome back to SQL Something!

To start off the year we'll look at a very small issue: "The operating system returned the error '5(Access is denied)' while attempting restore".

Fig. 1: Access is Denied

Mini Post: Useful - Colour Coding Your SQL Instances/Queries

Hey everyone just a quick useful something that my colleague reminded me of.

So if you're like me, you may have many queries windows open but they could be from multiple instances of SQL Server, over multiple servers.

It may become a little confusing as to what query is being run on what instance.

Luckily SQL Server gives you the ability to colour code your query windows! You can assign a colour to a particular instance and then all queries that run against that instance will have a band of colour, indicating the instance. Lets take a look after the jump.