Forum Replies Created

Viewing 15 posts - 6,556 through 6,570 (of 13,460 total)

  • RE: Retrieve the Message part of a stored proc?

    the Connection Object in ADODB that you create has an Errors collection, which includes the print statements, "rows affected" as well as anytime you called RAISERROR i believe.

    print...

    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 14, 2011 at 7:38 am

    #1394641

  • RE: SQL Script

    DO NOT USE THIS ON PRODUCTION.

    it builds a TABLE SCAN for every table which happens to contain a varchar/char/nvarchar/nchar type column.

    a millionBillionRow table could cause this to gobble up some...

    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 14, 2011 at 7:23 am

    #1394636

  • RE: Finding the column containing the minimum value

    i'm an ID-TEN-T;

    i looked at jsu tthe execution plan for the setup table variable...of course they are the same...once i scrolled down, i saw differences.

    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 14, 2011 at 6:53 am

    #1394617

  • RE: Finding the column containing the minimum value

    maybe it's just me, but both my solution and Chris's seem to produce the exact same execution plan?, but Chris's is 48% relative to the batch where mine was...

    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 14, 2011 at 6:42 am

    #1394607

  • RE: Finding the column containing the minimum value

    Phil the only way i could see it was to use a case statement that evaluates each column;

    this works, but i don't know how it will perform on large 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 14, 2011 at 6:27 am

    #1394597

  • RE: Moving a db to different Windows versions

    you'll want to export your logins from the old box to the new one. the procedure sp_help_revlogin from Microsoft will do that for you .

    run it on the old server,...

    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 14, 2011 at 5:10 am

    #1394558

  • RE: Allowing 1 login to login only once and deny other login attempts

    Mo' (10/14/2011)

    Thanks dude...

    I did not realize that ORIGINAL_LOGIN() was the user calling for authentication...

    I understand all the code.. with the exception for the last 3 lines..

    ENABLE TRIGGER...

    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 14, 2011 at 4:38 am

    #1394534

  • RE: Allowing 1 login to login only once and deny other login attempts

    this one is tougher for me to test...at home i don't have another machine to connect to to test.

    i think you might have issues if you don't grant permissions 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!

    October 13, 2011 at 5:34 pm

    #1394406

  • RE: Error Trying to Change SQL user login

    phil 80558 (10/13/2011)

    Thanks for the reply. No I'm not using SMMS 2005. It's all SQLServer 2008. WHy would a simple query to change a login password generate this error. 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!

    October 13, 2011 at 11:49 am

    #1394272

  • RE: Can I close port 1433 and 1434 for IIS page delivery?

    are you sure you mean SQL injection?

    SQL injection happens whenan app or a web page accepts input from the page without parameters or data cleansing...building a string like "SELECT...

    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 13, 2011 at 11:46 am

    #1394270

  • RE: Help with Chagne report

    the key is to full outer join the tables,a dn to then handle the nulls.

    how does this work for you?

    SELECT o. Id,

    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!

    October 13, 2011 at 11:19 am

    #1394249

  • RE: Error Trying to Change SQL user login

    in SQL SErver Management Studio you are using...do help...About..

    coul,d you be using 2005 SSMS when connecting to that 2008 instance?

    i've seen issues where differences between GUI(and the 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!

    October 13, 2011 at 11:03 am

    #1394226

  • RE: Help with Chagne report

    you need to simply join the two tables on the id , i think;

    CREATE TABLE #TableA (

    id int,

    name varchar(30),

    version varchar(30),

    disposition varchar(30) )

    CREATE TABLE #TableB (

    id int,

    name varchar(30),

    version varchar(30),

    disposition varchar(30) )

    INSERT...

    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 13, 2011 at 10:43 am

    #1394212

  • RE: IN list with a variable

    Ninja's_RGR'us (10/13/2011)

    @pveilleux

    Nice rant.

    @jc-2 (not short for Jesus-Christ).

    You were doing some headway lately but now you're getting back to your old habits. Plz keep up the <previous> good work.

    agreed.

    @pveilleux 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!

    October 13, 2011 at 8:02 am

    #1394036

  • RE: How to implement a constraint over multiple rows

    you guys completely forgot that you can use a check constraint that uses a user defined function...and that UDF can check mutiple columns, rows, values, other tables, whatever.

    i've done several...

    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 13, 2011 at 7:12 am

    #1393994

Viewing 15 posts - 6,556 through 6,570 (of 13,460 total)