Forum Replies Created

Viewing 15 posts - 6,571 through 6,585 (of 13,460 total)

  • RE: Source Control Vs Email -- Are you serious ????

    probably not the same situation Jayanth, but at our shop the developers email code to the DBA all the time...

    but from there the code it tested agaisnt the dev version...

    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!

    October 13, 2011 at 6:44 am

    #1393975

  • RE: witness statement

    doesn't this have to be previewed by your company's attorney before you sign anything? in my shop, a lot of people above me would be involved before i ever...

    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!

    October 12, 2011 at 7:57 pm

    #1393757

  • RE: Datatype from Oracle to SQL

    done something very similar myself when porting our schemas to oracle equivilents.

    i've always used NUMBER(10) for integers;

    and here's the reference i used for my conversions:

    http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/apa.htm

    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!

    October 12, 2011 at 8:09 am

    #1393472

  • RE: Issue with trigger and external DSN connection

    yeah, i think if your fields might be null, you'd get unexpected results, right?

    if you wrap ISNULL into your concat, does it show where the issue lies?

    ...

    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!

    October 12, 2011 at 7:37 am

    #1393429

  • RE: Search for any part of text from list

    part of a name...no, i don't think so.

    you could split the list of names, and do a LIKE or charindex to see if whole words exist, by splitting on 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!

    October 12, 2011 at 6:59 am

    #1393399

  • RE: user can access only that perticular DB

    george sibbald (10/12/2011)

    please don't duplicate post about duplicate posts. It just wastes space on the database

    😀

    but...but...aww...:w00t:

    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!

    October 12, 2011 at 6:41 am

    #1393380

  • RE: user can access only that perticular DB

    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/Topic1189017-1550-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!

    October 12, 2011 at 6:18 am

    #1393367

  • RE: user-name can access only one particular db

    sounds like the login that is tied to the user has sysadmin priviledges by mistake;

    take a look here and make sure that the login only has the public role; if...

    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!

    October 12, 2011 at 6:12 am

    #1393363

  • RE: Sorting: Letters before numbers

    how about this?

    SELECT MerchantID from #tempSort

    ORDER BY CASE

    WHEN LEFT(MerchantID,1) LIKE '%[A-Z]%'

    ...

    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!

    October 11, 2011 at 2:54 pm

    #1393173

  • RE: public role revoke permissions

    there's a number of threads here on SSC where the requirement is to remove public permissions in order to comply and lock down a SQL server to DoD standards (google...

    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!

    October 11, 2011 at 2:48 pm

    #1393163

  • RE: IN list with a variable

    you'll need to grab one of the many split(0 functions that are in the scripts section here on SSC;

    there is a big difference between a varchar that happens to contain...

    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!

    October 11, 2011 at 2:29 pm

    #1393149

  • RE: Multiple inserts with ref. integrity within a transaction

    kazim.raza (10/11/2011)

    Good day all;

    How can I make inserts into all of them while having them within one or more transactions so in case of an exception I can roll...

    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!

    October 11, 2011 at 11:51 am

    #1393029

  • RE: Any help in troubleshooting this sql 2008 enterprise ???????

    AK1516 (10/11/2011)

    A time-out occurred while waiting for buffer latch -- type 4, bp 0000000087FD1780, page 1:6792, stat 0x1fc0010b, database id: 4, allocation unit Id: 72057594041860096, task 0x0000000005A3C508 : 0, waittime...

    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!

    October 11, 2011 at 11:24 am

    #1393018

  • RE: Retrieve the current statement

    this might be tough...if the update fails, i'm not sure you can even capture something in the trigger....if the update executes but touches zero rows, that's a different issue.

    for example,...

    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!

    October 11, 2011 at 9:08 am

    #1392931

  • RE: UnknownTraces Running?

    Lee you've got at least one custom trace, possibly two...

    i built this proc and contributed an article about it to help Reverse Engineer a Server Side Trace.

    this creates a procedure,...

    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!

    October 11, 2011 at 7:31 am

    #1392844

Viewing 15 posts - 6,571 through 6,585 (of 13,460 total)