RE: IBM DB2 Linked server
I got the following error when I tried to connect: could not obtain the schema rowset for OLE DB provider 'UNKNOWN'. The Provider supports the interface, but returns a failure code when it is used
2003-08-12
2 reads
script
RE: Trans Replication on a cluster w/ Log Shipping
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-08-01
RE: Log shipping
2zach_john: "If you need to a have a database for your users to do reporting against setup to the same server that your log shipping to. This way you'll get dual use out of the server. Disaster recovery and a reporting server. " - Did not quite understand...
2003-07-17
RE: comparing specific rows
Hi Andrew, quote: there is only one table............. A table can be joined to itself. Take a look at self-join in BOL. Cheers, Frank
2003-07-17
RE: Change of IP from Dyanamic to Static
Can you connect it with ip address? Check SQL Server errorlog for error message.
2003-07-14
RE: ODBC / Security Issue
Master must have the guest user, so by default all users have access to it. Same is true of msdb. The guest account in master is required. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-12
2003-07-08
RE: VBScript command-line performance question
This may be a dumb question, but is DTS an option for you? Using a text file as the source and an table as the destination can be extremely fast. With straight ActiveX copy columns I've been loading around 700,000 records in about 9 minutes. These are not small records, either....over 150 columns, and our […]
2003-06-23
1 reads
RE: Lost the MDF, have the LDF
Actually, I was assured by the NetAdmin that my server was being backed up (the partitions that hold my MDF's and LDF's) as part of the backup sets with the rest of the network. The lesson I learned is that I should have been managing my own backups, not relying on someone else to do […]
2003-06-22
RE: Special characters
quote: Ok, maybe I missed something all this time but I have never had a special character bother other than ' as long as wrapped in single quotes 'nnnnnn'. So what is everyone running into that I have yet to hit? there are some more characters to watch. Look at this one: http://www.nextgenss.com/papers/advanced_sql_injection.pdf I've just […]
2003-06-17
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