Thank you for your reply.
I was not able to use detach and re-attach to solve the problem, however I was able to place the DB in Emergency Mode and use the process described here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=645143&SiteID=1
Using this method I was able to get the...
OK, so here's the story. I administer an e-commerce database. Recently my backup tape drive started to go on the fritz, ejecting every tape about 2 minutes after insertion and throwing cyclic redundancy errors. I figure the tape drive is on its last legs. So I ask the network administrator...
I have several queries that were part of a DTS package in the old SQL 2000 system. This database is migrating to 2005, and I am having to re-build the function. Mostly it hasn't been a problem, except for a series of SQL query groups that necessarily declare variables. When viewing the query...
Never mind, I have answered my own question.
I just ordered an EZ USB 2.0 CardBus PCMCIA Card with Dongle from Bixnet.com .
http://www.bixnet.com/seezusb20cap.html
It's even self-powered, with one 500mA and one 100mA port. That won't be much of an issue for me, since it will be connected to...
I have a Dell Inspiron 4000 laptop, it has USB 1.1, however the port has stopped working properly, and I would like to upgrade to USB 2.0. Here is my dilemma.
The machine has two PCMCIA slots, arranged one on top of the other. I use a Netgear PCMCIA Wireless NIC in one of the slots. Like most...
I have some product data that has the UNSPSC codes from an older version of the UNSPSC code standard. I am trying to translact the existing codes to UNSPSC version 13.3, and the manufacturer has been no help.
Does anyone know of a tool or website out there that can assist me with this translation?
While it's not EDI-specific, this seems the most appropriate forum to find advice pertaining to an e-procurement purchasing system. The system I work with is web-based and can use either XML or EDI for document transport.
Anyway, my dilemma is pretty simple. The best way I can import a...
BTW, I've already been to the Microsoft support bulletin at
http://support.microsoft.com/?scid=kb;en-us;312676&spid=1442&sid=global,
and confirmed that the Default web site is set to port 80.
Hey guys. I'm having trouble with a recently-installed Biztalk instance in my development environment. Whenever I try to access WebDav, which is a vital function when trying to create channels, I get an error msg saying that
No BizTalk Server repository was found on...
Okay, I'm pretty new to Biztalk mapping. I am creating a map to translate purchase orders from one format to another.
The Source document uses a single element for addresses, with the attribute "type", which will have a value of either "ShipTo" or "BillTo" depending on which address it is...
I have a form written in VB6 that, among other things, accepts a value for the variable "varRackLocation" and one for "varSerialNumber" and then is supposed to perform the following database query:
UPDATE [tablename] SET [RackLocation] = varRackLocation where [SerialNumber] = varSerialNumber...
I have a table-linked form I've created in VB 6. Here's what I'm trying to do. We have:
Field 1
Field 2
Field 3
Here is the desired behavior. Upon form activation, focus goes to field 2. A value is entered. If this value matches one of a list of values, that value is entered in field 1...
No, the Event Viewer System Log showed an Event ID of 7031. I re-installed McAfee on both servers, then upgraded the scan engines to version 4320 as yukon10 suggested, and that seemed to do the trick.
I have two servers, both Compaq D380 G3's running 2000 Server. Both have McAfee VirusScan. Currently I am not able to start the McShield service on either machine. I can start the Network Associates Task Manager, but it drops off after a few minutes. Whatever is going on it's happening to two...
The database and tablename do exist on the production server, and the correct names, including cases, are in the query, which the guy I am working with have run through query analyzer and gotten the error above. He is in front of the production system, I am trying to help him over the phone.
I have two databases (in the same SQL instance), and I am trying to access a table in database A from a stored procedure which resides on database B. The format of the query is simply:
select field1, field2, field3
from DatabaseB..Tablename
I have this query working find on my local...
I have a procedure which runs fine on our old SQL 7 database but which refuses to run on our new SQL 2000 database. This proc involves selecting a timestamp value out of a table that is a binary, and inserting it to a column in a temp table that is declared as a datetime. When I run the proc...
Thanks for the reply, I actually figured that out a couple hours ago, you hit the nail on the head, when the table migrated over the identity property didn't. Problem solved. Thanks again.
My company has recently updated out ERP and databases from SQL 7.0 to SQL 2000. I am having trouble with a stored procedure which worked under the old platform. The proc populated a table which is used for reporting. It involves an INSERT <table>
SELECT ()
The select statement...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.