Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 13,460 total)

  • RE: SQL Server Port Number Assignments - How To Determine What Number To Use

    just a suggestion, but in the past i've used port 14330 (1433 x 10)

    and also on my current dev machine, that has every version as an instance,

    they use ports...

    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!

    April 15, 2013 at 2:39 pm

    #1606621

  • RE: RFI: what do you do during production instances?

    ugh; sounds more like a "Create a Blame-Thrower Tracking Device" to me;

    I'd try to turn this into a list of the proactive things you've put into place to avoid disasters...

    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!

    April 15, 2013 at 1:01 pm

    #1606592

  • RE: how to query MySQL from SqlServer 2K8R2

    rightontarget (4/15/2013)

    Thank you for replies. Does it matter if I am running 64bit installation of sql server?

    no;when you install MySQL, both providers(32 bit and 64 bit) are installed. there's...

    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!

    April 15, 2013 at 12:02 pm

    #1606564

  • RE: Find client accounts missing a specific service

    jbulldog (4/15/2013)

    Thanks Lowell for the quick reply. But when I altered the code as you presented it the query returned nothing. I would be satisfied if that were the case...

    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!

    April 15, 2013 at 10:49 am

    #1606547

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    you are pretty consistently ignoring the possibility that values might be null.

    You've got to bulletproof your code to consider datatypes (converting int to varchar, for example), where the 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!

    April 15, 2013 at 10:44 am

    #1606545

  • RE: Update query help

    Sean's been very helpful here as well; when you ask strangers for help, you've got to put some effort and thought into it yourself. YOU are the one who has...

    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!

    April 15, 2013 at 10:32 am

    #1606540

  • RE: Update query help

    your sample data really needs to INSERT into your table you posted; all we will really have is whatever you post here; if we cannot simply run it in...

    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!

    April 15, 2013 at 8:15 am

    #1606473

  • RE: Find client accounts missing a specific service

    your outer query has Two WHERe statmeents; the second one should be an AND, i think:

    SELECT

    dbo.ACCOUNT.PORTFOLIO

    FROM dbo.ACCOUNT

    INNER JOIN dbo.SERVICE_JOIN

    ...

    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!

    April 15, 2013 at 7:55 am

    #1606464

  • RE: Update query help

    your question needs the same solution you can see in this link from a couple of days ago:

    if you post DDL and sample data the way you see in that...

    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!

    April 15, 2013 at 7:41 am

    #1606456

  • RE: how to query MySQL from SqlServer 2K8R2

    this thread on SSC is what i have saved, and has been working for me:

    http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

    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!

    April 15, 2013 at 7:24 am

    #1606452

  • RE: view the data from the sysmail_sentitems and sysmail_unsentitems and sysmail_faileditems without giving sysadmin role MSDB databasse

    piliki (4/14/2013)

    waiting for best answers!!!!

    the example i provided actually works; so you will have to provide the specific details of whatever you did.

    a user does nto have any more rights...

    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!

    April 14, 2013 at 3:06 pm

    #1606322

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    SET @body = 'New record '+'''' + @ConfigSetID_Ins + ',' + @Name + ',' --+ @Timestamp

    + ''''+' has been added to '+'CongifSet table in xxxxx'

    you must use CAST...

    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!

    April 12, 2013 at 3:06 pm

    #1606170

  • RE: view the data from the sysmail_sentitems and sysmail_unsentitems and sysmail_faileditems without giving sysadmin role MSDB databasse

    you'll have to make a user for each Windows group or specific login, the rest is the same you would do in any other database: create a role with 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!

    April 12, 2013 at 2:36 pm

    #1606164

  • RE: Any ideas on how to accomplish this one?

    good god that is like the 200th post where we proposed the same solution with only minor differences between our code example!

    you usually beat me to the punch anyway!

    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!

    April 12, 2013 at 1:58 pm

    #1606152

  • RE: Running SQL Profiler Trace on a specific table

    inside the trigger, you can capture the first 4000 chars of the command text:

    inside a trigger, you can do this, (DBCC INPUTUFFER can be used by users agasint their own...

    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!

    April 12, 2013 at 1:56 pm

    #1606150

Viewing 15 posts - 3,646 through 3,660 (of 13,460 total)