Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hansje

    XML Bulk Load with ONLY T-SQL possible?

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

    sp_replcmds error...

    Found the problem & solved it.
  3. Hansje

    sp_replcmds error...

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

    Changes to a replicated db

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

    Changes to a replicated db

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

    How to direct SP output to a file or table?

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

    How to direct SP output to a file or table?

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

    How to direct SP output to a file or table?

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

    sp_publication_validation problem

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

    Timeoutproblem

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

    GRANT on all SP's?

    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?
  12. Hansje

    getting numbers out of a string

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

    Extracting numeric value from a string?

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

    Changing Articletables propertie in Replication

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

    Errormessage while action succeeds?

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

    Errormessage while action succeeds?

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

Part and Inventory Search

Back
Top