SQL Server database programming

Hi! Can it is possible to restore backup of a database from sql server 2005 to sql server 2000 or i need to use DTS for this transformayion. Regrads, Jami *** Sent via Developersdex [link] *** ...

Hi, I am trying to catch a critical error. The code below should deliberately fail as it tries to insert an string into a table attribute. Sure enough the update fails but I can't seem to catch the error ...

Hi, all... I'm involved in a debate with someone over the benefits and pitfalls of stored procedures, versus other methods [mainly, SQL pass-through]. [yes, i know, this has been debated for years] As an applications developer, I use SPs for most database operations, ...

Hello I have a sp where the last statement is a "select * from...." Now can I capture this resultset that is returned , into a table ? (without modifying the sp itself) Something like this ? (this obviously does not work :) ) select into #ttt exec mod_pos_fx_r :) Regards Joe ...

Hi, I have a table which has a column processcd. Is it possible to update the processcd to say 'Y' from 'N' in top 100 rows of that table. Regards, Rajeev ...