When working in DTS, specifically in the Transform Data Properties window, when I click on the drop-down in the Table/View field the path will only extend for the width of the field, even if the path name is too long to fit in that field. As a result, I often can't see the full path displaye...more >>

Hello! We have attached our 500GB SQL Server 2000 databases on 2005 server. The process took literally took 10 seconds. I was wondering if databases should undergo low level conversion when moved to 2005 environment in order to take full advantage of new features. Will simply attaching ...more >>

I have a development SQL 2000 server system running on Windows 2000 Pro. I keep this system updated with all production data so I can test everything. This question might not be answerable without knowing what kind of data I have, but I'll ask anyway. I was thinking about adding a coup...more >>

Is there any way I can overwrite only one data file of the database with a newer one? Both the files (old and new) belong to the same database but the newer one has some additional data. Additional data was added in-house and the same needs to be merged with the database at the client's site. ...more >>

I bought a copy of the SQL Server 2005 developer edition, but it is asking for a product key. No product key is provided. From the box and packaging I appear to have a legitimate version. MS refuses to provide any support. Any ideas? I've been a little fustrated with MS lately. VS.net 200...more >>

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to SQL 2005 but get a weird error after the first step in the migration. It asks me for a Source and Destination server and when I specify my old and new server and click Next I get this error: Source server: Cannot connect to ...more >>

Ideas on this one? SQL Server 2000 Msg 8624, Level 16, State 8, Line 1 Internal SQL Server error. this is the offending SQL select distinct orlc.orderid, orlc.releaseid, 'BBI', 'AUTO', (select count(distinct orderid) from InventoryDetail id1 inner join orderreleaselinechild orlc1 on ...more >>

We are getting the following error on our database server, and it is wreaking havoc on pooled connections from our intranet server. The service restarts immediately, and there is nothing in any of the other logs to indicate what might have caused the problem. The only seemingly relevant hit...more >>

Hi I wonder if anyone could give some advice around managing a non clustered Index on a large table: rows reserved data index_size unused 229324002 27215584 KB 20200600 KB 6940968 KB 74016 KB ...more >>

Hi, Im having a problem with a SQL server that gets an error after trying to restore a Database. The restore says completed but it doesn't actually complete. I have tred the Knowlege base artical 822852 with no luck still has the same problem after going into the systemdatabases table and c...more >>

In the old days of SQL2000 we could install the SQL Client Tools onto one box but not all of SQL Server. I have installed SQL 2005 a few times now and haven't noticed that option of just installing client tools - is that even feasible now? Thanks ...more >>

I'm wondering why these two queries yeild different results. This query returns no records, there is one record in the Company table SELECT C.CMP_ID, IH.IVH_INVOICENUMBER FROM COMPANY C LEFT OUTER JOIN INVOICEHEADER IH ON C.CMP_ID = IH.IVH_BILLTO WHERE (IH.IVH_DELIVERYDATE BETWEEN '2005-...more >>

We're currently running the 32-bit edition of SQL Server 2000 Enterprise Edition. When we purchased it we were led to believe that if we wanted to use the 64-bit software then the license covered us to use this as well and all we need to do is request the installation media. However, having boug...more >>

How can i set something up so that a new sql script is generated on a regular basis for the tables, stored procedures ? This is because the tables, stored procedures change once a day. So that we can just run the generated scripts on the required sql servers. Thanks ...more >>

Is there a way to set the recovery model of any new databases created on SQL Server 2005 to Simple instead of Full? I would like the recovery model to default to Simple for any new databases created on the server. Thanks for your help!...more >>

I was just glancing over the list of fixes included in SP4: http://support.microsoft.com/?kbid=888799 and surprisingly I don't see any security fixes. Are these on a seperate link somewhere? TIA, ChrisR...more >>

Hello, I have a database that is in production. The database is a SQL2000 database (SP4), but stored on c:\. I would like to move the DB to F:\. What is the best way to do this? Backup the DB, delete it, recreate a new DB with the same name, and restore to it? Is there a better (or safer ...more >>

Hi, I've got two table of sales data that contain a days sales activity. Currenty I run two separate queries: select top 25 [timestamp], sales from salesTableOne where timestamp between '02/02/06 00:00:00' and '02/02/06 23:59:59' order by [timestamp] desc and select top 25 [timestamp...more >>

Is there any reason why thie 'Text in row' optimisation would cause problems with using like clauses? The code below illustrates a problem we discovered when using this optimisation on SQLServer 2005 - a Null value in a row would previously not be selected when using the clause "Where Text_...more >>

I have a store procedure and I want that result of that procedure queryout to a excel sheet. like bcp "DatabaseName.Owner.Procedure_name" queryout "C:\Folder\testproc.xls" -c -q -S"ServerName" -T Is it possible?? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have generated a format file with bcp (SQL Server 2000) which generates a file which would work if there was a column to column relationship between the csv file and the table. My csv, however is in a different order. Basically the table has an identity field but the csv file doesn't. They are...more >>

Hello, We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting this error message in event viewer and at the same time the program that access SQL Server crashes. Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005 EXC...more >>

any reason why a query takes longer to run on 2005 ? sql 2000 query takes 7 seconds same query pasted into sql 2005 takes 56 seconds sql 2005 server is pretty much 10x higher specification query :- SELECT Personal.ID, Personal.Surname1, Lead.DateLeadReceived, Personal.Postcode...more >>

Hi group, Does anybody know a way to copy a rather big diagram in SQLServer to the clipboard? I need the diagram in my documentation (HTML) and would like to grab it as 1 picture and use it in the documentation. Making a screenshot doesn't help either, because it is impossible to make the...more >>

I have generated a format file with bcp (SQL Server 2000) which generates a file which would work if there was a column to column relationship between the csv file and the table. My csv, however is in a different order. Basically the table has an identity field but the csv file doesn't. They ...more >>