Hi,
I want to schedule a job to run more frequent than every minute in SQL Server 2000 - the GUI only allows scheduling of a minute as its most frequent rate. Is there any way of configuring it to...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11597719.html
Hello,
I am fairly new at this and have a question regarding loading XML data to SQL Server 2000. Basically I have a daily data (traffic logs) which need to be feed into SQL Server 2000. The dat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20106272.html
I appear to be getting locking conflicts when using an unbound combo box that has a view, via ODBC (or via pass through query), as its rowsource. (SQL Server 2000 using Access 2000 .mdb as the fro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20236186.html
Hi all,
Sorry, but this is a bit of a long question, as I've already covered a lot of ground on it. I've rather fortunatly *sigh* inheritted a system that has started to insert duplicate record...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20633458.html
I am trying to help our MS SQL Server 2000 DBA with converting a stored Procedure from Oracle PL/SQL to T-SQL.
The Problem we are having is reading in a File from the File System (NTFS) into the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20734883.html
Dear all,
With using a query on the table layout I have a performance problem:
-Table name:
Values
-Columns:
Values_LogTime (Date/Time)
Datapoint_ID (Interger - Foreign key)
Values_Value...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21202872.html
Zones:
DatabasesDate Answered: 12/12/2004 Grade: B Views: 0
We have SQL Server 2000 SP3a Patch level 8.00.760 and Biztalk 2004 on Windows 2003 Server in two partitions of a VMware environment. The linux server hosting the vmware environment is a 2CPU 8G me...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21623383.html
I have a server contains a database, when it reach its max space, would it be easier to create a new file on the new hard disk as part of the PRIMARY filegroup?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21770108.html
Hi all!
Try running this and you will get the following error in SQL 2000.
Internal SQL Server error.
SQL 2005 doesn't have the problem anymore. So please run the examples below:
------...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21806538.html
We are running a custom application to enter in data on the SQL server.
That said, is it possible to have the SQL server configured wrong? Most DBA's, (not me) can tweak the server to it can ach...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21812623.html
Zones:
DatabasesDate Answered: 06/15/2006 Grade: A Views: 0