Forum Replies Created

Viewing 15 posts - 5,491 through 5,505 (of 13,460 total)

  • RE: Sorting AlphaNumeric non standard field

    in a similar situation, i've used a function dbo.StripNonNumeric, which leaves just the string 0-9, which i could convert to an integer;

    then i could do

    ORDER BY

    CONVERT(int,dbo.StripNonNumeric(SomeColumn)),,

    SomeColumn

    As long as you understand...

    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!

    May 15, 2012 at 10:24 am

    #1487853

  • RE: Testing Enterprise Backups

    for testing backup validity, i would think the Developer version (~$50 dollars on Amazon) is ideal; it has all the abilities of the Enterprise version, but is for testing 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!

    May 15, 2012 at 9:52 am

    #1487831

  • RE: Sql Server 2012 can't see 2nd drive

    access denied is due to the account running SQL server.

    To access anything outside of actual databases, SQL uses a different account than you might think it should.

    you will probably want...

    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!

    May 15, 2012 at 8:38 am

    #1487766

  • RE: ODBC SQL Server Driver Error: Invalid object name

    pwalter83 (5/15/2012)

    george sibbald (5/15/2012)

    does the object exist on both servers? Is the owner of the object the same on both servers?

    As far as I know, the login name on both...

    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!

    May 15, 2012 at 8:06 am

    #1487716

  • RE: Retrieving indirectly assigned database roles for an AD user

    there's an extended stored procedure to help you with that situation.

    you can use it to query an iindividual's domain login, or a group from the domain:

    try these out and see...

    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!

    May 14, 2012 at 2:50 pm

    #1487398

  • RE: Customized Log Report requirement

    Only way i see getting those totals would be by using Change data cature on those tables in question.

    Then you can query the cdc schema rltables for the counts

    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!

    May 12, 2012 at 4:26 pm

    #1486804

  • RE: Query Completed with Errors but no error message

    One example i can think of when see that behavior if you ALTER TABLE , and then insert into the table while referencing the new row; to get 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!

    May 11, 2012 at 1:32 pm

    #1486604

  • RE: Format SQL (Pro)

    SQL formatting is important for me, and i tested the RedGate tools, which are really nice, but they were more than I wanted to spend.

    I ended up purchasing "SQL Pretty...

    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!

    May 11, 2012 at 11:12 am

    #1486470

  • RE: Tally table question

    others will certainly do it differently than I do, but I have three different tables for accomplishing Tally-related objectives:

    Tally, which starts with 1,

    TallyCalendar, which is all date related.

    and Numbers, which...

    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!

    May 11, 2012 at 11:04 am

    #1486466

  • RE: Opening & Saving Multiple Trace Files ?

    if it helps, i usually create this temp table, and then insert multiples into it via the script below:

    i don't keep track of the specific file the way Bhuvnesh ...

    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!

    May 11, 2012 at 10:11 am

    #1486434

  • RE: dataset ?

    i see it does fail if your DATEFORAMT is DMY and not MDY: i get the same error you got when i explicitly set my dateformat:

    (/12//16/11 causes the error: no...

    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!

    May 10, 2012 at 9:51 am

    #1485803

  • RE: Database Mail Setup

    ndevr (5/10/2012)

    Hi All,

    I have to check in all the servers, whether Database mail is configured or not ,if not i have to setup the mail, what are the pre requisites...

    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!

    May 10, 2012 at 9:49 am

    #1485800

  • RE: Profiler and Traces are NULL in some Columns

    In addition to what Elliot said, some of the events in your trace will not return all columns;

    if you run this query (change the patch to match your path 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!

    May 10, 2012 at 9:06 am

    #1485766

  • RE: cant create logins in SQL

    this can help:

    http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.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!

    May 9, 2012 at 1:12 pm

    #1485278

  • RE: Convert From Zone times in SQL Server 2008 R2

    sure, the datediff between getdate and getutcdate will giveyou the current offset; that willl be 4 or 5 depedning on whether daylight savings is in effect or not:

    some timezones 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!

    May 9, 2012 at 1:06 pm

    #1485274

Viewing 15 posts - 5,491 through 5,505 (of 13,460 total)