Forum Replies Created

Viewing 15 posts - 8,761 through 8,775 (of 13,460 total)

  • RE: Does anyone have a SQL procedure to delete ALL records in a DB ?

    another version, this with some exclusions, since when someone says "del3ete everything" , they never think it through,a nd afterwards the say "well i mean everything except the lookup tables,...

    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!

    September 13, 2010 at 8:54 am

    #1220118

  • RE: Recover master DB with mssql 2005, sp2

    rob.shaw (9/13/2010)

    Hi Lowell,

    Thanks for your speedy response once again.

    I'm probably not making myself clear here. The fact that a "bare-metal" restore has been done means that all the SQL binaries...

    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!

    September 13, 2010 at 8:47 am

    #1220103

  • RE: Recover master DB with mssql 2005, sp2

    rob.shaw (9/13/2010)

    Hi Lowell,

    Thanks for your input to my problem.

    The problem I have is not restoring the master database, but rebuilding it. As I am doing a bare-metal recovery, everything 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!

    September 13, 2010 at 7:32 am

    #1220035

  • RE: Oracle SQL Plus syntax

    Tom Brown (9/13/2010)

    I'm used to SQL Server. Oracle syntax is a bit different. I have Oracle SQL Plus (v9). I've solved most of my problems but need help...

    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!

    September 13, 2010 at 6:14 am

    #1219978

  • RE: Error on SQL Statement

    auto_increment is access or mysql syntax i think it's not mapped to the SQL equivalent of IDENTITY when you run it in SSMS; simply replace that with IDENTITY(1,1) and 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!

    September 13, 2010 at 4:44 am

    #1219946

  • RE: Recover master DB with mssql 2005, sp2

    rob take a look at this thread on the same issue:

    RE: Restoring Master database different versions of same service pack

    in that thread, i stated that there is nothing of critical...

    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!

    September 13, 2010 at 4:29 am

    #1219939

  • RE: Sp_send_dbmail

    that only happens if you run the statement in tempdb. those are real object names, but they were dynamically created by SQL;lots of object names in temp start like that:

    from...

    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!

    September 13, 2010 at 4:17 am

    #1219935

  • RE: CHARINDEX manipulation

    charindex returns the starting position of one item.

    to find two items, you need two searches;

    CHARINDEX ( ' emergency',CommentColumn) > 0 OR CHARINDEX( 'not secure',CommentColumn) > 0

    more likely, 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!

    September 13, 2010 at 4:10 am

    #1219930

  • RE: Sp_send_dbmail

    another possbility is to bcp the query to disk, then open it up and find/replace the delimiter(tab,comma?) with </td><td> and replace all CrLf with </tr><tr>;

    append the leading and trailing table...

    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!

    September 13, 2010 at 3:54 am

    #1219925

  • RE: Sp_send_dbmail

    personally, i like queries as attachments;

    at one point, i know i wanted all the data in the html of the email, so i build a simple CLR that formatted 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!

    September 13, 2010 at 3:51 am

    #1219924

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/12/2010)

    Alvin Ramard (9/12/2010)

    Gail, you might want to bring a certain piece of steel with you if you go revisit that BIT datatype thread.

    That OP is now on my...

    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!

    September 12, 2010 at 5:27 pm

    #1219794

  • RE: xp_cmdshell move error

    did your cursor just create the file prior to moving it? it's quite possible that the command to create the file was issued, and the disk sub system is still...

    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!

    September 12, 2010 at 5:10 pm

    #1219792

  • RE: Unexpected Columns being set to NULL with record updates

    is this happening directly in a SQl statement run in SSMS, or are you using something else?

    for example, if you are using a typed dataset in .net, which includes...

    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!

    September 12, 2010 at 3:57 am

    #1219698

  • RE: Creating A View within an IF statement

    rbaskett (9/10/2010)

    Dynamic sql works, just curious why pos (plain old sql) doesnt

    it's the compiler rules...you've probably seen it:

    Msg 111, Level 15, State 1, Line 57

    'CREATE VIEW' must be the first...

    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!

    September 10, 2010 at 1:49 pm

    #1219459

  • RE: LEFT OUTER JOIN IN TEMPORARY TABLE

    data format nazi

    no solution for you!

    i guess i'm feeling generous;

    I didn't even bother looking at the request, as the lack of consumable data was as far as i cared 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!

    September 10, 2010 at 1:25 pm

    #1219437

Viewing 15 posts - 8,761 through 8,775 (of 13,460 total)