Hi guys, I got this error whenever I tries to input a value with an apostrophe sign, for example "Mary's book", the apostrophe after Mary will be mistaken by the SQL server as the end of the statement and gives me the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: […]
2002-03-01
133 reads
I am having problems keeping the backup server files in seq with its primary server using log shipping. I get occasional errors with xp_splmaint. Do you have access to this extended store procedure code? Has anyone had any luck with log shipping?
2002-02-28
5 reads
Just out of curiosity. I know there are tons of third party tools for SQL Server. Any one has a web site or link to a site where I can find any kind of third party tools? Sometimes I find very helpful tools in such a weird ways, so I was just wondering if there […]
2002-02-26
I may not be looking at this the right way. I am using ADO to execute an SQL stored procedure. I am trying to update records based on how a user links them together. For instance, if a user has task 14 and originally linked them to clients 12,13,14 then I 3 entries into the […]
2002-02-26
3 reads
We've been using BackupExec for a while to back up our SQL 2000 databases, but we've suddenly encountered a problem while trying to back up some of them. It seems that it won't back up databases that have a recovery model of "simple". Our Network Admin can't find anything in BackupExec that references Recovery Model, […]
2002-02-26
2 reads
How do you get last day of the month. Also how do I search this forum for something like this... I could not find search. Thanks Sonali
2002-02-26
1 reads
Use this free stored procedure to compare two different SQL Server databases in order to discover how they differ. Sp_CompareDB can compare both table structures and the data stored in them. Also learn how the stored procedure was written.
2002-02-22
1,214 reads
I have to create a report from an ASP file that will take at least 5 minutes. Can't have the person sit there looking at a blank white browser window, so I thought I could create a Queue for the report. Here is what I did... 1. Put all search elements in a SQL table, […]
2002-02-20
2 reads
Hi, Has anyone used the DTS option to transform published data? (advanced replication option). Just wondering if there is anything to watch out for or be cautious with.... Thanks
2002-02-18
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/ckempster/sqlserversecuritypart3.asp
2002-02-15
10 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers