Activity overview
Latest activity by danfountain
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...
Sorry just to clarify (sorry i cut the wrong bit out of a script).
The names of the indexes should be the same. The only bit which is causing a problem is the missing where clause.
The first part is what the index currently looks like. The second part is what is attempted to be put back on by rename on the renamed table.
Dan / comments
Sorry just to clarify (sorry i cut the wrong bit out of a script).
The names of the indexes should be the same. The only bit which is causing a problem is the missing where clause.
The first part ...
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...
Hi,
I have sent in an email for this issue.
Many thanks
Dan / comments
Hi,
I have sent in an email for this issue.
Many thanks
Dan
If it helps here are the only errors i am getting on SQLPrompt
24 Oct 2012 08:48:20,705 [1] WARN RedGate.SQLPrompt.CommonVS.ToolWindows - Could not set window state for tab SQL Prompt - Invalid Objects
System.ArgumentException: Value does not fall within the expected range.
at EnvDTE80.Window2.set_WindowState(vsWindowState plWindowState)
at RedGate.SQLPrompt.CommonVS.ToolWindows.ToolWindow`1.GetOrCreateWindow() / comments
If it helps here are the only errors i am getting on SQLPrompt
24 Oct 2012 08:48:20,705 [1] WARN RedGate.SQLPrompt.CommonVS.ToolWindows - Could not set window state for tab SQL Prompt - Invalid Ob...
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....
Just to confirm the folder location is here:
C:\Documents and Settings\USERNAME\Local Settings\Application Data\Red Gate\SQLSearch 1\Indexes
the original post had application data then local settings - but its the other way around (confusing as ther is an application data at the same level as local settings).
Dan / comments
Just to confirm the folder location is here:
C:\Documents and Settings\USERNAME\Local Settings\Application Data\Red Gate\SQLSearch 1\Indexes
the original post had application data then local settin...