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...

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...

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)...

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...

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...

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...

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...

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...

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]

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!

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...

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...

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

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

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...