Search results for query: *

I have a spreadsheet containing summary-level data. The columns are as follows: "Department", "Budgeted Hours", "Actual Hours", "Variance", and "Expenses". I have a 2nd spreadsheet with detail-level data .. "Department", "Employee", "Work Date", "Hours". What I've been asked to do is display...

Thanks for the response. I think I resolved the issue by changing the datasource for the drop-down control. I don't believe I was setting the datasource correctly, therefore the control didn't have data to popoulate with. Thanks again, BoydMT

When 'Edit' is clicked, I want a drop-down list to display the value that is in the cell prior to clicking 'Edit'. I use the following code to do this: Private Sub dgProposals_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles...

Thanks. This seems to be what I'm looking for. One question, though. In the statement 'Dim DataSystem As CompanyDB = New CompanyDB', what exactly is CompanyDB? Do I need to import it somewhere? Thanks again, BoydMT

Thanks for the response. I've come across this example in the past, but am only familiar with VB.net, not C#. After working with my issue over the past few hours, I'm now able to query the table for the appropriate company type. My issue now is passing this value to the field in my datagrid...

I have a datagrid with a number of fields. Among them are [CompanyName] and [CompanyType]. In Edit mode, [CompanyName] is a drop-down list, and [CompanyType] remains a label. Whenever the value in [CompanyName] is changed, I need to search a table for the appropriate company type, and change...

Siva - Thanks for the reply. I understand how to make a control a drop-down list when 'Edit' is clicked. What I can't figure out is how to populate another drop-down list based on what was selected from the first one. For example, Table1 has the following records: John Smith, ABC Corporation...

My app is connected to 3 SQL tables (tblCompanies, tblContacts, and tblProposals). I've created a datagrid to maintain the data from tblProposals. This datagrid contains the following 4 fields: [CompanyName],[ContactName], [ContactTitle], and [ProposalID]. When the user clicks 'Edit', the...

As a VBA programmer, I've been creating loops within my code for years. However, I now want to do the same using SQL Server, but have heard to avoid them if at all possible. I have a table named 'tblFollowUp'. The table consists of 3 fields ([Name], [Date], [Comment]). An example of the data...

I have created a pull subscription from a SQL2k publication. When I attempt to synchronize thru Windows Synchronization, I receive the following error: 'The schema script '\\SQLServer1\E$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SQLServer1_DB1_Pub1\20031113142755\SomeTable_1.sch'...

Bensta - I use Veritas Backup Exec to back up my SQL Server. In order for the backup to complete successfully, I had to uncheck the options 'Consistency Check Before Backup' and 'Consistency Check After Backup'. This should backup your data without a problem, but you do want to eventually...

I am in the process of creating 3 Push Subscriptions from 1 Distributor/Publisher. Basically, I need all 4 SQL Servers to have the same data replicated between each other. Are there any known issues with setting up all 3 Replication Schedules to run at the same times during the day? I want to...

Thanks mikeyb540. This is exactly what I was looking for. Mark

James - Thanks for the code. I am trying to use your code for single user mode, and am getting the following error: Incorrect syntax near the keyword 'SET'. Any ideas? I am using SQL7. Thanks, Mark

Thanks for the response. I don't think I was totally clear in my initial request. When I try putting the database in 'single user' mode, I receive an error message stating the option can't be changed while another user is in the database. I'm pretty sure there is no one else in this database...

I need to put a database into single-user mode so I can run DBCC CHECKDB with repairs. This database is a distributor for replication. How can I do this? Thanks, Mark

Bill - I thought of this, but was concerned that it may cause even more of a problem. Maybe I'll give it a shot if DBCC CHECKDB doesn't help. Thanks, Mark

Thanks for the input. Yes, this database is a distributor for replication. I think i'll wait til the end of the business day, and run DBCC CHECKDB. Hopefully this will resolve it. Otherwise, I will try disabling, then re-enabling the replication. Thanks again, Mark

Thanks Robert. This returned table 'MSmerge_contents'. Have you ever dealt with table corruption in a system table like this? If so, any suggestions as to a possible solution? Mark

My backup software for a SQL7 database is failing with the following message: Table Corrupt: Object ID 734690461, Index ID 2. Keys out of order on page (1:78526), slots 145 and 146. How can I determine what table is actually corrupt? I am thinking about running DBCC CHECKDB. Can this cause...