Forum Replies Created

Viewing 15 posts - 586 through 600 (of 13,460 total)

  • RE: Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

    kudos to you sir, nice job. playing with xquery and xml takes a bit of work!
    I made some trivial changes to the query for the dataset, in order to...

    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 21, 2017 at 10:19 am

    #1934186

  • RE: problem with Database mail:All mails have Unsent status

    Chandan you would probably get better, more specific help if you...

    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 21, 2017 at 7:16 am

    #1934147

  • RE: Fix Orphan Users for All databases

    i think that resetting the database user(s) to match the login is the backwards way to do it; you have to re-do it with every restore.

    i prefer to...

    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 20, 2017 at 8:20 pm

    #1934107

  • RE: Are the posted questions getting worse?

    djj - Monday, March 20, 2017 9:51 AM

    Well, still looking for a job.  However, got an email asking if I would do...

    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 20, 2017 at 10:38 am

    #1934040

  • RE: Are the posted questions getting worse?

    Anyone here who is a Chapter Leader or Volunteer for your local SQL User Group, I'm just taking over the South Florida SQL server User Group, and if you have...

    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 19, 2017 at 6:37 am

    #1933883

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, March 15, 2017 12:50 PM

    Alan.B - Wednesday, March 15, 2017 12:37 PM

    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 15, 2017 at 1:32 pm

    #1933347

  • RE: Are the posted questions getting worse?

    I'm never surprised when this happens; 
    seven months ago, a sharp reader noticed a copy paste of one of mine: i don't care personally, it wasn't rocket science to script...

    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 15, 2017 at 12:56 pm

    #1933340

  • RE: TFS for SSDT 2015

    Only Visual Studio Professional can connect with TFS; so the SSDT or Community Versions cannot use TFS. I've had to go through that issue at my job, everyone had SSDT,...

    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 14, 2017 at 6:09 pm

    #1933165

  • RE: Oracle's OLEDB Provider VS Microsoft OLEDB Provider for Oracle in SSIS

    farooq.md - Tuesday, March 14, 2017 8:01 AM

    Lowell - Tuesday, July 3, 2012 6:16 AM

    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 14, 2017 at 8:14 am

    #1933041

  • RE: MS SQL Licensing

    touching the data via a linked server, in itself, does not violate the license agreement.
     it depends on what the developer is DOING with the data.

    populating dev with...

    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 10, 2017 at 1:33 pm

    #1932790

  • RE: Shared LocalDB .mdf database in Local Network

    after you install, then you probably need to do the following:
    run the SQL configuration tool and enable TCP IP
    enable remote connections on the instance
    Add Logins to your...

    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 10, 2017 at 9:45 am

    #1932765

  • RE: Shared LocalDB .mdf database in Local Network

    SQLLocalDB is a special version of an MDF for SQL, it does not allow remote connections, and only one person can open the file at a time.

    if you...

    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 10, 2017 at 8:37 am

    #1932724

  • RE: How to change the CLR permission_set value from 3(unsafe) to 1(safe)

    you cannot, under any circumstances, change the value in SQL from UNSAFE to anything else.
    you can remove and redesign features in your SQL CLR to NOT use unsafe methods,...

    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 8, 2017 at 2:21 pm

    #1932408

  • RE: capture data changes on tables

    if you need old vs new and also whodunnit information, a trigger it the way to go.

    if you need old vs new, but not whodunnit, Change Data Tracking...

    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 8, 2017 at 2:19 pm

    #1932406

  • RE: Scattered data into single line

    SSRS has a Grouping band, and the MAX function exists in expressions...did you try that yet?

    it's a little hard to help  from the screenshot., so i can only...

    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 8, 2017 at 2:08 pm

    #1932403

Viewing 15 posts - 586 through 600 (of 13,460 total)