|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:36:32 +0800
|
MSDTC Resource Group - Physical Disk and Network Name
Article 301600 (http://support.microsoft.com/?kbid=301600) mentions that
MSDTC should be in its own resource group.
- What is the recommended size for the physical disk that needs to be in
this resource group?
- Is it necessary to add the Network Name resource to DNS?
Thank you. ...
Thu, 6 Jan 2005 07:31:09 -0800
|
SQL upgrade to SQL cluster
We are in the process of implementing a SQL server and are thinking about a
SQL cluster on Windows 2003 Enterprise Edition Servers. But money is
preventing us buying extra hardware at this moment.
Is it possible to install first an SQL server with all the databases and
upgrade it later to an SQL cluster? O ...
Thu, 6 Jan 2005 04:55:03 -0800
|
switch time for sql cluster
Hello,
I need a value for switching time sql-on-node-1 to sql-on-node-2 (best
win2003 cluster, slq 2000). microsoft says 2 - 30 seconds. Is this a real
value?
Thanks
...
Wed, 5 Jan 2005 12:44:45 +0100
|
Databases on different storage
I am newbie in SQL server and have one, maybe dumb question.
I have SQL2000 cluster on Windows 2003 with shared storage on SAN.
Cluster operates with one database only.
I need to temporary attach second database to SQL server, but problem is
that I do not have enought free space on shared storage to place bot ...
Wed, 05 Jan 2005 10:19:56 +0200
|
moving databases to new drive
Hello,
I appreciate any suggestions or comments on the following.
We have active/active cluster, SQL 2000, Win 2000. All databases on first
instance/node are on drive E, and second instance/node on drive F. We are
trying to move all database files to new drives, P and Q respectively.
One approach would b ...
Tue, 4 Jan 2005 11:55:01 -0800
|
Communication link failure
I received the Communication link failure from the Windows 2003 Cluster.
What can I do resolve this error?
Thanks,
Error
SQL Server : [sqsrvres] CheckQueryProcessorAlive:
sqlexecdirect failed
SQL Server : [sqsrvres] printODBCError: sqlstate = 08S01;
native error ...
Mon, 3 Jan 2005 11:49:04 -0800
|
MSDTC tracing
Hello, We have Windows 2000 ADV Server with MSSQL Server 2000 in a clustered
environment. We have MSDTC up and running fine. We are having some
issues with some distributed transactions, therefore we would like to do some
tracing on the DTC. I have found the background tracing options for XP and
Ser ...
Mon, 3 Jan 2005 13:11:03 -0800
|
Linked Servers with SQL2000 Windows 2003
Error 17 SQL Server does not exist or access denied
We have two clusters , one with four nodes, the other with two.
We are encountering difficulties on some with communication going one way,
say between SQL instance 1 to the default instance running on the other node.
The strange thing is it works the opp ...
Thu, 30 Dec 2004 10:51:03 -0800
|
Installation SQL Server 2k Cluster on Windows 2003 failed. Please help.
Hello group,
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:
2 Server (node 1, node 2) with external storage installed as a cluster
(MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both
on the external storage.
OS is Windows 200 ...
29 Dec 2004 07:26:55 -0800
|
Anti Virus Software 0n Cluster
Hi,
We are building a new Win2k Adv, SQL 2000 cluster.
what is the best way to install the anti virus software after the cluster
has been built.....do we need to pause the the node, and then install anti
virus software etc....
Cheers Ray
...
Wed, 29 Dec 2004 13:13:28 -0000
|
Dumb Transaction log question.
I know I've been asking a lot of dumb questions here lately but - One must
learn somewhere.
In my test lab cluster that I'm building, W2k3 Cluster admin put each of my
physical disks in its own group. Now I'm keep one for the cluster group, and
one for the MSDTC, which leaves me four. I'm going to use 1 ...
Tue, 28 Dec 2004 15:15:02 -0800
|
Can't Change Registry keys in Failover Clustering
Plat form: Windows 2003 enterprise ed,
SQL Server 2000 Failover Clustering SP3A enterprise ed.
Action: Change some registry keys after bring SQL resources offline.
I am trying to change the following registry keys to point to new location
on registry at
Master node, member node and virtual server. Howeve ...
Tue, 28 Dec 2004 08:55:02 -0800
|
Connection to Lan fails and locks server
Morning,
We have two nodes in a sql cluster. The "Lan" connection on one of the
servers fails at different times and I can't track down the problem and I am
not sure where to start.
I have changed NIC's Cables, Switches and still no luck..
Any suggestions where to start would be appreciated.
Thanks ...
Mon, 27 Dec 2004 09:13:41 -0800
|
Active/Active Cluster.
Hi everyone,
We have the following setup:
Windows 2003 Server Enterprise edition Cluster with 2 nodes. SQL Server 2000
Enterprise edition Virtual Server1 - currently Active/Passive Cluster.
Shared storage and Quorum drive on SAN.
Database1 on Virtual Server1.
The goal is to set up a reports Database wich ...
Sat, 25 Dec 2004 09:18:30 +0200
|