Search results for query: *

We get a relative blank error: Server: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server. This indicates a security issue to the database or filesystem, but I can connect to the...

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...

If I simulate this with exec sp_recompile proc_AddPostBack go exec proc_AddPostBack .... it still executes in 0 seconds. If recompiling causes this error, I would expect this to take longer Nils Bevaart

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...

I'm not sure (I started the thread a few months ago) but I believe my @@servername gave a null value. Nils Bevaart

Well, the commandline works great. As predicted, it does not return the code back to the xp_cmdshell procedue. Bad luck. We looked at fail over clustering, but this would require an investment of about twice the amount of using dubble servers and having replication between them. The extermal...

Whenever you would find a ' in any fieldvalue, you want to add an extra quote before it. Otherwise you would end the text selection in you TSQL code. So you would get: SELECT * FROM dbo.split('why won''t this work',' ') Nils Bevaart

In future, to prevent duplicate rows, try adding an identity column to your tables. This way you can always specify a specific row for selection, updates or deletes Nils Bevaart

I think I can use the xp_cmdshell to start the scm utility. However, I'm having trouble with this tool. According to the help, I would use scm -Action 3 to get the current status. When I use this (directly on the commandline to test it) I keep on getting the help list with all available...

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...

They are set up as a domain account with sufficient rights. It has worked in the past, but was disabled after a while. I am now reconfiguring replication on the same servers and cannnot get it working again. Nils Bevaart

I configured the distributer first. Everything is configured under an account with SA rights. I also have these rights... Nils Bevaart

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...

If you use the SELECT TOP 100 * FROM xxx the query stops after the first 100 are found Nils Bevaart

I found the answer. The server was not registered in the master database. Somehow the entry was missing. I added the server with the sp_addserver procedure. After I stoped and started the server, it registered as a distributer as it should. Thanks for the help. Nils Bevaart

The machine is registered under its name. Not local. I tried this on the server itsself and on my desktop using a registered server in my EM. Nils Bevaart

If you want to grant execute permision to a stored procedure, use the GRANT EXECUTE ON xp_cmdshell TO @Login If you grant this permission to a windows user who is not part of the administrator group, it will still - for security reasons - not work. Nils Bevaart

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...

Database growth, log growth and shrink jobs cost performance. Generally you want to increase all filesizes manually before you add data, so the database does not have to 'grow' before it can insert the data. You can estimate the datasize, by calculating how many records fit in a page (adding...