Comments
Sort by recent activity
If you have named pipes for the instance, then you'd connect that way to each node. The listener is what won't receive (or acknowledge) a named pipes connection. You can connect to SQL02 with named pipes, since it's responding to that protocol.
If you use Windows Auth, then I'm guessing it either defaults to TCP or falls back to TCP. Was looking for documentation on this, but didn't see it. / comments
If you have named pipes for the instance, then you'd connect that way to each node. The listener is what won't receive (or acknowledge) a named pipes connection. You can connect to SQL02 with named...
Protocol. Only TCP works for the listener: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover#AGlisteners / comments
Protocol. Only TCP works for the listener: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover#AGlisteners
The trick with a view works. We hide system tables because there are so many they can clutter up the view, and because we can't deploy to them, this hasn''t been something we included in the product. / comments
The trick with a view works. We hide system tables because there are so many they can clutter up the view, and because we can't deploy to them, this hasn''t been something we included in the product.
That's a neat trick. Just tried it and it worked great. Didn't know we could do this. / comments
That's a neat trick. Just tried it and it worked great. Didn't know we could do this.
Data Compare doesn't work with sys. objects. Those aren't objects we can work with, at least not most, so we didn't build this in.
If you want to know what changes have been made, you can select a list of values to a text file from another instance (or newly installed instance) and then import that into a table where you run a query between the two lists. / comments
Data Compare doesn't work with sys. objects. Those aren't objects we can work with, at least not most, so we didn't build this in.
If you want to know what changes have been made, you can select a ...
The issue you might have is if there is code with RAISERROR () that might call a specific message. You need to have those inserted into sys.messages with sp_addmessage. I don't have a good way other than scan all your code for the RAISERROR() command and document user defined messages:
RaiseError - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql / comments
The issue you might have is if there is code with RAISERROR () that might call a specific message. You need to have those inserted into sys.messages with sp_addmessage. I don't have a good way othe...
Which version of SQL Prompt? If I turn off the option for user defined objects, I get things formatted as:
DECLARE @json NVARCHAR(4000)
= N'{
"key":1,
"name" : { "firstname":"Steve", "lastname":"Jones"} ,
"Employer":"Redgate",
"Sites":{ "primary":"SQLServerCentral", "secondary":"tsqltuesday.com"}
}'
;
SELECT [key] FROM OPENJSON(@json) AS oj
; / comments
Which version of SQL Prompt? If I turn off the option for user defined objects, I get things formatted as:
DECLARE @json NVARCHAR(4000)
= N'{
"key":1,
"name" : { "firstname":"Steve", "lastname":"Jo...
Repo'd - SQL Search doesn't appear to search for user defined types or table types. / comments
Repo'd - SQL Search doesn't appear to search for user defined types or table types.
For DLM Dashboard, there is a DDL trigger that captures changes made in your databases and stores them in this Redgate database. This needs to be on the same instance, as the trigger would otherwise need to do a cross instance insert, essentially a distributed transaction.
May I ask why this is an issue for you? / comments
For DLM Dashboard, there is a DDL trigger that captures changes made in your databases and stores them in this Redgate database. This needs to be on the same instance, as the trigger would otherwis...
You are welcome / comments
You are welcome