Forum Replies Created

Viewing 15 posts - 16 through 30 (of 13,460 total)

  • Reply To: Large posts full of code not allowed anymore?

    attempting to paste 3799 chars into a code block

    DECLARE @MyExample TABLE (ID int identity(1,1),MyRecipe varchar(max),OtherColumns varchar(30) )
    INSERT INTO @MyExample
    SELECT '***DUST MASK MUST BE WORN***
    ENSURE THE PRODUCT CODE...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 5, 2025 at 12:56 pm

    #4681218

  • Reply To: Large posts full of code not allowed anymore?

    Edit: this posted with a code block, so i think the issue is size related.

    yes I've seen the same, effectively, notifications restart again recently, after a long hiatus of just...

    • This reply was modified 6 months, 3 weeks ago by Lowell. Reason: confirming this posted

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 5, 2025 at 11:43 am

    #4681204

  • Reply To: Varchar(max) to lines

    third attempt, without the code: if i paste long replies with lots of code, whether i put it in a code box or not, my reply to the post disappears.

    the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 5, 2025 at 11:28 am

    #4681189

  • Reply To: Connecting to SQL express 2019 server

    I just had another thought, Also in the SQL Configuration Manager  you'll need to change the IPAll and make sure it is not using a dynamic port, and is listening...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 27, 2025 at 1:47 pm

    #4678164

  • Reply To: Connecting to SQL express 2019 server

    by default, SQL Express has tcp disabled, and you have to explicitly enable that in the SQL Configuration Manager, did you do that yet? that's a difference between what we...

    • This reply was modified 7 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 27, 2025 at 10:20 am

    #4678081

  • Reply To: Line number in error message doesn't match up with line number in code

    also note that if a long statement is in use, like WITH MyCTE..... or a cursor, the error returns the first line of the statement, and not the in between...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 21, 2025 at 9:14 am

    #4675623

  • Reply To: how to write this query?

    to me  it looks like a group by query will satisfy it.

    SYMBOL TRADE_DATE Maxt1Level Mint2Level TheLevel

    abc 2025-10-20 2.00000 2.50000 2.00000

    and my query:

    SELECT

    t1.[SYMBOL],

    t1.[TRADE_DATE],

    MAX(t1.[LEVEL]) AS Maxt1Level,

    MIN(t2.[LEVEL]) As Mint2Level,

    ISNULL(MAX(t1.[LEVEL]), MIN(t2.[LEVEL])) AS TheLevel

    FROM #nr_data...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 21, 2025 at 9:11 am

    #4675622

  • Reply To: SQL Server DBA - Immediate need

    I don't see any web site at myblueguru.com.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 8, 2025 at 10:18 am

    #4667662

  • Reply To: RESTORE DATABASE command internal timeout

    i think you might be running the command in an application other than SSMS/sqlcmd or a Sql agent job, right?  a python/PowerShell/dotnet command could potentially create a sql command object...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 1, 2025 at 12:39 pm

    #4663121

  • Reply To: Moving a database from AWS RDS Custom to RDS Standard

    you can backup and restore, too and from an S3 bucket, will that help?

    you need to set up a few things in rds first, and make sure of permissions on...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 1, 2025 at 3:59 pm

    #4644167

  • Reply To: How to resolve issue of custom Audit log table containing incorrect data?

    i suspect you are missing part of a join statement, or have an incorrect logic in your trigger...like joining on parentId, but not ChildId. can you show the definition of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    September 1, 2025 at 3:51 pm

    #4644165

  • Reply To: ssrs subscription file share

    it's the service account that is running the SSRS Service that needs access.

    You'll need to modify the Reporting Services Configuration Manager Subscription settings.

    if the path is a unc path ,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 29, 2025 at 3:37 pm

    #4642756

  • Reply To: Database Mail not working on new SQL Server 2022 instance

    just suggesting to check the basics...database mail has a dependency on dotnet 3.5, which is not installed in an operating system by default, and is easy to mis-remember the dependency....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 27, 2025 at 1:20 pm

    #4641568

  • Reply To: SQL Connectivity

    i think you may have toggled mixed mode authentication, but that setting requires a stop and start of the SQL service, as it is only loaded at that time.

    it will...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 20, 2025 at 1:44 pm

    #4638159

  • Reply To: ODCB error from Linux client

    well dang. i found that SSC is scrubbing my posts if i paste the commands i previously used  in linux.

     

    i had a script in python that worked everywhere in windows,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 15, 2025 at 2:13 pm

    #4635956

Viewing 15 posts - 16 through 30 (of 13,460 total)