Just join them the way you want:

--OLD CODE:

select * from INFORMATION_SCHEMA.COLUMNS

--NEW CODE

select * from sys.tables

select * from sys.columns

select * from sys.indexes

and there are planty more sys.* to query from. Have...

Since I'm here to, also, learn from others, and you got many points ahead of me - I'm certain there ARE ways to do that. From my very own narrow...

Totally agree with you. A better definition would be 'not-so-up-to-date' and not 'inaccurate' as in wrong...

If I got it right, thst's what you need. If the 'select' is OK then put it in the INSERT statement.

I also changed your sample code to allow us...

This is the whole idea, man...

Although called 'OLAP' (OL stands for ON-LINE), cubes are made for heavy calculations not made in real-time but rather trade accuracy for performance...

You can schedule...

How about this one:

SELECT

CAST(CTEXT AS NVARCHAR(MAX))

FROM

SYSCOMMENTS

WHERE

OBJECT_NAME(ID) = 'YOUR_STORED_PROCEDURE_NAME_HERE'

Since you didn't post any sample data script I made you a little sample that'll work on any DB. On large tables I use another trick, using XML variables, but...

Any chances you are running virtual machine?

As usual, I jumped into the database design issue, overlooking your initial request:

Maybe yuo'll find...

The way I see it, a family tree is a tree. And in trees, you should only keep the parent's id in the record...Why would you want to specifiy the...

Welcome...

I guess you'll have to post some more details if you want us to help: What is your table structure, how is the security column being populated, how many records...

Well, it really depends on how complicated your data is and what kind of work your triggers do.

I, personally, have been avoiding triggers in the past 12 years. I like...

Agree with all comments.

Notes taken.

Thanks

Haven't bumped into this issue for a few years (although nvarchar(max) is much newer), but I'll try some old NText solutions we used to use:

1. Update your MDAC libraries to...

Have you tried looking at the internal noise word list, called noise.dat?

I think it's under:

C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\config