Search results for query: *

Hi there, I am busy trying to read a table with millions of records which basically have a varchar(8000) field with XML-data into relational tables. I have studied XML with SQL Server, all kinds of tutorials, XMLSpy, XML View Mapper, SQLCML 3.0, you name it. I think I've got the basics down...

Found the problem & solved it.

Hi there, On out distributing server I receive the following message: Replication-Replication Transaction-Log Reader Subsystem: agent AIRWARE_SQL1-Airware-3 scheduled for retry. The process could not execute 'sp_replcmds' on 'AIRWARE_SQL1'.. This has happened several times now. I have looked...

Yeah, found out how to do that. Tnx, Hans Brouwer

Hi there, We have to aply changes to a replicated database. Basically a tablefield has to change from varchar(60) to varchar(80). These changes are aplied to the subscriber, but to aply them to the publishing db its looks like we have to drop the subscriptors, then aply the changes and add the...

I can get it into a file allright. For trendwatching I would think it would be nice to have it in a table with date-of-check. Tnx anyway, Hans Brouwer

Tnx for the response, Angel, but I tried that already and got this message for each validation output: Generated expected rowcount value of 0 for xmliface_admin_request_response_formats_request_headers. Server: Msg 8164, Level 16, State 1, Procedure sp_table_validation, Line 202 An INSERT EXEC...

So how can I send the results from a system-SP to a table or a file? I wish to run the procedure sp_publication_validation each night, because during the day it would probably be too much of a strain on an already busy DBserver. How can I capture the output in a file or a table? Tnx, Hans Brouwer

Hi there, I've set up a replicationprocess which runs smoothly. Now I wish to check things and start using the sp_publication_validation, as described in BOL. BTW, I am aware that I can run validationcheck in EM; I've done this and these actions perform without problem. However, when running...

Hi there, I have an aplication connecting to a database via a n ODBCdriver. First connection is always met with a timeout error. The second though immediately connects to the database involved. I've been looking at the timeout options within SQL Server, but as far as I can figure out, you'll...

So how can I GRANT EXECUTE on all stored procedures in a database, without using a cursor? Is this possible? Sofar I have not been able to get this done. A step further: is it possible to GRANT EXECUTE on every stored procedure in every userdb, again without using a cursor?

Had the same problem a week ago, this is was suggested, and it's working fine: CREATE TABLE Sometable (currencyvalues VARCHAR(30) PRIMARY KEY) INSERT INTO Sometable VALUES ('PM-FV-CARS-TRUCKS-5k') INSERT INTO Sometable VALUES ('M-FV-CARS-TRUCKS-10k') INSERT INTO Sometable VALUES...

Hi there, Does anybody know of a script to extract a numeric value from within a string? I'm trying to make something myself, but it's taking more then I figured it would. I have a column, where currencyvalues are embedded in a string(don't ask me why!). I need to extract the moneyvalue from...

Hi there, Is there a way to change the Articleproperties from a DB to be published with T-SQL? There are 600+ tables to be changed and if possible I would not like to do this via the Enterprisemanager. A link to the correct statements, or even an example , would do. TIA, Hans Brouwer

Some new development here: when I execute a query in QA: declare @v_error int EXEC @v_error = master..sp_addumpdevice 'disk', 'NewDevice', 'c:\temp' I receive a message 'Disk' device added. The tabel SYSDEVICES has a new entry and in EM under BACKUPDEVICES the new device is visible. However...

Hi there, I'm running this script: declare @v_filename varchar(100), @vbackupdevice varchar(100), @v_error int, @p_database varchar(100), @p_dest1 varchar (1000) set @p_dest1 = 'd:\dbbackup\NW\' set @p_database = 'Northwind' set @v_filename = @p_dest1 + '\Northwind' +...