Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 13,460 total)

  • RE: how do we find out cluster environment?

    there's a SERVERPROPERTY function you can use, but do you need to discover that within a TSQL command?

    SELECT 'IsClustered', SERVERPROPERTY('IsClustered')

    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 5, 2012 at 10:16 am

    #1533984

  • RE: Database analisys

    Scott D. Jacobson (9/5/2012)

    I'd start by profiling that process or at the very least that sproc. Look at the execution plan and start optimizing there. What about it...

    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 5, 2012 at 9:27 am

    #1533933

  • RE: Is it possible?

    yes it's possible;you need to use either a GROUP BY, or a sub select with a row_number() function to limit the selections.

    either one can do what you want, depending on...

    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 5, 2012 at 7:29 am

    #1533801

  • RE: sql server table valued function parameter issue

    nzhang6666 (9/5/2012)

    Just found out. The compatible level of the database is set to sql server 2000 (8.0).

    I didn't know function can not be used in parameters of a table valued...

    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 5, 2012 at 6:28 am

    #1533760

  • RE: sql server table valued function parameter issue

    i just tested it in 2008R2, 2005, and compatibility 80.

    the database you are testing in is set for compatibility 80 instead of 90.

    in SQL2000 (80), functions were not allowed, and...

    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 5, 2012 at 6:23 am

    #1533755

  • RE: Save mail files(.msg) from Mail Server using SSIS 2005

    i googled "vb.net read pop3 mail" and got lots of hits for code examples; switch it around if you are more comfortable with C#, but the code is pretty basic.

    I'm...

    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 5, 2012 at 6:18 am

    #1533750

  • RE: Save mail files(.msg) from Mail Server using SSIS 2005

    I've done this in code in vb.net/c#.net, where you pull messages from an SMTP server, and then you can do what you want with them: delete them off the mail...

    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 5, 2012 at 6:03 am

    #1533742

  • RE: sql server table valued function parameter issue

    except for the missing GO statement between the end of the proc and the DECLARE, when i uncomment #2, all three work perfectly.

    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 5, 2012 at 5:59 am

    #1533739

  • RE: Downgrade from 2008R2 to 2008

    ok just downloaded this freeware :

    http://download.cnet.com/Optillect-SQL-Decryptor/3000-10254_4-75300271.html

    i installed it and it decrypts perfectly, without needing the DAC.

    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 5, 2012 at 5:53 am

    #1533736

  • RE: Need SQL server 2008 R2 for the below Database servers with Windows Server 2008 R2 as OS !!!!!!!!!!!!!

    Maximum Number of Processors Supported by the Editions of SQL Server

    From your other thread, you know it's 4 sockets/unlimited cores per socket.

    so if, for YOU, processor=socket then no.

    if processor=core, 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!

    September 5, 2012 at 5:39 am

    #1533729

  • RE: Downgrade from 2008R2 to 2008

    Anthony I've seen executables that decrypt without having to go into the DAC, but When I did the research once before, they seemed to be crippleware to try and get...

    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 5, 2012 at 5:31 am

    #1533727

  • RE: Need SQL server 2008 R2 for the below Database servers with Windows Server 2008 R2 as OS !!!!!!!!!!!!!

    does this help you find what you are looking for?

    http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql2008R2+standard

    KumarSQLDBA (9/5/2012)

    We need SQL server 2008 R2 for the below Database servers with Windows Server 2008 R2 as OS for 2...

    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 5, 2012 at 5:25 am

    #1533725

  • RE: Please Give Me the Query For Below Mentioned Resultant Tables.

    swathi that's a great way to show an alternate solution.

    The only thing that bothers me is that solution only works if there are only 9 categories, 1-9, since you are...

    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 5, 2012 at 5:16 am

    #1533723

  • RE: Orphaned Users

    this is a script i whipped together for a different post;

    it'ts checking for orphans, and generating the scripts to use if you need them for the fix:

    it is using 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 4, 2012 at 2:43 pm

    #1533522

  • RE: Varchar(max) not storing all data

    bindish (9/4/2012)

    You are right as it is storing all data into table and checked with LEN command but in SSMS it is now showing. There is limit to 65535.

    Is...

    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 4, 2012 at 1:12 pm

    #1533478

Viewing 15 posts - 4,786 through 4,800 (of 13,460 total)