Recent content by seiamerica

we have data files in D partitions and indexes on E and logs in F partitions. we are planning to regroup the partitions so that data will be on d and index and log files in E partition. How to do it in cluster environment. Thanks in advance

I need steps to disable triggers starts with 'act' and enable group of triggers starts with lbb Thanks for your help

I have active/passive cluster environment. Planning to install two instance of sqlserver on same box. I would appreciate if someone can walk through the steps along with performance issues. Thanks in advance

I worked it out. Please ignore my request. Thanks for everyone for actively involving in solving developer's problems.

I have created a File Upload application in asp.net and deployed to the server. The application has a browse and you can browse a file from your computer and upload to the database on the server. when I tested locally i.e http://localhost/test.aspx it works fine. But after I deployed to the...

Correction - My Typo Error. It is table Members and not Test in the Update statement. I still get the error though.

I get column name, colValue in a string colName from my dataset. string colName = (da.Tables["Members"].Columns[j].ColumnName.Trim().ToString() ) ; string colValue = (da.Tables["Members"].Rows[i].ItemArray.GetValue(j).ToString() ) ; I need to update my database by setting colvaues to...

I have developed a C# web application now I want to create a report using crystal reports in .Net. I included crytal report viewer and created a report but when compiling my project I am getting this error. CrystalReports.Engine.dll Cannot declare a namespace and a type both named 'r'. This...

I have 10 dropdownlist box with 10 options in each list. I should not be able to select the same option for tow boxes. ex if I select 1 in ddl1 I should not be able to select 1 in any of the remaining dropdownlist boxes. I wrote a funcitn to do this but very lenthy. So I want any suggstions if...

we have active/passive cluster environment in sqlserver 200o environment. I need to apply patch 8.00.2040 in cluster.I would appreciate if everyone gives steps to applying patch in cluster. Thanks

I have a field in sql server database defined as smalldatetime. In my C# application I am selecting a date from calendar into a textbox and trying to convert the textbox value into datetime and putting back to database. I get this message all the time. Error adding item. Please check...

I am getting this error. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. I have created the project as IIS...

I had to move the database from production server to developement server. So I did backup of the database in the production server and moved the file to dev and did a restore on the database in the dev server. Everything went fine. but when I tried to access the site on the dev server I get a...