Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 13,460 total)

  • RE: Upgrade a standalone instance to Cluster

    Dj463 (8/22/2011)

    Lowell (8/22/2011)

    Rename the existing SQL123 to, say SQL123CLUSTER

    I think we cannot rename a SQL instance.

    you rename the Server at the operating system/networking level, not the instances themselves.

    any...

    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!

    August 22, 2011 at 1:05 pm

    #1371648

  • RE: Upgrade a standalone instance to Cluster

    wouldn't you simply do the following.

    1. Rename the existing SQL123 to, say SQL123CLUSTER

    2. change the ip address on the SQL123CLUSTER to a different IP address.

    3. enable clustering, and give...

    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!

    August 22, 2011 at 9:50 am

    #1371497

  • RE: replace Nulls with blanks across an entire table

    Ninja's_RGR'us (8/22/2011)

    I would ignore the where completely unless I'd know only a small % of the rows would get updated.

    This will do a table scan anyways. So you might...

    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!

    August 22, 2011 at 9:27 am

    #1371483

  • RE: sp_send_dbmail

    girl_bj0619 (8/22/2011)

    i received an error:

    Invalid object name '##results'.

    the examples above (admittedly they are from 2007) suggested using a global temp table. i base dmy example fof of the previous...

    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!

    August 22, 2011 at 9:25 am

    #1371481

  • RE: sp_send_dbmail

    i think you want to use IF EXISTS:

    IF EXISTS (select * from ##result)

    BEGIN

    EXEC msdb.dbo.sp_send_dbmail

    @recipients=N'emailaddress',

    @body='The IP address with over...

    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!

    August 22, 2011 at 9:16 am

    #1371472

  • RE: replace Nulls with blanks across an entire table

    nope not possible. a column must be identified, and it's new value identified for a valid UPDATE TABLE statement.

    ...but...you can use the table's metadata to generate the commands for you.

    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!

    August 22, 2011 at 9:13 am

    #1371470

  • RE: deleting autocreated statistics?

    my advice is you are looking for a problem that does not exist. leave the statistics alone, and update them often.

    statistics are used by the system to find 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!

    August 22, 2011 at 8:30 am

    #1371442

  • RE: i want out of sp_helplogin sp into table

    shilpa.shankar87 (8/22/2011)

    Msg 2760, Level 16, State 1, Procedure sp_helplogins_2, Line 460

    The specified schema name "sys" either does not exist or you do not have permission to use it.

    Im getting above...

    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!

    August 22, 2011 at 5:49 am

    #1371353

  • RE: How to create a index view for a table residing on other database

    nope, no non-clustered indexes either

    indexes must always point to an object within a given database.....but the original table in the original database can have indexes up the wazoo. if they...

    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!

    August 19, 2011 at 2:01 pm

    #1370964

  • RE: newby wants to create a sequencial Alpha numeric value

    glad that my example got you thinking!

    that one's from an old post where someone wanted ranges from like AA001,AA002,AA003 thru ZZ999

    the table under that i tested for AAA0001 thru ZZZ9999,...

    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!

    August 19, 2011 at 12:25 pm

    #1370939

  • RE: Generate dynamic script

    probably easiest to simply change the cursor to filter on only the databases that are not in SIMPLe recovery already

    change the cursor definition to this:

    declare c1 cursor for

    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!

    August 19, 2011 at 12:18 pm

    #1370934

  • RE: Generate dynamic script

    here's something i use on my dev server...don't need anything in FULL recovery mode on that server at all...it's a play ground.:

    USE MASTER

    declare

    @isql varchar(2000),

    @dbname varchar(64)

    declare c1 cursor for select name...

    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!

    August 19, 2011 at 11:44 am

    #1370923

  • RE: How often to update Statistics

    in my case, I have a couple of tables i need to update statistics on a couple of times a day in order to assure good performance.

    Typically you really 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!

    August 19, 2011 at 11:35 am

    #1370918

  • RE: How to create a index view for a table residing on other database

    can't be done.

    by definition, an indexed view creates an index on an object in the database, so it becomes materialized as if it were a table, and 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!

    August 19, 2011 at 10:52 am

    #1370902

  • RE: Insert data from a text file document into a SQL table

    JT-328471 (8/19/2011)

    Sorry, what I meant was you aren't defining your rowterminator. Use a \ n (remove spaces)

    he probably pasted it right...the forum here strips out \n unless you html-ize...

    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!

    August 19, 2011 at 10:24 am

    #1370884

Viewing 15 posts - 6,901 through 6,915 (of 13,460 total)