Forum Replies Created

Viewing 15 posts - 61 through 75 (of 13,460 total)

  • Reply To: Create Table DDL via TSQL

    you'll want to change the definition of @VbCrLf from VARCHAR(2) to something larger, and like this, maybe?

    and make sure it is not being re-assigned to CHAR(13) + CHAR(10) later.

    you'll end...

    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 15, 2022 at 5:47 pm

    #4088224

  • Reply To: SSRS required services

    this is a typical permissions thing in SSRS.  you want to connect from the server itself, and then add your domain group or domain logon to fix that.

    it follows 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!

    June 6, 2021 at 12:08 pm

    #3892587

  • Reply To: SSRS required services

    on the server that is running the SSRS Service, you should find the Reporting Services Configuration Manager.

    run that, and there is a tab to show you the database it connects...

    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!

    June 5, 2021 at 12:07 pm

    #3892339

  • Reply To: SQL agent failed job report last 24 hours

    it might not be obvious, but the query is assuming a monday thru friday work week.

    so if today is monday, i want errors from Sat + Sun + so far...

    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!

    June 5, 2021 at 12:00 pm

    #3892337

  • Reply To: Lock table for Insert/Update/delete

    SQL will do the locking for you automatically, depending on what you update;

    SQL will figure out if it needs to lock a few rows, pages or even the whole table,...

    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!

    June 4, 2021 at 2:32 pm

    #3892074

  • Reply To: SQL agent failed job report last 24 hours

    ok try this:

    this returns only jobs whos last status was failed.

     

    ignore the extra variables in there, it is an artifact of a process I run that gets the fully qualified...

    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!

    June 4, 2021 at 2:22 pm

    #3892061

  • Reply To: how to get the entire sql statement while sql statment is over 4000 characters

    because of the forum, the two tags i added: < a > and < / a > must have the white space removed. with whitespace, it's not valid xml and...

    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!

    June 4, 2021 at 2:17 pm

    #3892060

  • Reply To: Retrieve AD User details for a given Active Directory User name?

    sure!

    here's a handful of examples.

    you can use the filter to search for exact or like statements, using asterisk as the like character multiple domains,

     

    two of the examples have the examples...

    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!

    June 4, 2021 at 2:11 pm

    #3892059

  • Reply To: how to get the entire sql statement while sql statment is over 4000 characters

    when you get really big strings like that, and want to visualize them in SSMS, you can TRY_CONVERT to xml; then when you click it , it opens in a...

    • This reply was modified 5 years 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!

    June 3, 2021 at 3:18 pm

    #3891501

  • Reply To: SQL agent failed job report last 24 hours

    for the query below, the h.[run_status]  is what determines what was successful/failed/inprogress.

    add the filter to limit it to failed only, and change the date range.

     

    --desc: gets job...

    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!

    June 3, 2021 at 3:07 pm

    #3891497

  • Reply To: Retrieve AD User details for a given Active Directory User name?

    definitely use PowerShell for this;

    here are two examples I use constantly:

    Get-ADGroupMember -Identity "CoolestGroup"  | Out-GridView

    Get-ADUser -Filter {(Name -eq 'steve.jones')} -ResultPageSize 50 -Properties * | 
     ...

    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!

    June 3, 2021 at 2:58 pm

    #3891496

  • Reply To: sp_send_dbmail - Error when passing @query parameter.

    i suspect you are missing two pieces of the puzzle.

    to use database mail, any non-sysadmin active directory user (or more preferably, the AD group they belong to, have to be...

    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!

    March 16, 2021 at 2:49 am

    #3858292

  • Reply To: Cannot Bulk insert - access denied

    the issue is most definitely that the SQL service is running as a local account, and not a domain account.

    SELECT * FROM sys.[dm_server_services]

    when you run any TSQL that accesses a...

    • This reply was modified 5 years, 4 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!

    February 11, 2021 at 7:21 pm

    #3843944

  • Reply To: Polybase

    a few things to check if polybase is not able to start;

     

    on my developer edition box, I had to make sure TCPIP connections were enabled, which is not an issue...

    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!

    December 21, 2020 at 4:58 pm

    #3822896

  • Reply To: Error: Sub report could not be shown

    the stack overflow article mentions bugs in SSRS 2008R2(and maybe SSRS 2012), so the first part does not appear to apply if you are running SSRS 2014.

     

    The second part, where...

    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!

    December 21, 2020 at 2:26 pm

    #3822846

Viewing 15 posts - 61 through 75 (of 13,460 total)