Search results for query: *

Yeah, medenny, I was hoping not to have to run the change scripts manually but there doesn't seem to be any other choice... hehe. Gotta love the job :D ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof...

Hi, We have a pretty large database with Transaction Replication to a secondary server (pull subscription). Some tables are starting to get pretty large so I want to partition them. On some tables, I have to recreate the primary keys with a new column used for the partition schema. The...

Ah, sometimes we overlook the simplest things! I was rechecking the indexes on the child tables and noticed the clustered index was created as a covering index (3 fields) with the aforementioned foreign key. So what happens when the foreign key runs its check? It won't use the index fully...

I'm deleting the children before deleting the parent records. Nonetheless, it still runs a clustered index scan on the child records when deleting the parent. Do you know of a way to force index use on foreign key checking? Incidentally, I ran some tests on my beta db. with foreign key on the...

Hi, The child tables have ParentValID as a clustered index. Should the index be switched for a non-clustered one? Thanks ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe...

Bump! Anyone? ----------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rich Cook

Hi, I have a table (ParentVal) with four child tables (ParentValA, ParentValB, ParentValC, ParentValD) each with foreign key constraints. ParentVal has 15000 records ParentValA has 1000000 records ParentValB has 2000000 records ParentValC has 15000000 records ParentValD has 30000000 records...

I'm wondering if I'm going about this correctly... I have a data file on the PRIMARY filegroup located on drive H: (100gb 1/0 etc...) The data file is getting close to 100gb so I had IT add another drive to the server. What I want to do is stop the growth on the H: drive and start writing to...

I have a record with an xml data type field. The value starts out raw, basically just a "<mynode />". I also have some procedures that handle related records (in the thousands) and it checks whether to perform taskA or taskB and add an attribute to the xml. Does the xml dml have some way of...

Yup, and it also makes the IDE disappear or lockup on occasion. Wierd hunh? Also, source control is enabled with VSS, maybe this has something to do with it? There isn't anything in the event viewer for this either. ----------------------------------- &quot;Programming today is a race...

Hi, I'm running this fairly large web project (aspx/c#) on VS2003. The issue I'm having is when I debug and attempt to stop debugging, two things can happen... 1. The IDE disappears as if I clicked on the X instead of just the "stop debugging" button. 2. When the IDE doesn't disappear (after...

IonFilipski, thanks for all your suggestions but I figured out what was failing after having the olap guru check the references in the vb dll. Seems this dll calls SQLDMO (for olap processing) by CreateObject rather than a reference so the linking fails at runtime because I don't have those...

That's not it. The class name is correct in the registry and it has the correct Clsid (HKCR\CLSID\...) ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce...

That's not it. I thought that perhaps there were other of the same dlls elsewhere so I searched the HDs to delete all files (only one) I found except the one in the vb directory (binary compatibility), I ran regsvr32 /u dll, scrubbed the registry for the classes, recompiled, ran regsvr32 dll...

I'm maintaining some legacy code that doesn't seem to work correctly... An ActiveX dll was created a while ago in VB6 to process some data in the database. This dll is imported into a VC++ (visual studio .net 2003) project with the #import directive, but when it attempts to create an instance...

Anyone? ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.&quot; - Rich Cook

I am wondering if there's something similar to what's on 2000 that'll give me some minimal server side debugging capabilities. I don't want to install vs.net on the machines running simulated production environments but it would greatly help if I could somehow see what's going on in the...

Never mind, I'm copying all the data to another drive and formatting it. Thanks for the suggestions anyway. ----------------------------------- &quot;Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to...

Tried scripting, nothing. Tried to "net use" the drive to a machine with visual basic and use fso to delete the folder, I get "permission denied" when I run "fso.DeleteFolder pathToNulFolder, true" or "path not found" when I try to "fso.GetFolder(pathToNulFolder)"...

longhair: Doesn't work The ~ only works when you create a file/folder that doesn't fit the 8.3 rule. example, go to your c: drive, run dir /x, you should see: <DIR> DOCUME~1 Documents and Settings <DIR> PROGRA~1 Program Files <DIR> WINNT Notice the WINNT doesn't have an 8.3 format...