How can we help you today? How can we help you today?
PawJ
Activity overview Badges (0) Posts (7) Comments (6)

Comments

Sort by recent activity
Hey Jon Just posted this on uservoice: IntelliSense for $partition. – Customer Feedback for Redgate (uservoice.com) / comments
  1. Community
  2. SQL Prompt
  3. Intellisense for $partition.<partition_functions>
Hey JonJust posted this on uservoice: IntelliSense for $partition. – Customer Feedback for Redgate (uservoice.com)
0 votes
We have the same issue: our info here: =================================== Error connecting to '<servername>'. =================================== Object reference not set to an instance of an object. (RedGate.SharedSSMS.2019) ------------------------------ Program Location:    at RedGate.SharedSSMS.VersionSpecific.ConnectionManager2018Plus.TryConvertConnectionPropertiesFromSqlConnectionInfo(SqlConnectionInfo connectionInfo, IConnectionProperties& connectionProperties)    at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.ParseNodeInformationInner(INodeInformation node)    at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.ParseNodeInformation(INodeInformation node)    at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.SetSelectedNode(INodeInformation node)    at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.AfterSelect(Object sender, TreeViewEventArgs e)    at System.Windows.Forms.TreeViewEventHandler.Invoke(Object sender, TreeViewEventArgs e)    at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)    at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)    at System.Windows.Forms.TreeView.WmNotify(Message& m)    at System.Windows.Forms.TreeView.WndProc(Message& m)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)    at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)    at System.Windows.Forms.Control.SendMessage(Int32 msg, IntPtr wparam, IntPtr lparam)    at System.Windows.Forms.Control.ReflectMessageInternal(IntPtr hWnd, Message& m)    at System.Windows.Forms.Control.WmNotify(Message& m)    at System.Windows.Forms.Control.WndProc(Message& m)    at System.Windows.Forms.ScrollableControl.WndProc(Message& m)    at System.Windows.Forms.ContainerControl.WndProc(Message& m)    at System.Windows.Forms.Application.ParkingWindow.WndProc(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)    at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)    at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)    at System.Windows.Forms.Control.DefWndProc(Message& m)    at System.Windows.Forms.Control.WndProc(Message& m)    at System.Windows.Forms.TreeView.WndProc(Message& m)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)    at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)    at System.Windows.Forms.Control.SendMessage(Int32 msg, Int32 wparam, IntPtr lparam)    at System.Windows.Forms.TreeView.set_SelectedNode(TreeNode value)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorerControl.AddHierarchy(SqlOlapConnectionInfoBase info, IExplorerHierarchy hierarchy)    at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ConnectToServer(UIConnectionInfo connectionInfo, IDbConnection liveConnection, Boolean validateConnection) ----------------------------------------- Version Information: Red-Gate Promt 10.14.8.6563 SQL Server Management Studio 19.3.4.0 SQL Server Management Objects (SMO) 16.200.48053.0+08fe64c9e8eb5ff3c7ea5787f145e9ecb3d57df8 Microsoft T-SQL Parser 17.0.27.0+b6df00d03710e3fafcbe827aad08bdbe9d45d1ab Microsoft Analysis Services Client Tools 16.0.20054.0 Microsoft Data Access Components (MDAC) 10.0.19041.3570 Microsoft MSXML 3.0 6.0  Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.19045 / comments
  1. Community
  2. SQL Search
  3. SSMS Analysis Services with SQL Search
We have the same issue: our info here:===================================Error connecting to '<servername>'.===================================Object reference not set to an instance of an object. ...
0 votes
Hi Ben But it wasn't what I asked for! I requested a CLR function to prepare scripts using a function. However, you are asking me for the following: Export my code to a file Starting the application up and bulk format the folder Importing the formatted code file Saving the script.. This appears to be quite thorough. But it's fine if you don't see the use case and decide not to implement this functionality... / comments
  1. Community
  2. SQL Prompt
  3. SQL Format as CLR function
Hi BenBut it wasn't what I asked for!I requested a CLR function to prepare scripts using a function. However, you are asking me for the following: Export my code to a file Starting the application...
0 votes
When in a query window, we can right click and choose Format SQL. There is a bulk method shown here: https://www.red-gate.com/hub/product-learning/sql-prompt/bulk-formatting-of-the-sql-server-sql-files. "i would prefer if i could stay in code" So what I would like to have is a CLR function where I could do the same, like: SELECT [master].[redgate].format_sql(@expression, @style, ... ) / comments
  1. Community
  2. SQL Prompt
  3. SQL Format as CLR function
When in a query window, we can right click and choose Format SQL.There is a bulk method shown here: https://www.red-gate.com/hub/product-learning/sql-prompt/bulk-formatting-of-the-sql-server-sql-fi...
0 votes
Hey Jon Thanks for the reply, sadly im not able to fix it with your'e suggestion, this is what i get [image] I do the refresh (also tried to restart SSMS) But still I only get this [image] / comments
  1. Community
  2. SQL Prompt
  3. Incorrect Temp table definition
Hey JonThanks for the reply, sadly im not able to fix it with your'e suggestion, this is what i getI do the refresh (also tried to restart SSMS)But still I only get this
0 votes
GeoffSimons said: SQL Monitor 9.0.10 has been released.  Direct download link.  Features New global options to allow sending emails by alert severity - e.g. Medium and High only I don't understand, why go to the trouble, of implementing notification by severity and not do it on all notification methods, including slack ??? Please, please, please do this for all the noftification methods... / comments
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 9 released
GeoffSimons said: SQL Monitor 9.0.10 has been released.  Direct download link. FeaturesNew global options to allow sending emails by alert severity - e.g. Medium and High only I don't unders...
0 votes
Total activity
18
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5