Viewing 15 posts - 31 through 45 (of 120 total)
quote:
Enterprise Manager-->Server of interest -->management -->job system
Which version are you talking about? I...
October 17, 2003 at 12:16 pm
Here is the command I came up with:
isql /S servername /U sa /P password /Q "exec sp.sql"
I am getting: Could not find stored procedure 'sp.sql'.
Did I miss something? I am...
October 17, 2003 at 11:33 am
If there are two nodes in a cluster, wouldn't that make 32 total instances?
October 10, 2003 at 11:49 am
These are data files in the original database. Thanks, Allen.
October 2, 2003 at 2:26 pm
EM - Restore from device - Read from Media - Options. Maybe it is not filegroups, just data files.
October 2, 2003 at 12:20 pm
The 7.0 database was created in two file gorups. During the restore to 2000, under options, three file groups showed up by default.
October 2, 2003 at 11:49 am
quote:
Strange how the answer is contradicted by the body of the explanation.The answer is "...makes excellent choices for Primary Keys.." and...
October 1, 2003 at 2:50 pm
Wouldn't the 'rollback' rollback the update statement before it is committed, which is why the @@rowcount is 0?
September 30, 2003 at 5:09 pm
Since it is not on a cluster, I would upgrade MDAC...
September 29, 2003 at 4:31 pm
In my case, the thread is holding one transaction but the status is waiting and it has been waiting for hours which blocked other transactions.
September 25, 2003 at 12:26 pm
Which version of MDAC are you running? Is the database on a clustered server?
September 24, 2003 at 4:41 pm
We use Embarcadero Change Manager. Great tool!
September 24, 2003 at 4:36 pm
Is blocking the same as a dead lock? How long should I wait before killing the blocking process?
September 24, 2003 at 4:22 pm
Thank you, guys, for the helpful input.
With regard to the MDAC issue, it may make things complicated. My test server is on a cluster. According to Microsoft: 'MDAC 2.6 or...
September 24, 2003 at 10:33 am
Viewing 15 posts - 31 through 45 (of 120 total)