Hi all,I have a problem with my sqlmaint task, i get the error below whenever the task runsMsg 2540, Level 16, State 1 Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=14336 extent id=14568 logical pg#=14569 object id on does anybody know what this is about? thanks in […]
2004-10-11
2 reads
I take it you are using DTS --> Export Data to perform this? I've also had difficulty with importing and exporting data from two merged Access tables. Did you create the target table in Access in advance or did you let Access create it. Is the ID column in SQL Server a non-null int (identity)?
2004-10-07
Yes, SQL Profiler is the right tool to use next. The easiest way to use is start with the default options and add bits and pieces to it until you get the effect that you want. Then set run the trace for a while. If you get a lot of data or you want to keep it, […]
2004-10-06
Had the same problem. Reinstalling service pack 3a fixed the issue.
2004-10-05
"Same problem. Chances are very slim" Yes but, 1. the simplicity of the query 2. the speed and 3. the generality are a lot better that the proposed solution
2004-09-22
Hi, the title more or less says it all. I issued the following ... create nonclustered index jobitems_jobkey on jobitems(jobkey) with drop_existing and received the following ... Server: Msg 1925, Level 16, State 2, Line 1 Cannot convert a clustered index to a nonclustered index using the DROP_EXISTING option. I have done this using EM […]
2004-09-17
13 reads
Size can make a difference as can index matching methods. Please run SET SHOWPLAN_TEXT ON then your query right after that on each server and post the text output here which is your execution plan and we can look to see if anything gives us a clue why it is acting so different.
2004-09-03
2004-08-25
Dear all,I create DTS from access (columns date type) to SQL server (smalldatetime). All is OK, but by 2887th record occurs this E message: "The number of failing row exceeds the maximum specified. Datetime field overflow." Thanks for every ideas. zdenek
2004-08-18
17 reads
Trt select * from dbo.syscolumnIs your SQL Server be setup as case sensitive?
2004-08-18
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