Jack I've got a minor article i contributed that...

it's in the comments of hte proc:

--#############################################################################

--if you are going to put this in MASTER, and want it to be able to query

--each database's sys.indexes, you MUST mark...

as usual, it depends....

an inline table value function should perform the same...a multi statement TVF often slows things down...

care tou show us the function to see if we can...

anish, it looks to me like you are truncating your value by at least a couple of characters..., so you would never be able to compare a hash to the...

boris with Profiler running agaisnt my 2008 machine, i'm running this command as a crappy example into a table, which i know will produce a pk violation:

CREATE TABLE [dbo].[MYADDRESS] (...

RENAME is a valid command in Oracle, but not SQL; you have to use the sp_rename procedure in this case.

parthi-1705 (10/27/2010)

---

Any other 3rd party tool can solve this.

Trigger or not good to used on all the tables in the DB

Server side trace may be good for one point of...

mashikoo (10/27/2010)

---

Hi Lowell,

That's exactly what I'm trying to do add a calculated column to create the desired version and leave the original integer data untouched but i don't to Alter...

you can add a calculated column to create the desired version and leave the original integer data untouched; you can do the same in the presentation layer as well.

ie

ALTER TABLE...

sql will...

simply right click...

the easiest way is to ask the other admins "hey did you create that job?"

I just created a job on purpose, and it does not appear in the default trace.

i...

click start, and when programs button is visible, right click on it;

"Open" is the first choice, click that.

a folder opens, drill down inside the Programs folder to where you want...

it's a behavior thing.

a local variable, when you assign something too big, gets truncated.

however an error will occur if you try to insert/update to a table, which has a more...

here's the code to get the first sunday of this month;

the last sunday of the previous month is the same date minus 7 days.

you could change the code to get...