I have an old database that I was having problems running a bit of code against. I was getting Incorrect syntax near ‘(‘. onthe following line of SQL: FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, ‘LIMITED’) It worked on other databases on the same server. I was perplexed and after checking a dozen other settings […]

When using the SQL designer to modify table structures (changing column order, changing datatypes) that requires the table to be recreated, the management tools will not allow you to save the changes. You will get an error stating, “You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require […]