this is the error:
[microsoft][ODBC sql server][sql server]I/O (torn page) detected during read at offset 0x00000000003c22000 in file 'c:\sqldata\ms......mdf'.
This prompted in our ERP software that is using SQL 2000 when I go to one of the modules. But generally the database is still working...
Am trying to shrink a database but error comes out always about deadlock with a process ID. when i killed the process, another deadlock occurs with another process.
does this mean when am shrinking a db users cannot query reports from the said db? can't it be simultaneous since it is just...
We have an sql server that contains our data. We use VB to create programs. We use crystal for reports. We use access as local db.
Problem:
Our VB gets data from sql server from our database server in the network. Then, VB sends the data to local access mdb before crystal gets it from access...
I am using win2k professional. Everytime I login to our server win2k server error exist : the system computer's account is not in the primary domain.
Therefore the workaround I do is login to local as admin then rejoin to domain but then everyday same thing happen.
Please help tnx
what is the error when i am trying to login to domain but sometimes it allows me to log while sometimes dont. the error is something like the primary domain account of computer is missing...
is it possible to replicate, using 'replication' function, only certain tables every night?
but then, only the changes within the day will be replicated not all contents of the table.
i know there is such thing if we will replicate the whole DB, but what if i will just replicate let us say...
I have raised this question before but seems there was no answer yet, I am just wondering given the scenario wherein I have 2 servers namely S1 and S2.
Then, I usually backup SQL data to disk and disk to tape using built in win2k backup. I am doing this in S1.
If in case S1, let us say...
I have the following connection string in VB 6 to be able to link my VB to crystal report 8. There is no problem with this.
cryPO.connect = "DSN=TST;UID=sa;PWD=grr;DATABASE=DAT1;"
but then, I want to 'not' include the user and password since in the ODBC we have already specified the...
how do i encrypt the password in a field if i have a table to contain a password for the users so that when i open the table i wont see the actual passwords? tnx
I would like to 'deny' access to certain users in sql but the problem is i have around 500 tables. for each tables i have numerous columns. does sql have a mass update feature rather than i have to deny access for example the 'delete' access for each table?
if not, can i execute an sql script...
How do I start the service in order to be able to restore master?
what is the syntax for starting that allows this master db restore. there is something to do with a -m but I can't seem to get the actual syntax
tnx
We have 2 servers. When I backup a tape using the built in backup tool from 1 server then, when I load the tape to another server I can't seem to view the media set on the other server.
How do I restore the data to another server using the other server's tape drive?
tnx
I have a program in VB then upon doing all the processes in VB I send the output to crystal report. My database is SQL SERVER.
I encountered an error require ansi_nulls and ansi_warnings
during the connection what should I do?
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.