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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. suhash

    Web Services: C#

    Guys, Problem solved.. It was my mistake. I hadn't add ASPNET as a user for the database....Sorry Thanks,,,, Mal
  2. suhash

    Web Services: C#

    Hi There, I have a web service (its very simple). In the same solution I have a C# (class) and VB (form). I am using the VB form to check the c# class. Now. I have a web service that expose a c# method. following is the web service code. DBHandle.HandleDB PeerInfo; private int IsPeerValid...
  3. suhash

    Dropping tables

    Hi.. Yep, u are correct, Sorted the problem out. Thanks for your time.. Mal.
  4. suhash

    Dropping tables

    Hi. The error is like: Syntax error near 12. 12 is the name of the table.. Thanks,,
  5. suhash

    DATEDIFF() Function

    Hi I swap the statements, Now it works... Actually it should be the way how stupid i can be sometimes... thanks for pointing out.. Mal.
  6. suhash

    Dropping tables

    Hi Again, I need to drop a table and create a new one on a trigger. CREATE TRIGGER TBL_DEL ON dbo.PeerFileListCollection FOR DELETE AS DECLARE @RecordRemoved nvarchar(10) Declare @TableName nvarchar(10) declare @SQL nvarchar(100) Select @RecordRemoved = (Select PeerID From deleted) set @SQL =...
  7. suhash

    DATEDIFF() Function

    Hi there. I have the following simple procedure. I dont get a value for @Diff. Any Ideas? CREATE PROCEDURE RecordOptimise AS declare @RecordDate datetime declare @TimeNow datetime declare @Diff int Set @TimeNow = GETDATE() select @Diff = DATEDIFF(ss, @RecordDate, @TimeNow) select @RecordDate...
  8. suhash

    How to time out a record? Triggers??

    Hi again, Thanks for the info. Could you direct me to any resources on the web to learn about this please? Thanks.
  9. suhash

    How to time out a record? Triggers??

    Yep. that is what I mean. I have a datetime field in a record. I need to refresh the records every 2 minutes. Can this be done? Mal.
  10. suhash

    How to time out a record? Triggers??

    Hi All, I need to time out a record in a DB. Can I do this via a trigger? Is there anyway to trigger a method every minute or for a give period? Thanks in advance.. Mal.,

Part and Inventory Search

Back
Top