Search results for query: *

From what the main hardware guy here tells me all the workstations are up to date and have even got the new XP SP3 installed on them.

Yes indeed. Security and permissions where my first thought but have give users access and even full access (for testing) and the problem remains. Have ran tests on our workstations and server here at our office and we don't get the problem, have checked server settings on our customers server...

Hi all, Awhile back I was having trouble getting our companies client software to execute a DMO backup routine (C#) on an SQL2005 database. The answer was to put the database in Compatibility mode and then to install the DMO Backward Compatibility patch for .net 1.1. Well my problem has came...

Hi all, Awhile back I posted a thread relating to DMO errors when trying to call a backup process from .net 1.1 to a SQL2005 database. I found an answer which was to download and install some Microsoft DMO backward compatibilty patch for DMO to allow it to work with .net 1.1. This is all well...

Sorry, it seems I have been mis-informed... The server in question which SQL Server is running on has 2gb RAM not the 4gb as started previously... The SQL Server memory usage was when the problem started set to 1.5gb and is now set to 1.2gb. Problem still exists, coming and going at a random...

When the problem first started SQL Server was set to use 2gb of memory... for some reason the DBA lowered it to 1.2gb... the problem seems to come and go, sometimes it runs really slow other times it is perfectly normal which would say to me something else is running on the database at the times...

The .net client runs from terminal PC(s) in other offices... The slow performance has only started occuring a couple of days ago, there haven't been any updates to the .net client made for several weeks so it has remained unchanged since the time the server was running at the correct speed...

• Server RAM (4gb) • Hard Drive / Page File space - ok • SQL Server Memory usage is set to 1.2gb • Unsure on last HDD Defrag... will ask DBA to check HDD Fragmentation to clarify. When the database was slowing Task Manager on the server was showing SQL Server using 30% CPU... when we...

Yeh that was one of my first thoughts that while the database was being used during an operation locks may have been accuring slowing thing down while other requests waited for tables to be released and available. Is very odd... my DBA came in a few mins ago and apparently the first database is...

Hi everyone, I have been asked to post a question by my company's Database Administrator. We have a database which is showing some performance problems. We took a full backup and restored it under a different name on the same server as the first database. The newely restored database does...

Thanks for all the help, have just found the answer to my problems... Microsoft have produced an .msi with Backward Compatibilty components to allow DMO to continue to work correctly with SQL Server 2005... It says on the website that if you do not update the SQLDMO to the newest version the...

onpnt our software performs a backup before the user selects to do a particular task (which is very complex and takes about 1 hour to complete) in case something goes wrong we can roll the database back to the state before the task is performed... this mechanism was put in before I joined the...

Hi everyone, My company writes and maintains a .net 1.1 application which connects to an SQL Server 2000 Database. Using SQLDMO we envoke a Backup of this Database from the client. We are currently looking into upgrading to SQL Server 2005 and had not encountered any compatibility problems...

I need to totally lock a Windows Directory while our C# application is running. It needs to be completely locked out to Explorer browsing and Read/Write by other applications. Does anyone know how to do this (If it is even possible) ? I don't mind using Windows API's if I have to, but...

The code for a checkBox would be: checkBox1.Databinding.Add("Checked", dataTable, "UserEnabled"); Where "Checked" is the property you want to bind "dataTable" is the DataSource to bind to and "UserEnabled" would be the boolean or bit in TSql column in the DataSource you want to bind to...

If it was me I would: 1. Get the data from SQL Server using a SQL Statement. 2. Using C# SqlConnection, SqlCommand & SqlDataAdapter objects run the SQL Statement and populate a DateTable 3. After the DataTable is loaded set up DataBindings to the controls you want to populate. Eg...

C++ eek... haven't touched that for a long time, I feel a brush up comin' on! Thanks for the links, at first glance they look pretty good, will haves a proper read tomorrow. [smile]

Hi, I am currently building an MP3 / Audio Player control for WinForms .net v1.1 using Managed DirectX 9c. I can't find any decent tutorial(s) or example project(s) on how to make a Spectrum Analyser that moves to the music or sound that is currently playing. I have a few very rough...

Hi, I am currently building an MP3 / Audio Player control for WinForms .net v1.1 using Managed DirectX 9c. I can't find any decent tutorial(s) or example project(s) on how to make a Spectrum Analyser that moves to the music or sound that is currently playing. I have a few very rough...

I think it depends on what you're application does... The company I work for take the approach that data being returned from a database might as well be filtered server side to make the client have to do less work. If it was me, I would filter it server side by passing filter parameters to a...