Search results for query: *

You can save all the packages to file (a time consumming task) and copy them to floppy or whatever then import them on the second machine. I'd write some vb script to save all of them to file in one fell swoop. The code's not too hard. If you have trouble, email me off-line. Sorry, but...

In SQL2000 each record can only have a total size of 8000 bytes. So, if you are declaring a table that is bigger than this, that is why you are having trouble. For example, the following table is illegal because each row is too long (9000 bytes) create table test( field1 char(1000) null...

Try if exists (select * from dbo.sysobjects where id = object_id(@TableName) and OBJECTPROPERTY(id, N'IsUserTable') = 1) ______________________________ - David Lanouette - Lanouette Consulting, LLC - DLanouette@Computer.org

YOu are on the right track. If you are going to "group by bid", you need to do something with Current. But, you probably want to "order by bid desc" HTH ______________________________ - David Lanouette - Lanouette Consulting, LLC - DLanouette@Computer.org

It also depends on what else your db is doing. Storing JPEGs in a table can KILL preformance. It is often better to save teh files to the file system and store their path+name in the database. HTH. ______________________________ - David Lanouette - Lanouette Consulting, LLC -...

try re-downloading that part. It could be a corrupt file. HTH ______________________________ - David Lanouette - Lanouette Consulting, LLC - DLanouette@Computer.org

I don't know what you mean "the mouse pointer is under the picture box" If you put the code in Picture1_MouseMove event, that should do what you want. HTH. ______________________________ - David Lanouette - Lanouette Consulting, LLC - DLanouette@Computer.org

try looking up Instr, Replace and UCase. HTH ______________________________ - David Lanouette - Lanouette Consulting, LLC - DLanouette@Computer.org

is there a reason that you are using an OLE Link field? Why not just store the file name? (or is that what you are doing?) If you change to that and still have size problems, then its something else, not the pictures. ______________________________ - David Lanouette - Lanouette Consulting...

Is there a reason that you count the child records? If you just did the delete, instead of a count, it should delete ALL teh child records that match, not just one or two. See below. Am I missing something? DECLARE @inv_id INT SET @inv_id = 1234 --delete the child record DELETE table1...

First, in SQL Server 2000, Varchars can be upto 8K. changing to Varchars will make your life much easier. With Text fields, its not as easy as that. Look at READTEXT, WRITETEXT and UPDATETEXT in BooksOnLine. HTH ______________________________ - David Lanouette - Lanouette Consulting, LLC -...

When you say you don't get the right image, do you have a program that retrieves the immage from the db and shows it? If so, does it display any immage, or do you get an error? If it does display an immage, is it an immage from the db? ______________________________ - David Lanouette -...

First, it shouldn't take hours to update your tables - even if it is 40 tables. Are there some COMPLEX triggers or other things running at the same time? How long did it take in MFC? Next, you could issue table locks, but with 200 concurrent users, it would take hours to commit the trans...

No, not really. All dts cares about is that it was able to run the sp. It doesn't care if it failed or not. What you can do is trap the error (with &quot;if @@Error <> 0 goto someline&quot; after EVERY statement) and then return the error code. Because, you can check this in DTS (atleast in...

If its the same copy I used, it expires in 120 days. Then the server won't start. If forget if it stoped while it was running. AFIK, its the full enterprise version. There are no limitations other than the 120 days. HTH. ______________________________ - David Lanouette - Lanouette...

You can't do that in VB. But, what you could try is using a collection(or dictionary) and then use the name of the key, instead of the variable name. This would work better if you had a lot of var's that you needed to use this way. i.e dim cMyVars as New Collection dim sVarName as string...

Do you want to delete the directory, or the files in the directory(and leave the directory)? if you want to delete the directory, Dim fso Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;) fso.DeleteFolder(&quot;c:\MyDir\&quot;) If you want to delete the files Dim...

The only thing I can think of is to write some vbscript to open the package and go through all the connections and change them. Not pretty, but it will work. If I rember correctly, they fixed that in sql 2K. ______________________________ - David Lanouette - Lanouette Consulting, LLC -...

Try first adding the poeple records then use a lookup when adding the Cars (see the help). Or, alternately, copy all the data into a temp table and add a field for the Poeple ID. Then add all the data to People from this temp table. Go back and update the People ID in the temp table. The...

Try first adding the poeple records then use a lookup when adding the Cars (see the help). Or, alternately, copy all the data into a temp table and add a field for the Poeple ID. Then add all the data to People from this temp table. Go back and update the People ID in the temp table. The...