Recent content by SeanB

Issue: I am transferring about 30 MB of data with replication from Database A to Database B on the same server. I am running SQL Server 2000 on the server. Database A is approximately 270MB in total. I am using transactional replication and am using transactional based, push subscription to...

Does anyone know how in ASP to capture the FROM address that will come up in a MailTo: call in HTML? I need to capture in code the FROM address so I can put it in as a variable in my subject line. Thanks

I have a dropdown box that when I click on it, the box wont stay open. Any idea? Here is the syntax: <SELECT id=type name=type> <OPTION value=&quot;&quot;></OPTION> <OPTION value=&quot;B&quot;> Buyer </OPTION> <OPTION value=&quot;S&quot;> Sales </OPTION> </SELECT>

Hello all. Troad you might know this one. i initially set the Transaction Log Space Allocated to a gig which is to much and i want to bring it back down. When i try adjusting it, i get a message saying the DBFile must be larger than the current size. Any idea how to change this?

The log file is growing a great deal in our database is the best way to deal with this setup a scheduled Backup log file and then Shrink database then backup? Is there a way to restrict the log file from growing or is this a bad idea?

Is there a way to dump it now, it is causing a big issue and I want to dump the log if possible? Thanks Troad

Hello all I have a database that is growing very large from the log file. I know the syntax for 7.0 does anyone know how in SQL 2000 to do this and should I schedule this once a week. The DB grew from 500meg to 5 gig

I have a report where I added Page Numbers to it. I have a header called Invoice Header which is where the Page number text box is. THe Page numbers keep running and they don't start over on each new Invoice. For example if Invoice #1 had 2 pages and Invoice #2 had two pages it goes stright...

Is there anyway on a form to only refresh or requery the record I have selected on the Form_Current instead of having to requery the whole set. I am not using Jet OLE ADP and it won't work like jet. Thanks

Hello all. I have an ADP application that I need to requery all the time to get the most recent info back from SQL Server. However, the only issue I am running into is on the Bookmark so I can keep the place or on requery I lose the bookmark in ADP the scroll bar moves and the user gets...

Is there anyway in Access 2000 to not have to requery the entire recordsource on a form and just the record that I am on without losing the place I am on?

Hello. I setup Outlook 2000 on my server and created a Profile to my Pop3 account which looks like it installed correctly. I then tried from SQL Mail to link to that profile and I always get the dreaded 18035 error failed mail error. I also installed SP1 for SQL 2000 from the setup.bat file...

Hello all. One big question about ADP. In a ADP file I have a continous form that is bound to my recordsource in a multiuser environment. When a user makes changes the other user never sees the changes. In a ADP form the only way I can see the changes is by requerying the entire set on...

Hello all. I have an ADP Database that I have to put on the current event of a main form a requery because with ADP it is not like jet and the only way I can show the latest changes to the user on the form is to requery just in case another user has made changes to the record. This however...

I have a proc that I have a sub query summing a column. How in the proc can I set the value to zero if it is Null.