Search results for query: *

OK I checked the FAQ section first this time (sorry for last time) and I didn't see anything on this. I have a stored procedure that has a few transactions. At the beginning of the transaction we add a record to a history table and at the end if no rollbacks we update the record. This works...

I have a table with an identity field (Sql Server 7). I want a script to scan the table and return the record before a gap in the sequence. (I have a gap in the sequence when a transaction failed and the inserted record is removed.) Is it possible to do without creating a cursor to loop...

good point. thanks

If you are doing a search against several columns in the database (product category, product description, product short description) and using 'LIKE', is it faster to search each field or a concatenation of all the fields? For example select ... from ... where columnA like '%abc%' or columnB...

A few more questions: Is it possible to acces cookies created in app1 from app2? Is it possible to include files from app1 in app2?

I have an existing web application using IIS 4.0 One of the asp pages may be causing IIS to crash. I would like to take this folder and have it run out of process. I know I can do this by creating a new web app with this folder and setting the properties, however I have a few questions. 1. The...

I have noticed a number of internet sites have the userid/password login screens on secure (https) pages while some sites have the login on a non-secure page that posts to a secure page. Is there a difference? Does the browser encrypt all posts to secure pages even if the originating page is...

I have noticed a number of internet sites have the userid/password login screens on secure (https) pages while some sites have the login on a non-secure page that posts to a secure page. Is there a difference? Does the browser encrypt all posts to secure pages even if the originating page is...

I have noticed a number of internet sites have the userid/password login screens on secure (https) pages while some sites have the login on a non-secure page that posts to a secure page. Is there a difference? Does the browser encrypt all posts to secure pages even if the originating page is...

SQL 7 I am a developer without much knowledge of SQL Admin. My problem: I beleive a stored procedure began a transaction but then rolled back. The web server did not receive notification of the rollback. The event logs for the web server and SQL do not show any errors. I am guessing that...

I know very little about authentication so any help would be appreciated. I have a small web application (IIS4) that will be on my companies intranet. The goal is to prevent users from having to login. Ideally I would like anyone in my company to have access to this application even if they...

I have a text file with data that needs to replace all the data in my SQL 7 table. I have created a DTS package but when I run, the text file data is appended to the table. How do I clear the table and fill rather than append? thanks for your help.

SQL 7 , but I already found the answer. If you classify the step as an Operating System command then all you have to do is put the path to the exe file in the step. It appears to work well. Now I just have to make sure all my permissions are correct. thanks for the response. Brit

I have a nightly SQL job that loads data into several tables. I also have an executable that runs stored procedures and manipulates the data on several databases across several servers. I would like for the executable to be run immediately after the SQL job. Is there a way to have the job launch...

Is there any way to access the recordset from an existing sp called in another sp. For instance: declare @user varchar(100), @pswd varchar(15) declare @crsr cursor set @crsr = cursor for exec ext_storedproc open @crsr fetch next from @crsr into @user, @pswd While (@@fetch_status = 0) BEGIN...