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 MikeeOK 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 cags
-
Timeout Expired
hi I am trying to run a long stored procedure(approx 2 minutes) from an asp page which should then go on to display the returning values (about 4400 rows worth)...when I run it and capture the error, I get 2147217871 - timeout expired. Anyone know how to fix this?- cags
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
RE: permissions to sysobjects
hi thanks for responding. It is the ID field I am trying to get at.- cags
- Post #3
- Forum: Microsoft SQL Server: Programming
-
RE: permissions to sysobjects
I am trying to put a reference contraint to a feild in sysobjects from one of my user tables. I have tried grant references on sysobjects to username in Query Analyzer whilst connected as sa but it just says that granted priveldge REFERENCES is not compatible with this object. Anyone know how to...- cags
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
