Comments
Sort by recent activity
apologies, edited the link, i'd missed off the h i guess the forum is an opportunity to discuss with other users as well as redgate support, as people might be able to offer workarounds or provide more evidence that the issue exists (persists in other versions). whereas in your case, if i understand correctly, you are suggesting a fix has been undone - so that would warrant a service request (if you have a support contract) because it should be prioritised. i suppose what might be good - to save us typing the same thing twice - is a convert question to request button. regards. / comments
apologies, edited the link, i'd missed off the hi guess the forum is an opportunity to discuss with other users as well as redgate support, as people might be able to offer workarounds or provide m...
my pc just told me there was an update so i downloaded and clicked install. the wizard then ran, got to 97% and then said Finished. Could not install. without any explanation. Now i go into SSMS and SQL Prompt and Tab history seem to have totally disappeared. i've now re-intalled 9.2.6 from the link in the op and done an update to 9.3 successfully on second attempt / comments
my pc just told me there was an update so i downloaded and clicked install. the wizard then ran, got to 97% and then said Finished. Could not install. without any explanation. Now i go into SSMS an...
I am now on Version 6.1.8 and this issue is still occurring. If i have checked in an object name as a table and then later change the name of the table and encapsulate it into a view of the original name so that referencing objects still work, i am then prevented from checking in any changes as redgate doesn't like the duplicate objects it sees (the original table and the new view with the same name). I therefore have to spend time manually amending the items in TFS myself. / comments
I am now on Version 6.1.8 and this issue is still occurring.If i have checked in an object name as a table and then later change the name of the table and encapsulate it into a view of the original...
Hi,
Sorry situation has not naturally arisen again until now, but this error is still being thrown [image]
regards / comments
Hi,
Sorry situation has not naturally arisen again until now, but this error is still being thrown
regards
hi,
About is saying Version 6.0.2.6908 and check for updates is saying "No updates available: You are running the latest version" / comments
hi,
About is saying Version 6.0.2.6908 and check for updates is saying "No updates available: You are running the latest version"
post removed as i misread the original question so comment was redundant / comments
post removed as i misread the original question so comment was redundant
Hi Jessica, seems it occurs only if i wrap use a select in the right hand side of the statement assigning the value so I can remove the warning by removing the SELECT keyword.
Example:
IF EXISTS(SELECT (1) FROM sys.objects [o] WHERE (SCHEMA_NAME([o].[schema_id]) = (N'dbo')) AND [o].[name] = (N'fn_myfunc') AND [o].[type]=(N'FN')) DROP FUNCTION [dbo].[fn_myfunc];
GO
CREATE FUNCTION [dbo].[fn_myfunc] ()
RETURNS NVARCHAR(11)
AS BEGIN
RETURN(N'hello world')
END
GO
;DECLARE @HasWarning nvarchar(11) = (SELECT [dbo].[fn_myfunc]())
;PRINT(@HasWarning)
;DECLARE @NoWarning nvarchar(11) = ([dbo].[fn_myfunc]())
;PRINT(@NoWarning) / comments
Hi Jessica, seems it occurs only if i wrap use a select in the right hand side of the statement assigning the value so I can remove the warning by removing the SELECT keyword.
Example:
IF EXISTS(SE...
Therefore i can remove the warning from MIN/MAX also by not initializing when i declare the variable , but I'd rather keep to the original syntax style
no squiggly line in this example
DECLARE @foo INT
SELECT @foo = (MAX([value].[val]))
FROM (VALUES(1),(2),(3))AS[value]([val])
SELECT @foo / comments
Therefore i can remove the warning from MIN/MAX also by not initializing when i declare the variable , but I'd rather keep to the original syntax style
no squiggly line in this example
DECLARE @foo...
Thanks Jessica I shall add a request : it seems I get the warning even when I and assign a variable to the result of a created scalar function / comments
Thanks Jessica I shall add a request : it seems I get the warning even when I and assign a variable to the result of a created scalar function
It doesn't affect how it runs, it's just an annoyance that distracts from proper issues. Ideally if there are zero issues , there should be zero squiggly lines. Any squiggly lines should be capable of being addressed and then disappearing. / comments
It doesn't affect how it runs, it's just an annoyance that distracts from proper issues. Ideally if there are zero issues , there should be zero squiggly lines. Any squiggly lines should be capable...