Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 13,460 total)

  • RE: Presentation Software Recommendations

    Powerpoint is a part of it, but its not the conductor for me.

    At least in my case, its because only portion of the media is static prior 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!

    November 14, 2015 at 8:07 am

    #1839809

  • RE: Presentation Software Recommendations

    Eirikur no i never did;

    i continued working with the vertical scroller in winforms application i had put together into myself, and toggled between powerpoint presentations and my scroller; i never...

    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 13, 2015 at 11:51 am

    #1839686

  • RE: Run a query against registered servers and insert results into table

    mhorner 67968 (11/12/2015)

    I'm using PowerShell as well but not with the CMS. How does that work? I'd be appreciative of that information and a copy of your script 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!

    November 12, 2015 at 12:42 pm

    #1839491

  • RE: How to Install and Configure Baseline Collecor Solution V2

    just installed it, and will report back what i think; very pleased to see a fire and forget solution.

    my initial thoughts were that the jobs and schedules should be either...

    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 12, 2015 at 6:06 am

    #1839331

  • RE: 4 Queries Required Very Urgent

    if you go to http://sqlfiddle.com/ you can create and test a suite of commands, without having SQL installed; it's basically a syntax checker and pass through page that gets 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!

    November 12, 2015 at 5:44 am

    #1839324

  • RE: sysobjects id field value limit reached (INT)

    could you be misinterpreting object_id as an identity column in sys.objects?

    sysobjects get an id based on an increment of some weird number which i didn't remember but could find 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!

    November 11, 2015 at 1:06 pm

    #1839205

  • RE: Failed to initialize sqlcmd library with error number -2147467259

    cor_perlee (11/11/2015)

    When I run

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'Rapportage',

    @recipients = 'dba@unit4.com',

    @query = 'select * from UNIT4_BEHEER.DBO.ClusterActiveNode',

    @query_result_header = 0,

    @exclude_query_output...

    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 11, 2015 at 10:27 am

    #1839165

  • RE: Failed to initialize sqlcmd library with error number -2147467259

    you are missing required parameters, i think.

    if you declare a query is going to be attached, you have to have a file name.

    EXEC msdb.dbo.sp_send_dbmail @recipients='SQL@SQL.COM',

    @subject =...

    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 11, 2015 at 6:32 am

    #1839083

  • RE: GLOBAL TEMP TABLE OPTION ?

    ok i see what you are talking about now;Test/QA/Prod are all on the same box, it looks like.

    let me throw some ideas;

    can you modify the temp table to 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!

    November 9, 2015 at 2:14 pm

    #1838696

  • RE: GLOBAL TEMP TABLE OPTION ?

    I saw your other thread where your global temp table was intermittently getting dropped....

    i would suggest simply creating a real, permanent table. maybe in your production db to avoid permissions...

    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 9, 2015 at 1:27 pm

    #1838677

  • RE: SSMS does not see my NAS

    since it's not physically attached, you have to jump through some hoops.

    if you search for "map network drive for all users" you'll see the issue: shared drives ar eper user,...

    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 9, 2015 at 11:28 am

    #1838640

  • RE: Alter DB modify log file.

    the script provided just generates the commands, soy uo can review them easily.

    you'd want to run the results of the commands, or stick them into a variable as a stack...

    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 9, 2015 at 10:27 am

    #1838617

  • RE: SSMS does not see my NAS

    is your server clustered?

    In that case, SQL can only see shared clustered drives.

    if it's a plain old vanilla server, are you using a mapped drive? could the drive mapping 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!

    November 9, 2015 at 10:23 am

    #1838616

  • RE: Tracing a user back to a login, where that login is an AD group

    chuck i'm not a login on any server, i inherit from a group called mydomain\SQL-DBA, nad my name appears in the results of the script i provided.

    you should be able...

    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 9, 2015 at 9:50 am

    #1838608

  • RE: MERGE does not work on SQL 2012

    it looks to me that you are merging into GiftCard, and not GiftCard_Transactions. the balance does not belong int he Gift Card table.

    there's only one card, heck i'd think it...

    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 9, 2015 at 5:32 am

    #1838515

Viewing 15 posts - 1,381 through 1,395 (of 13,460 total)