Search results for query: *

Hi all, For a flexible import in our SQL database (SQL 2000 on a Windows 2003 server) we use OPENROWSET. In our development on a local instance of SQL Server, we have no problems with a connection to Accesss. However, when we deploy the same code with the same Access database to our test...

I have a table with very straight forward fields. To populate this table, I have the following stored procedure: ALTER PROCEDURE proc_AddPostBack @PostBackID UNIQUEIDENTIFIER, @UserID UNIQUEIDENTIFIER, @UserIP CHAR(15), @PBControlID VARCHAR(255), @BillingMetadataKey CHAR(32) = NULL...

We are scaling out our large database over multiple servers. For this we are setting up distributed querys to access the data. The performance and scalability is great. Hovever, we want to keep our availability very high. If one of the servers would be offline, the query would return an error...

Hi all, I am running a performance monitor against our servers to get an overview of potential bottlenecks in performance. One of the counters I'm looking at is the physical disk. I am looking at % Disk Read Time, % Write Time and the queue lenght. What I find puzzeling is that the % Read time...

Hi, I am starting with SQL Replication. I set up a distributer and a publisher on two different servers. I enabled a database on the publisher for replication. When I use the wizzard to make a new publication, I get the following error: Server Enterprise Manager could not create publication...

I am trying to set up one of our SQL Servers as a distributor. I started out using the wizzard in the Enterprise Manager (using all standard values), where I got the follwing error: SQL Server Enterprise Manager could not configure 'UNI-SRV-PRD' as the distributor for 'UNI-SRV-PRD' Error...

In Excel 2000, when editing a formula with brackets, the matching brackets are colored, so it's easy to see what's between them. I recently started using Excel 2003. I don't get this option anymore, nor can I find where to turn this on. Does anyone know if this is still possible and how to use...

We have 50 milion pdf images on a fileserver. These images are displayed on a webpage on basis of a unique number. The images are stored in a logical treestructure. What are the pro's and cons for storing these files in a SQL Server with their ID and image data? Is the control easier to...

When connecting to my SQL Server using the EM or QA, the connection takes a few minutes when building the database list. The performance monitor shows memory and processor capacity at less than 5%, indicating no bottleneck in this area. The diskqueue length, however, is up to 100.000 at this...

My application, connected to a SQL2000 database returns time-outs. On analysis of the query's, I found that the execution plan is far from optimal. The estimated rowcount was 10 and the actual rowcount was 15000. My auto-update-statistics option is on. I found that the last update of the...

I implemented a number of jobs for my dayly backups. In the Notification options I checked the "Write to Windows Application Event Log" and chose the "When Job Fails" parameter. However when the job completes, whatever the outcome, the event is loged in the SQL logfile and the Windows event log...

Hi all, I keep on getting the following errors on my SQL Server: Using 'sqlmap70.dll' version '2000.80.760' to execute extended stored procedure 'xp_sendmail'. Error: 1073759806, Severity: 1, State: 0 Starting SQL Mail session.... Error: 1073759778, Severity: 1, State: 0 SQL Mail session...

Hi all, I am trying to set up a procedure for a data resoration to a database that might be in use at the time of restoration. I once read there are different ways to disconnect all current users to this database to be able to start the restore job. I cannot, however, find the method and...

Hi all, I have a database on my server with sensitive personal information. Within my server and on my backup tapes I have managed security, restricting access to the information. Thinking worst-case, how can I protect my files so that if an intruder steals my harddrives and using the...