Posts
Sort by recent activity
Error Handler:
I have a code inside a SPError Handler:
when I ran SQL Refactor, it will chage toError Handler : (Space is introduced)
it is giving syntax error when I try to save the SP
Specified argument was out of the range of valid values
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentOutOfRangeException: Specifi...
[sys].[internal_tables] instead of int
I wanted to typecreate table [Users-Privilages]
( PrvilageId int,userid int)
but I gotcreate table [Users-Privilages]
( PrvilageId int,userid [sys].[internal_tables])
ALTER CUBE UPDATE DIMENSION
Most of time I am getting above ALTER CUBE UPDATE DIMENSION at wrong place
ex.create DATABASE [rd]ALTER CUBE UPDATE DIMENSION
I got following error
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentOutOfRangeException: The sup...
Unnessary key words
If I type Create Table B ( I wanted to create a table called and press space, it will say Create Table Backup which is not I wanted
USE keyword
USE to change between Databases are not working as databases are not listed after typing USE and ctrl +Space
Issue when typing in SQL Prompt
I typed Select * from Employees
it was converted toSelect * from Employees EM
Then I type Select * from Employees where EM. and Press Ctrl Space
When I select a item from the listSelect * from Emp...
Slowness
I found that after installing SQLPrompt I have got some serious performance issue in SSRS.
Capitalization
What about including capitalization of key words.
For me this is very much a need.