Search results for query: *

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...

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

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...

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,

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....

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...

SQLDenis Thanks again. You are great :)

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...

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)

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

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...

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...

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...

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,

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...

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...

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, '') = ''...

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...

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...

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