I have a problem with a Maintenance Plan on SQL 2000. The whole plan works just fine exept one thing. The job for backing up the transction log fails. The log for my main database works fine, but the problem is that the translogs for pubs, northwind, msdb and master fails. This means that the […]
2001-10-04
1 reads
I'm using SQL Server 7. When checking the Use Fast Load option in the advanced tab, does that mean that we don't log the transaction? Is there anything in straight forward DTS (2 data pumps, 1 DDQ) that would be not logged? I thought everything was logged with those 2 tasks. Am I thinking wrong? […]
2001-09-21
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
2001-09-19
3,729 reads
Hello evrbody, I've used to SQL Server 6.5 ... I've had some problems... I want to make my own SQL procedure which.. execute dynamicly created sql terms .. and sql server message to me ... the max size of varchar must be 2555.. my question .. how can I increase max size of varchar type..
2001-09-17
3 reads
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
I have one table in my database Employee There are three columns in employee table and in table i have 10 records.Now I want to create new table having the columns which are in Employee Table But i don't want when i create table using the employee table the records resides in employee table should […]
2001-09-06
3 reads
hello there ihave a problem with this stored procedure (sp_makewebtask). I want to create the file in an other computer then mine and i proceed like this : create TRIGGER _TRIGGER_TEST ON [dbo].[Table_SAV] FOR INSERT, UPDATE, DELETE AS execute sp_makewebtask @outputfile='\\MyserverName\MyDirectorie\test.xml', @query='select refclient from table_sav for xml auto',@username='TELECOMPARTNERS\HADDAD',@dbname='TPAccessSQL',@templatefile='D:\DATA\Multiple.tpl' But evry time i have an ODBC […]
2001-09-05
30 reads
Dear Listers, I imagine that many organisations operate with SQL7 on W2K, and that someone has already gone through the task of investigation. I have read that this is not an ideal combination. Is anybody able to provide personal experience or direction to documentation that details potential problems. Thanks In Advance John
2001-09-04
6 reads
Can anybody please help me with this. How to find out the code page on SQL 2000 Server and client
2001-09-04
Hi, I'm importing data from a client's spreadsheet and I want to transform their two digit year column into a four digit year in my SQL server 2000 table. Can anyone suggest the best way to do this? The main problem I'm having is with years such as 00 and 01 because the client has […]
2001-08-30
6 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