I can't stop myself to say, that this editorial was such a nice one, that allowed so many of us to thank our beloved heroes.

give me the address, I will...

Swami Vivekananda!

I never saw him, He definitely died before I was born.

But he impressed me so much. Even today I get inspiration

just by thinking about him. The power he had,...

this is exactly what is happening

http://www.sqlservercentral.com/columnists/kjambu/2762.asp

Events: Stored Procedures -> SP:Starting

Filters: TextData -> Like - usp_%

On Filters tab: Select the checkbox: Exclue System IDs

this should get only the SPs being executed whose names start with "usp_"

in...

yes ofcourse

i agree this could be handled in your programming logic as well easily

--ddl and dml

drop table t1

create table t1(f1 tinyint)

select * from t1

--the stored procedure

alter procedure ErrorHandler

as

begin   

 declare @TrappedError int

 --TRY

    INSERT INTO t1 (f1)

    SELECT CAST('257' AS tinyint) AS f1;

 SET @TrappedError =...

got you. if that is the case, normalization is not the answer. A control file(table) is the answer.

Values that are out of range are much more of a problem and checking would not be helped by normalization.

it would help rosedd. Values that should be in a specific...

At a very high level OLTP applications benefit

from normalized data, while OLAP applications

benefit from denormalized data.

I am fortunate to have had the experience of

moving from flat file COBOL mainframe era...

It works for me and it's where I have a strong skill set. Steve.

I intially started off with dBaseIII+, Clipper and FoxPro, Then grew with Oracle from version 5 to...

Thankz Pascal,

I agree with you. I should not have used

any tool and made the write up on explaining Data Modeling.

I just thought I can be of some help to

new...

I fully agree that ERWIN is not an all in all tool.

Also this is not a product review.

I am just showing how to build a Data Model, specifically

focussing on 'Forward...

Robert, while i agree every bit with you on ERWIN and ERStudio.

Specifically the subject area feature in ERWIN is very nice to handle logical portions of the diagram. ER Studio...

my 2 cents...

not isnumeric just means, it could be any other datatype other than numeric. Does not necessarily mean varchar. As an example try this on the table I am...

Environment tested on: Windows XP Pro and SQL Server 2000

Step 1

======

Create the following text file c:\whatever\SourceTextFile.txt

Da123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456

78901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234

56789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234567890123456789012

345678901234567890********

Db123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456

78901234567890123456789012345678901234567890123456789012345678901234567890-D1-------1234567890123456789012345678901234

56789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234567890123456789012

345678901234567890********

Dc123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456

78901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234

56789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234567890123456789012

345678901234567890********

Dd123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456

78901234567890123456789012345678901234567890123456789012345678901234567890-D1-------1234567890123456789012345678901234

56789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234567890123456789012

345678901234567890********

De123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456

78901234567890123456789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234

56789012345678901234567890123456789012345678901234567890----------1234567890123456789012345678901234567890123456789012

345678901234567890********

Note there are 5 records of 380 chars length

record 2 and 4 have the 'D1'...