Forum Replies Created

Viewing 15 posts - 12,106 through 12,120 (of 13,460 total)

  • RE: Failing To Copy DB From One Machine To Another

    SQL ORACLE is right...since "sa" never logs into the domain, it has no access to the computers and shares that exist on the network.

    you'll have a similar issue 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!

    February 26, 2008 at 11:53 am

    #782170

  • RE: Ideas for SQLServerCentral.com

    I love SSC, and wander through it nearly every day .

    things i'd like to see:

    Something we had at one time, that was snipped out in the new design:

    under "Recent Posts"...

    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!

    February 26, 2008 at 10:38 am

    #782111

  • RE: retrieving duplicate consecutive records.

    that goes back to my original assumption...you said consecutive, and i stated my solution would work If you meant consecutive by the PK of the table...now you've changed the rules....

    now...

    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!

    February 26, 2008 at 7:56 am

    #782004

  • RE: retrieving duplicate consecutive records.

    my example still finds all suspected records...try it.

    here's your statements cleaned up so they work:

    the idea is joining the table on itself in order to do the comparison

    --===== Create 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!

    February 26, 2008 at 5:12 am

    #781927

  • RE: text data type Column 'c.Comments' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

    well, text all the other blob typea are not allowed, but you can cast/convert to a varchar(8000) in order to work around it: this is typically what i would do:

    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!

    February 25, 2008 at 9:37 am

    #781630

  • RE: Legal / Illegal XML Characters list

    here's the function:

    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!

    February 25, 2008 at 8:22 am

    #781573

  • RE: Legal / Illegal XML Characters list

    I tripped over that issue as well;

    below I pasted a function i made for encoding "illegal" characters, it might help you out to clean up the data, or get 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!

    February 25, 2008 at 8:17 am

    #781568

  • RE: retrieving duplicate consecutive records.

    ok, I'm assuming that by consecutive, you mean that the PK is an identity field, and that if you self join the table on itself by way of PK =...

    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!

    February 25, 2008 at 7:45 am

    #781550

  • RE: I need to remove the identity property on a column

    behind the scenes, the GUI is creating a new table, then dropping the constraints on the old table,

    dropping the table, renaming the new table to the proper name, 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!

    February 25, 2008 at 7:29 am

    #781544

  • RE: Finding IP through T-SQL

    connections are not really handled by SQL server, but usernames/passwords/spids, once a conenction has been made is auditable.

    If you need to know who is connecting by IP, you should capture...

    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!

    February 19, 2008 at 4:49 pm

    #779989

  • RE: Executing a system stored procedure and putting results into a table

    yeah that binary AND-ING of a value isn't obvious;

    basically, a binary array of zeros and ones, representing like 2^16 or something is used in status to keep track of 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!

    February 13, 2008 at 12:13 pm

    #778004

  • RE: Executing a system stored procedure and putting results into a table

    I have this laying around from a post i replied to previously: it does all the databases in one shot on a server, instead of calling sp_dboption repeatedly:

    select name as...

    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!

    February 13, 2008 at 11:38 am

    #777989

  • RE: Cross database dependencies on surrogate key

    I agree, it's a poor idea. It sounds more like the DBA gets confused with seeing thousands of tables, and to make it more "bitesize" he wants to move...

    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!

    February 13, 2008 at 5:23 am

    #777757

  • RE: Begin tran /commit tran question.

    the Command SET XACT_ABORT ON makes error handling superfoulous.

    This command rolls back the transaction, AND DISCONTINUES FURTHER PROCESSING, if any error is encountered....

    so if any error is encountere,d it would...

    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!

    February 12, 2008 at 9:25 pm

    #777673

  • RE: Help with formating

    I do something kind of similar using the SPACE function to reserve a certain amount of space in a string; I used a default of 20 in this example, but...

    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!

    February 12, 2008 at 10:03 am

    #777417

Viewing 15 posts - 12,106 through 12,120 (of 13,460 total)