Posts
Sort by recent activity
SQL Invalid Check
Hi
When i do a Invalid check on a database it seems to get half way through the stored procs then gives this error:
Login failed when attempting to find invalid objects in DATABASE.
To find invalid...
Idea: Generate from column
Hi,
I have some tables that are not normalised correctly due to being denormalised for OLAP reasons.
So basically i would like to see a way that you can generate for instance a company name, but ba...
Smart Rename Filtered Index
Hi,
I have found a little bug in smart rename. On the object i rename i have a filtered index that looks like this:CREATE UNIQUE NONCLUSTERED INDEX [IX_UNQ_Name] ON [Config].[t...
Invalid Objects missing stored proc
Hi,
I am using invalid objects finder at the moment very heavily.
However there is a proc which will not execute however - its not appearing on the list.
It fails to execute due to invalid columns....