Activity overview
Latest activity by anildas
I also uninstalled SQL Prompt 4 before installing SQL Prompt 5. I also saw the error regarding SQL Refactor 1.5. I also see SQL Prompt 5 in the SSMS menu, disabled. / comments
I also uninstalled SQL Prompt 4 before installing SQL Prompt 5. I also saw the error regarding SQL Refactor 1.5. I also see SQL Prompt 5 in the SSMS menu, disabled.
SQLCMD macros not supported
Consider the following valid script which runs in SSMS without issue:
:setvar x x
SELECT *
FROM sys.tables
Reformating the above using SQL Prompt 5 results in the following error:
SQL Promp...
I get the same error as that reported by Decorum.
I ran the TSQL suggested by Chris.Allen on 24 Aug 2009 17:41; no rows were returned.
Log follows:
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at S..ctor(Permissions permissions, Permissions targetPermissions, Options options)
at RedGate.SQLCompare.Engine.Permissions.a(Permissions , Options )
at RedGate.SQLCompare.Engine.Schema.Equals(IDatabaseObject target, Options options)
at RedGate.SQLCompare.Engine.Database.a[a](Differences , IDatabaseObjects`1 , IDatabaseObjects`1 , Options , SQLVersion , Int64 , Int64& , Int32& , L )
at RedGate.SQLCompare.Engine.Database.CompareWith(Database targetDatabase, Options options, SqlCompareOwnerMappings mappings)
at ap.DoCompareDatabases()
at RedGate.Shared.Utils.ProgressTasks.ProgressTask.a()
at RedGate.Shared.Controls.ProgressDialogEx.e()
Does this indicate that the "key was not present in the dictionary" I am experiencing is caused by a schema or user that has the "View Change Tracking" permission granted or revoked? / comments
I get the same error as that reported by Decorum.
I ran the TSQL suggested by Chris.Allen on 24 Aug 2009 17:41; no rows were returned.
Log follows:
System.Collections.Generic.KeyNotFoundException: ...
STATS not supported by master..sqlbackup
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE does not support the STATS. Is there a way to display progress when restoring from a script?
Unfortunately, this makes SQL Prompt totally unusable for me.
You wirte that "we will probably include the support for SQLCMD in our future versions". Where is it on your roadmap? Within 2009? Later? / comments
Unfortunately, this makes SQL Prompt totally unusable for me.
You wirte that "we will probably include the support for SQLCMD in our future versions". Where is it on your roadmap? Within 2009? Later?
SQLCMD macros :setvar and $()
I use SQLCMD macros. A simple example would be::setvar server foo
:setvar database bar
:connect $(server)
USE $(database)
SQL Prompt chokes on these. Do you have any plans to sup...