i totally agree !

well. maybe not fired right away.. BUT.. come perfomance review time, you got issues.. 

 i havent had any issues yet, i applied it to in development ...

found the resoloution to the problem.. known bug in SQL Server. had to force the use of TCP/IP instead of NAMED PIPES and error goes away...

Check out this...

ok.. checked the logs. no indication of the problem BUT i was running the proc from my workstation when i got the error, used our treminal services and got onto...

david, i think this is going to have to be dynamic SQL statement.

set @srt = 'update table1 set ' + @month + ' = null....blah blah...'

exec(@str)

thanks.. thats what i thought but wasnt sure..

thanks !  thats what i was thinking but wasnt really sure...

thanks

i found this on this sites SCRIPTS area.. if this is not what you want you should check it out...

Find Constraints on a table

By: rubakuma

This script would help...

thanks all, thats what i needed ...

i cant compare it to xpress BUT if its between QA and InterDev, i like InterDev for the simeple fact that i can STEP thru my stored procc line at...

Guys.. for me i really like using Visual InterDev 6.0 with VSS intergration. i can debug and step thru procs and query tables.. and everything i need...

Sorry !! Config = SQL Server 2000 / o/s = win 2k server. and yes i have outlook 2k mail installed on the server. and it uses a...

good monday morning ?!?

i have changed the CDONTS to CDOSYS and still nothing, i have the correct copy of the proc on the server. i can ping the...

how much $$$$$$ whats the range ?