Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 13,460 total)

  • RE: Trying to determine column dependencies.

    Stamey (7/20/2011)

    I already have code that searches for the column in procs, indexes, and UDFs. My concern is for other objects, such as constraints and primary keys, or rather 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!

    July 20, 2011 at 6:28 am

    #1355524

  • RE: String Concatination - concat many xml column as varchar(max) do not concatinate all columns in resultant column

    test this:

    SELECT DATALENGTH(new_col) AS TOTALLENGTH,

    DATALENGTH(col1) + DATALENGTH(col2) +DATALENGTH(col3) + DATALENGTH(col4) As ShouldBeEqual

    FROM table

    I think you'll find that the data in the table is the right size and is correct; it's...

    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!

    July 19, 2011 at 2:31 pm

    #1355151

  • RE: String Concatination - concat many xml column as varchar(max) do not concatinate all columns in resultant column

    check the datalength() of your results instead of viewing the column;

    I believe for performance sake, no matter what you set the results setting to in SSMS , it displays(at max)...

    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!

    July 19, 2011 at 2:20 pm

    #1355140

  • RE: built in method name

    maybe you are referring to checksum or binary_checksum,

    that method can provide a unique value based on one or more columns of data, but I cannot think anything that does...

    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!

    July 19, 2011 at 12:15 pm

    #1355091

  • RE: undo changes to a stored procedure

    my mistake, the default trace does not capture the textdata, it seems; I assumed it did.

    i created a new database, ran a script that added a table and a suite...

    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!

    July 19, 2011 at 11:31 am

    #1355046

  • RE: undo changes to a stored procedure

    maybe, but doubtful, the default trace might contain the textdata for the ALTER PROCEDURE command the other developer originally did...

    but since the default trace rolls over so quickly, it probably...

    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!

    July 19, 2011 at 11:04 am

    #1355020

  • RE: T-SQL Help needed (Date / Time)

    The only way i can think of to make that work is to use a Calendar table, and also require a table scan because you'd have to check each datetime...

    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!

    July 19, 2011 at 9:31 am

    #1354906

  • RE: Memory Usage

    by design, SQL will use all the memory you care to feed it; so as time goes on, it might keep execution plans longer, since it has the memory 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!

    July 18, 2011 at 1:49 pm

    #1354472

  • RE: Linked server error

    server names with hyphens can be a problem.

    do you get results with this command?

    EXECUTE sp_tables_ex 'cyn-sqr'

    --or

    EXECUTE sp_tables_ex [cyn-sqr]

    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!

    July 18, 2011 at 1:42 pm

    #1354467

  • RE: Linked server error

    what specific error do you get?

    are you trying to connect via a trusted connection, or with a SQL username and password?

    the more details you give, the more we can help!

    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!

    July 18, 2011 at 1:35 pm

    #1354460

  • RE: 2005 ever have an issue with Daylight Savings?

    that's what i thought too, homebrew; i could see that if you didn't apply the DST patch in 2007 on your Windows operating System, where they moved the default DST...

    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!

    July 18, 2011 at 12:41 pm

    #1354432

  • RE: portable pgp issue

    I'm downloading it now, but it's going to be an issue just like you see in a zip file, where you can save the absolutepaths or not as part of...

    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!

    July 18, 2011 at 10:18 am

    #1354317

  • RE: Portable PGP issue

    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/Topic1143507-1526-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!

    July 18, 2011 at 10:16 am

    #1354316

  • RE: Portable PGP issue

    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/Topic1143507-1526-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!

    July 18, 2011 at 10:16 am

    #1354315

  • RE: Global tables..

    what's confusing you is there's no such thing as a global variable table. i know it seems a little intuitive that if two # signs make it global , 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!

    July 18, 2011 at 8:47 am

    #1354273

Viewing 15 posts - 7,126 through 7,140 (of 13,460 total)