Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 13,460 total)

  • RE: SQL Server Agent 'raiserror' question

    not finding data does not sound like an "error" to me in this case, so raiserror is probably no what you really want.

    i think you just want to send an...

    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!

    January 28, 2015 at 10:02 am

    #1773748

  • RE: Is the DELETION of a SQL Server 2008R2 database logged anwhere?

    Siberian Khatru (1/28/2015)

    GilaMonster (1/28/2015)

    Should be in the default trace, but that's only 5 files of 20MB, it gets overwritten quickly.

    Pardon my ignorance (I'm still learning) but what is the "default...

    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!

    January 28, 2015 at 9:27 am

    #1773734

  • RE: IF 0.00 then make it .00

    krypto69 (1/28/2015)

    Thanks Lowell That worked perfectly.

    Just curious why must that be converted to varchar?

    it's the datatype.

    by definition decimals or floats are represented by at least once digit left of it'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!

    January 28, 2015 at 9:16 am

    #1773727

  • RE: Switching from one database to another within the same script.

    the issue is scope: the use statmetn is valid only for the contents of the EXEC command.

    ALL the statements have to be in the full exec command; once it finishes,...

    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!

    January 28, 2015 at 7:58 am

    #1773694

  • RE: IF 0.00 then make it .00

    you'd have to convert to varchar, are you sure that's what you want?

    ACTLABCOST = 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!

    January 28, 2015 at 7:52 am

    #1773692

  • RE: my trigger does not update datetime?

    isn't there an implied extra join(Cross join?) , because you aliased the table?

    --because you aliased the table as p, isn't this an implied extra table gets auto joined?

    UPDATE dbo.ProductsL1

    SET...

    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!

    January 27, 2015 at 10:50 am

    #1773441

  • RE: Create Script of all indexes in a Database

    Lynn Hendricks (1/27/2015)

    I was looking for the same script, had a hard drive malfunction(with no backup) and lost my script library. so instead of reinventing the wheel.

    anywho... I am getting...

    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!

    January 27, 2015 at 10:21 am

    #1773437

  • RE: Challenge with trigger to send email, including attached file. @query needs variables...

    first a redesign; there is no reason to put this in a trigger. if the trigger fails, your data disappears because the transaction gets rolled back.

    the second issue is 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!

    January 27, 2015 at 9:44 am

    #1773423

  • RE: Create Linked Server for firebird

    i guess i was expecting to see a different driver, and it should be the one that is specific to firebird, and not the microsoft driver:

    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!

    January 26, 2015 at 7:48 am

    #1773108

  • RE: Which of these indexes should be deleted?

    darn i missed the link too!, here it is expanded out instead of aliased:

    Phil Parkin (1/26/2015)

    sm_iransoftware (1/26/2015)

    Then what is the best way to get Unused indexes?

    A brief search suggested...

    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!

    January 26, 2015 at 7:00 am

    #1773090

  • RE: Create Linked Server for firebird

    you say you installed the firebird odbc, but the error message clearly says you are using MSDASQL and not LCBI.IBProvider.3, so offhand, i'd say you should script your linked 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!

    January 26, 2015 at 6:57 am

    #1773089

  • RE: how to backup and restore only a table?

    if the two servers are on the same network, you could use a linked server and 4 part naming conventions to pull the data; easily the fastest way, assuming 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!

    January 22, 2015 at 3:36 pm

    #1772429

  • RE: SSRS development and production environment

    yes you can.

    export the encryption key from your existing SSRS service, and then restore the encryption key on the new one.

    backup both the ReportServer and ReportServerTempDb databases, and resotre then...

    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!

    January 21, 2015 at 12:37 pm

    #1771955

  • RE: Altering table to change datatype

    as long as you due your due diligence, and check to make sure you won't have any data conversion errors, you'd be ok;

    here's a quick example: if you radaptation of...

    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!

    January 21, 2015 at 11:47 am

    #1771950

  • RE: Execute SQL Task - how to ignore error

    remove the GO statements.

    GO statments are not a SQL command, but instead something that SQL Server Management Studio uses to split batches.

    also, i'd recommend bullet proofing your code like this...

    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!

    January 21, 2015 at 11:10 am

    #1771941

Viewing 15 posts - 2,071 through 2,085 (of 13,460 total)