Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by chajadan
-
removing table defaults
Thanks!! This is the one that worked for me: alter table thisone drop constraint DF__thisone__field1__6A30C649 It's nice to finally be able to delete a little field :-D --chajadan- chajadan
- Post #6
- Forum: Microsoft SQL Server: Programming
-
removing table defaults
Doesn't work. I get this: The default 'DF__thisone__field2__100496D2' cannot be dropped because it is bound to one or more column. Every time I try to use sp_unbindefault I get an error message. I guess that would mean I'm not doing it right. But so for now, I'm not much further. Thanks for...- chajadan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
removing table defaults
Often times, when I create a table, I supply a default: "create table thisone (field1 int default 0, field2 char(2) default 'ed')" etc... But at any point if I want to remove a field that I put a default on I get an error. Here's what I'd get if I tried to removed field2: "The...- chajadan
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Optimize your code
I cache data as well, but I don't use application variables to do it, since there is more than I really want to cache. I have some data that regularly changes, but not in any significant way. So once an hour, the information is refreshed, or sometimes two or three hours later. It's refreshed...- chajadan
- Post #8
- Forum: Microsoft: ASP (Active Server Pages)
