Oops - there's that catch 22!!!!! <;-)

Guess I meant that if I want to get a question answered, the first thing I'll do is pick the right forum before...

Recycling the posts is great because I have seldom seen one that doesn't get answered the second time around...(though at scc.com it's almost as if the members are vying with...

Remi - the only answer those posters deserve is : "GO POST IN THE RIGHT FORUM"...

But you know what I mean right ?!?! I'm sure appropriate filters could be added...

And my 2 Cs...I grew up in India where Education is HUGE & dropping out was NOT AN OPTION - we could've gotten beheaded for that...<;-)

I hear though that with...

that should read...

select * from syscolumns where id =

(select id from sysobjects where name = 'tablename')

If only everything was so simple....

You cannot use @sort directly because variables are only allowed when ordering by an expression referencing a column name......

sp_help is pretty comprehensive...

You can also query the system tables with something like:

select * from syscolumns where id =

(select id from sysobjects where name = )

The table def is certainly needed...but here's something for you to play around with...

select cost =

case

when weight 25 and destination = 'Kenya' then weight * 6.2

when weight...

Should be allowed unless the length of column is set to 1 ???? What other data do you have and what kind of error msg do the users get ?

There's an article on this very topic in today's scc.com - have you read it ?!

http://www.sqlservercentral.com/columnists/kKellenberger/restoringtoapointintime.asp

Never mind - I just googled them - so you're saying that it's cheaper to fly to India - take the course and come back all certified ?!?!?!

I'm curious - who is/are "Koenig in India" ?!?!?!

Here's a link to where you can find more info...

http://www.mssqlcity.com/FAQ/Devel/sp_msforeachdb.htm

Have you tried running an sp_depends against the table to see if anything's changed ?!

:cryisrespect ?!?! I never took it that way Remi.....was just pointing out to Suri that he needs...