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: *

  • Users: zeeshan13
  • Order by date
  1. zeeshan13

    Retrieving a deleted stored procedure

    Still waiting for any feed back on this. Let put my problem again: I modified a existing stored procedure, which exists on one of my databases on our server. Now, I dont see that stored procedure. Maybe somehow it got deleted accidently. The problem is that I dont have any backup. But, I do...
  2. zeeshan13

    Retrieving a deleted stored procedure

    mrDenny/SQLBill , Can you please save my life here? Thanks a million in advance.
  3. zeeshan13

    Retrieving a deleted stored procedure

    SQLDenis, I dont have anything whatsoever. The only thing I have is the current DB, with full tranaction logs. There should be some way to retreive it using transaction logs. What do you think??? Thanks in advance...
  4. zeeshan13

    Retrieving a deleted stored procedure

    Unfortunatelty, I dont have any backup before I deleted the stored procedure. If i had, that would be very easy, but I dont. Is there any way I can retrieve my stored procedure??. Thanks in adavnce,
  5. zeeshan13

    Retrieving a deleted stored procedure

    SQLDenis, I would appreciate if you can explain further. What Backup you want me to do on the current DB (full, deferntial, transc log) ????? Then please let me know the rest of the steps as well. Thanks a million in advance....
  6. zeeshan13

    Retrieving a deleted stored procedure

    Hi All, I have a serious problem. On friday I modified a existing stored procedure, which exists on one of my databases on our server. Now, I dont see that stored procedure. Maybe somehow it got deleted accidently. The problem is that I dont have any backup. But, I do have the transcation...
  7. zeeshan13

    The delete trigger is not updating the field to current Date/Time???

    SQLDenis Thanks again. You are great :)
  8. zeeshan13

    The delete trigger is not updating the field to current Date/Time???

    SQLDenis, Although, my trigger worked. I am just curiours, how your trigger works. create Trigger InsertLogoutTimeForUser on Session For Delete as if @@ROWCOUNT =0 return update u set u.Duration=getdate() from UserTrack u join Deleted d on (u.SessionSID=d.SessionSID) I guess in your case, it...
  9. zeeshan13

    The delete trigger is not updating the field to current Date/Time???

    jbenson001, Thanks for you help. I got it. Here's the correct Delete Trigger: --Delete trigger create Trigger InsertLogoutTimeForUser on Session For Delete as update UserTrack set UserTrack.Duration=getdate() from UserTrack join Deleted on (UserTrack.SessionSID=deleted.SessionSID)
  10. zeeshan13

    The delete trigger is not updating the field to current Date/Time???

    jbenson001 , So what should I use for delete??? Thanks a million in advance...
  11. zeeshan13

    The delete trigger is not updating the field to current Date/Time???

    Hi all, I have a table called Session which holds the session information of each user who logins to our internal non-web based application. As soon as the user logout the Session table removes the record for that user. So the user records is only active in to the session table as long as the...
  12. zeeshan13

    Help with a insert trigger ????????????????

    Hi all, I have a table called Session which holds the session information of each user who logins to our internal non-web based application. As soon as the user logout the Session table removes the record for that user. So the user records is only active in to the session table as long as the...
  13. zeeshan13

    Help with a update Query??????

    RileyCat, This is what I had before: 1. select distinct distinct ZoneID, ProdID, ProdDesc into ListA from Test where ZonID='GLOBAL' Now, before updating, using a query like yours, if I do the following select: select * from Test t join ListA g on (t.ProdID=g.ProdID) where...
  14. zeeshan13

    Help with a update Query??????

    RileyCat, Yeah you are right... Compare ListA & ListB, set all the ProdDesc of ListB to same as the ProdDesc of ListA, where ProdID in both ListA & ListB is same, but ProdDesc in both ListA & ListB is different. Thats what I meant... Can you please help??? Thanks,
  15. zeeshan13

    Help with a update Query??????

    Hi All, I have a table called Test. It has the following fields all with nvarchar data type. ZoneID, ProdID, ProdDesc Now, apart from different zoneids, there is a id called GOLBAL Irrespective of zoneid, I want to update the descripiton to same as the GLOBAL level description. Here's what...
  16. zeeshan13

    Stored procedure to return all records if no parameter is passed ???

    gmmastros , I figured it out, In your procedure definition before Null , "=" was missing. I put it & I ran the following sp which works: Create Procedure TestProd @Zone nvarchar(20)=NULL as select * from #TABLE1 where Zone = Case When IsNull(@Zone, '') = '' Then Zone...
  17. zeeshan13

    Stored procedure to return all records if no parameter is passed ???

    gmmastros, Thanks for the quick reply. The procedure definition that you just was having problems, so I remove the NULL keyword, I ran the following procedure: Create Procedure TestProd @Zone nvarchar(20) as select * from #TABLE1 where Zone = Case When IsNull(@Zone, '') = ''...
  18. zeeshan13

    Stored procedure to return all records if no parameter is passed ???

    Hi all, I have a table called TABLE1. With following definition Zone nvarchar(20) Store nvarchar(20) I have following records in that table: Zone Store 0001 10000 0001 20000 0001 30000 0001 40000 0001 50000 0002 80000 I have created the following stored...
  19. zeeshan13

    How to know which usres are currently login on the Server???

    All, We have windows 2003 OS on our server. We remote desktop to our servers, which for each server allow only 2 users simaultaneoulsy to login, in case if we try to login, it prompt you "The terminal server has exceeded the maximum number of allowed connections. Now, to know who 2 users are...
  20. zeeshan13

    How to findout who is on the server?

    yeah I meant OS, not SqlServer. I think, I should have posted this thread under windows forum.

Part and Inventory Search

Back
Top