Recent content by m0nty005

Can/should replication take place on these virtual db servers? I've setup replication, but currently it serves no purpose. My goal is to setup a way so that my timecard application will be failsafe if there's a problem w/ one of the server. That means data on both db server needs to be...

I'm working w/ W2K Server, IIS, ASP, SQL Server, odbc. My question here is how do I make it so that when one of my db server 1 goes down, my website would automatically redirect its source db to db server 2. This can be a complex process... any ideas? Dunno if it helps, but I've setup...

Is there a Left or Right method (as in VB) to retrieve only the 1st (or last) # of characters from the Select values? Example: myTable's myField1 has values of A00ABC, X00RST, & K00MNO. How can I t-sql Select and display the last 4 characters: 0ABC, 0RST, 0MNO ? Also while I'm at it...

I've datetime values retrieved from SQL Server as mm/dd/yyyy. I put it in a dataset and displayed it in the datagrid.. it shows up as mm/dd/yyyy 12:00:00 AM. Why can't i get it so the dgrid show mm/dd/yyyy? I could set the datagrid to AUTOGENERATECOLUMNS="FALSE" and format myDate column as...

Is there a way you can set your webpage to be able to only print a certain section/object? For instance, I have a webpage that has 2 columns table (left column is my menu area, and the right is the main). My aim is to somehow make it so that I can print only the main area. It would be great...

yes.

Can i create a page to upload a folder? I have a page that can upload a local file(s) to the web server, but is it possible to upload a local folder to the web server??

I use SQL Server 7, IIS 5, Windows 2000, VS.NET 2002, ASP/ASP.NET. Can I utilize sql server 7 and iis 5 for xml? And for IIS 5, how do i go about enabling xml features?

Technology: ASP, SQL Server, javascript I've design an web application which runs a stored proc (that cleans out and fill this table w/ data). When there's different web users generating their own report at the same time (particularly when one report is still being generated), there'll be a...

My webpages allows expired password to be changed via IIS' iisadmpwd pages. But for some reason, it will only work if I enter in the browser address of http://10.0.0.123/page_access whereas the url name http://www.mysite.com/page_access would not work. Instead it gives me "Page cannot be...

My Application Logs had given me a warning that one of my jobs failed.. It turns out that there was a problem w/ one of my stored procedure I wrote - which has syntactically and logicly been working fine querying data for my reports. Well.. most of my reports works fine, but i've discovered...

I'm new to XML, so bear w/ me. I've received a schema .xsd file from my company to use. Now my question is how do I go about creating a valid .xml file that follows this .xsd schema? Is there a tool that i can use to validate to do this? FYI, my job is to create an application that will allow...

After performing every steps provided from the following link (http://www.microsoft.com/serviceproviders/support/perfmon.asp) "How to display Performance Logs as HTML Files", I am still unable to get my chart active on my web browser as http://perflogs/graph.htm. When I double-click on the htm...

If i set the DDL_A (Companies) to autopostback, then everytime i select a company, it would "INSERT data into tbl_Registration" which i don't want. I only want to "Insert --" once when everything is validated and button submitted. The problem i'm trying to solve is to autochange the DDL_B...

Currently, my form does not commit the final execution (IsPostBack section)until all values are properly entered and the submit button is clicked. How do I populate DDL_B (ddlManagers) when I select/onchange a value from DDL_A (ddlCompanies)? There's 2 ways I cud think of: (1) Populate...