Discuss Content Posted by Neil Weicher
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Neil Weicher
2002-01-27
2 reads
XML
OLE DB Times Out
Hello, Ever since we moved from MDAC 2.5 to MDAC 2.6 We have been facing this problem of all DTS, Queries timimg out. The same queries, DTS packages used to work. These do work some times. But the max number of times they time out. Is there a way of setting the time out for […]
2002-01-26
2 reads
Discuss Content Posted by Daniel Gallagher
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Daniel Gallagher
2002-01-25
1 reads
XML Data Solutions
This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.
2002-01-18
2,982 reads
Tr. Log File Corrupt (HD fail) detached cant atach
Hi, I have a database that became Suspect. Checking Event Log it looked like the Hard Disk had a bad block. I wanted to know which file was bad. I stopped the service, copied both *.mdf and *.ldf. The MDF could be copied, but not the ldf. So, I restarted the service, and detached the […]
2002-01-17
3 reads
Page not found error message
I have set up IIS with a virt. dir. and have entered an xml and xsl. When I type in the URL I am getting a page cannot be found message. When I enter the xml and xsl individuallyin the url they display. Any ideas or suggestions. TIA, Philip
2002-01-10
2 reads
tables left behind after removing merge replicatn
We have just removed merge replication from a database and find that about 10 system tables are left in the database that are only used by merge replication. I tried deleting the tables and can't. I even went to server settings and checked the box to allow modifications to be made directly to the system […]
2002-01-04
SQLXML 3.0 Beta
SQLXML 3.0 beta adds new functionality to SQL Server 2000, giving developers the capability to expose stored procedures and XML templates as Web Services. It also includes all the features of SQLXML 1.0 and 2.0.
2002-01-01
1,530 reads
Copy permissions from role x to role y
I have a database with >500 sp and >100 table. How can I transfer all the permissions from one role to a different role with TSQL? I don't want to use DMO because clients without the sql client installed will not be able to run this. Thomas
2001-12-10
2 reads
Simple OLE DB Provider for XML
The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.
2001-12-10
1,479 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers