Hi All, I have windows service that accesses database. I need that service running before user logged in. I set the service running under LocalSystem...
Hi All,I have windows service that accesses database. I need that service running before user logged in. I set the service running under LocalSystem...
Hi All, I created SP and enabled db_datareader and db_datawriter for roles for BUILTINUsers. I can call that SP from my application if I am...
Hi All, I have problem with user deletion in database. First I created Login My_User with SQL Server authentification with blank password and...
Thank you very much everyone. <br />My case is definetely the case when I need to concatenate strings on server side.<br />Actually, I should have...
Thank you all for attention, actually I found the way how to use dynamic SQL with cursor SELECT @sql = 'DECLARE my_cur INSENSITIVE CURSOR FOR ' +...
Thank you Karl and Madhivanan for attention to my matter, I will exlpain my goal in more details. My application running in such a way that...
Hi All, I need to use in stored procedure database which name I am passing as a parameter. The question is : how can I use that name from parameter...
Thanks, Adriaan Just tested your correction, works great. One more question appeared now for me. I used OPEN ChiefComplaint_cursor FETCH NEXT FROM...
Thank you for quick response, ranjitjain DECLARE @EncounterID uniqueidentifier ----------------------------------------------------------------...
Hi All, I failed to find record when using variable in cursor in WHERE clause: ID is uniqueidentifier field in the table DECLARE @EncounterID...
Separate names with a comma.
