Forum Replies Created

Viewing 15 posts - 11,326 through 11,340 (of 13,460 total)

  • RE: Restore the database to new location

    among the same versions (ie 8.* to any other v8 or 9.* to any other v9) all backups are compatible with the same version..

    so if i backup with SQL2005...

    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 1, 2009 at 7:46 am

    #969828

  • RE: Restore the database to new location

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    http://www.sqlservercentral.com/Forums/Topic687890-357-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 1, 2009 at 7:41 am

    #969823

  • RE: Restore the database to new location

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    http://www.sqlservercentral.com/Forums/Topic687890-357-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 1, 2009 at 7:41 am

    #969822

  • RE: Help with cursors

    i'm still reading your code, but it looks like it is doing nothing more than getting a bunch of links for navigation recursively right?

    i'd like to see the code 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!

    April 1, 2009 at 7:31 am

    #969818

  • RE: stored proc

    both != and <> are "not equal" and are valid operators for SQL server...i used != because the web site sometimes interprets that as html and makes it disappear.

    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 1, 2009 at 6:46 am

    #969780

  • RE: Msg 4902, Level 16, State 1, Line 2 Cannot find the object "" because it does not exist or you do not have permissions.

    did you accidentally run the script on the master database instead of a specific database? or a different database than the one you needed 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!

    April 1, 2009 at 6:40 am

    #969775

  • RE: stored proc

    to do it the hardway, you have to check @@error after each update/insert: each command changes the @@error:

    ALTER procedure MyProc

    As

    BEGIN

    begin transaction

    update1

    if @@error != 0 GOTO Bailout

    update2

    if @@error != 0...

    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 1, 2009 at 6:34 am

    #969772

  • RE: stored proc

    it depends on the scope;

    outside of a stored procedure, if you issue that command, it is for the life of the session/window or until you set XACT_ABORT to OFF;

    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!

    April 1, 2009 at 6:19 am

    #969764

  • RE: USE QCDB_160309

    it really depends...the devil is in the details.

    why are you breaking up related data into two separate servers? This looks like a red flag to me; are you archiving 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!

    April 1, 2009 at 6:15 am

    #969762

  • RE: stored proc

    use a transaction like his:

    SET XACT_ABORT ON --any error, rollback any trnasactions

    BEGIN TRAN

    --do first update

    --second update

    ....

    --last update

    COMMIT TRAN --if there was any error, everything rollsback, no error checking needed

    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 1, 2009 at 5:09 am

    #969728

  • RE: USE DATABSE NAME

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    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 1, 2009 at 5:06 am

    #969725

  • RE: Please help me in Qurey

    syntax wise, your query is fine; you didn't say what the issue is you need help explaining.

    can you tell us what is wrong? does the query fail? do you need...

    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 1, 2009 at 5:01 am

    #969723

  • RE: USE QCDB_160309

    In order to "Use" a server, a connection has to already be established...SSMS does not have any commands that you can use in TSQL to change or modify your connection...so...

    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 1, 2009 at 4:58 am

    #969720

  • RE: "NOT IN" phrase in WHERE clause doesn't work

    yeah when your nose is lost in the details,things like that still ding me once in a while, even after I've worked around it a zillion times.

    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!

    March 31, 2009 at 3:48 pm

    #969529

  • RE: "NOT IN" phrase in WHERE clause doesn't work

    if you use NOT IN, you must exclude the NULLs; anything IN = or LIKE NULL is undefined:

    SELECT * FROM BIG_THINGS

    WHERE THING_ID NOT IN

    (SELECT THING_ID FROM THINGS WHERE THING_ID...

    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!

    March 31, 2009 at 3:33 pm

    #969512

Viewing 15 posts - 11,326 through 11,340 (of 13,460 total)