Nevermind. I got this working. Thank you.
Hello, I need some help on this please. I have a table with the following values. Table Name: Demo Id Fname Lname DOB Sex 10 Robert Todd 1901-03-13...
I am trying to send the email by HTML format. I got the email working but I couldn't format the output. I would like the output to be centered....
Hello, I have a table with 3.9 billion rows and I need to change the data type from decimal(7,4) to decimal(9,6). I tried several different options....
I need to split the single column into multiple rows.Column1 Column2 XYZ ## Err001## => Fieldname: [cbc_dt], ## Err002## => Fieldname:...
Thank you both Elisabeth and Satya for the quick reply.
I am not finding the Readme for the above patch. Could someone tell me what steps I need to follow to install hotfixes to the clustered environment?...
I am using SQL 2005 Replication. I have the replication already setup with 5 tables. I wanted to add 2 more tables (with 20 million rows) to the...
That's correct. I am doing the exactly the same. I have the used the following command for restore restore database TEST from disk =...
I am trying to restore backup from SQL Server 2000 to SQL Server 2005. I am successful in restoring the backup with one data file and one log file....
We have applied Post W2K SP4 Cluster hotfixes and I believe this problem has been resolved now. We moved the cluster to Node1 back and we can see...
Thanks Twan and Brad for your reply. Twan - I did not find anything on NT log and Event log. But I did not check the cluster log. I will look into...
This morning, we moved the SQL Cluster from Node1 to Node2. The cluster administrator shows that all disks came online on Node2 but some of the...
I agree with Phil. We also use SQL Mail in our Cluster environment. It works great with no issues. We have Active/Passive cluster and we did...
Thanks Luis. I tried detaching and attaching the database (with replacing existing filegroup) but this one failed. Gopal
I have one database in production which is around 200 GB. We have 5 filegroups in that database. Only the last filegroup is updated daily. We are...
Thank you Satya and Brad.
We have the following configuration. -Active/Passive Clustering -SQL Server 2000 We want to restart the SQL Service without failover to the other...
We currently have active/passive clustering and we are planning to test active/active clustering. I understand that active/active requires atleast...
Thank you both for your reply. I tried assigning drive letter using Snapshot Manager. It was a software used for SANWorks Virtual Replicator. We...
Separate names with a comma.
