the last " is not null or " gets removed from the output which is as per design e.g. the separator is only added if there is a string to...

• This reply was modified 2 years, 9 months ago by frederico_fonseca.

then something you doing not exactly as it is.

I've tried your sql just replacing your function with sys.columns from master db and it works as expected with a total of...

elaborate on ssms limits? have a look at https://stackoverflow.com/questions/64704240/ssms-what-is-the-max-string-size-that-can-be-displayed-in-the-grid-for-varchar

and did you try what I said?

if by not working you mean its not displaying it on SSMS that is "right" - SSMS will not display the full content.

if you wish to see all its content...

smells like the usual lambda spam of "i got this" with a link

if the initial string has no spaces you can use a combination of charindex and substring - you should be able to built something with these 2 functions without the...

Instead of enabling both successful and failed logins - you can configure an audit instead.  The audit can also send the data to the application event log - but...

from what is defined on this manual (you did read it didn't you?) it will not add entries to the log - furthermore you need to explicitly set CDC...

on a diff note - might be good to start looking at options to replace reportviewer (and SSRS altogether) as .net core does not, and according to ms, will not,...

you are mixing serverreport with localreport and I think that is your issue.

from https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-winforms-reportviewer-control?source=recommendations&view=sql-server-ver16

you can see on the local report mode that the parameter is added to the local report...

it may have to do with how you are doing it.

passing parameters is as per manual e.g. "&Parametername=parametervalue" at end of url for report.

https://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

see attached for how it was...

code is a snippet - missing parts which on their own can be wrong.

it is creating a proc with prefix SP_ - this should be avoided.

and its dynamic sql inside...

what is the CTFP on that server? that will also affect it greatly.

I believe your understanding is incorrect.

logical reads are always there - regardless of having a physical read or not, as pages are first read from disk to ram(buffer pool) and...

spam - exact copy of a 10 month old post - https://www.reddit.com/r/dataengineering/comments/snzqty/upskill_azure_data_factory_knowledge/