Comments
Sort by recent activity
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
I don't see an easy way to do this. I know we could write a Python script that would read the table and optionally return a NULL, but that's an overly complex approach.
What I'd do is:
call SQL Data Generator from the command line, use a normal FK generator
call a SQL script that looks at Equipment.Ownership and sets Equipment.Operator to null
Really this is likely a quicker approach. I wish SDG included some pre/post processing, but that's not likely to come soon. Instead, I'd set this as a known process for provisioning data sets. Call SDG, then call
update equipment
set operator = null
where ownershiptype = 'Subcontracted' / comments
I don't see an easy way to do this. I know we could write a Python script that would read the table and optionally return a NULL, but that's an overly complex approach.
What I'd do is:
call SQL D...
I'll pass this along as something to add to the list. I don't think I've heard this, so I'm not sure this is a common scenario. / comments
I'll pass this along as something to add to the list. I don't think I've heard this, so I'm not sure this is a common scenario.