SSIS package failure message
I am running SQL Server 2005 and my package fails with the following error: OnError MyServerserverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column “Some_Column” (5017) to column “Copy of Some_Column” (6373). The conversion returned status value 4 and status text “Text was truncated or one or more characters had no match in the target [...]

Answer Question   |  September 28, 2008  1:58 PM
SQL Server 2005, SQL Server errors, SSIS

Re-applying column constraints
I have a 100+ db that was hacked. The column level constraints/defaults were removed. I’d like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

Answer Question   |  September 26, 2008  1:26 PM
SQL Server 2005, SQL Server database, SQL Server database restore

Advice needed to reinstall SQL 2005
I’m fairly new to administrering SQL 2005. I need to reinstall SQL Server 2005 due to a few problems I’ve been having with dll’s not being registered. We also run the reporting services. I just need to know what impact uninstalling and reinstalling SQL will have on the current DB’s and reports and the historical [...]

Answer Question   |  September 28, 2008  11:20 AM
SQL Server 2005, SQL Server installation

SQL2000 linked to SQL2005 doesn’t allow TRAN selects
Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above returns the error: [...]

Answer Question   |  September 30, 2008  1:53 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, TRAN

Upgrading from SQL Server 2000 to SQL Server 2005
I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.

Answer Question   |  September 19, 2008  4:37 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

SQL Server 2000/2005 Transaction Logs
Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file contain ALL of the [...]

Answer Question   |  September 17, 2008  3:20 PM
SQL Server 2000, SQL Server 2005, SQL Server transaction logs

Manually migrating databases from SQL Server 2000 to SQL Server 2005
I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

Answer Question   |  September 16, 2008  6:24 PM
SQL Server 2000, SQL Server 2005, SQL Server migration

Archiving a row of data into another database on SQL Server 2005
I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

Answer Question   |  September 16, 2008  6:19 PM
Archiving, SQL Server 2005, SQL Server archiving, SQL Server database

Linked server error message on a SQL Server 2005 machine
We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application) queries the linked server defined on [...]

Answer Question   |  September 16, 2008  3:25 PM
Linked servers, SQL Server 2005, SQL Server errors

Writing a query in SQL for use in SQL Server 2005
I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

Answer Question   |  September 17, 2008  3:14 PM
Query, SQL, SQL Query, SQL Server 2005

How to move a DTS from sql 7 to a server running sql 2005?
I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

Answer Question   |  September 15, 2008  4:15 PM
DTS, SQL Server 2005, SQL Server 7.x, SQL Server migration

Backing up a SQL Server 2005 database on SQL Server 2000 EE
I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

Answer Question   |  September 18, 2008  5:42 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup

Impact on TSM backups after an upgrade to SQL Server 2005
What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?

Answer Question   |  September 12, 2008  5:24 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, TSM, TSM Backup

Disk Partitioning w/SQL Server 2000/2005/2008
I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am referring to [...]

Answer Question   |  September 28, 2008  3:51 PM
Partitioning, SQL Server 2000, SQL Server 2005, SQL Server 2008

WSS3/MOSS Search no wildcards?
When I search in WSS3 or MOSS, I must type a full word and I cannot use wildcards. Examples: “Wilso” will not find “Wilson”. “Wilso*” will not find anything. “Wilson” will find all documents with Wilson in the name or in the document body (content search is working). Is there something I haven’t configured? Is [...]

Answer Question   |  December 16, 2008  11:09 AM
MOSS, MOSS 2007, Search, Search with wildcard, SharePoint, SharePoint Services 3.0, SQL Server 2005, WSS3

Moving SQL 2005 databases with no downtime between servers
We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a server login [...]

Answer Question   |  September 11, 2008  10:14 PM
Database mirroring, Microsoft SQL Server Management Studio, SQL Server 2005, SSMS

Writing a SQL Query
Is it possible to write a query that goes through the entire database to search out a particular phrase to delete it, instead of going table by table? This is on a SQL 2005 Database that was injected. The following appears throughout the database tables: <script src=http://www.jic2.ru/script.js></script> This appears all over in different tables exactly [...]

Answer Question   |  June 13, 2013  8:53 PM
SQL Query, SQL Server 2005

SQL Database Migration Process
Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so [...]

Answer Question   |  September 10, 2008  10:17 PM
Database migration, SQL Database, SQL Server 2005, SQL Server migration

Read Only Table
I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU]) REFERENCES [dbo].[tb1Pmt] ([PmtID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[tb1PmtD] CHECK CONSTRAINT [...]

Answer Question   |  September 10, 2008  9:08 PM
File permissions, Microsoft Access, SQL scripts, SQL Server 2005

Error message on versioning in SQL Server 2005
I’ve received this error message on SQL Server 2005: “Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning.” What exactly is version store, and do I need to configuring tempdb [...]

Answer Question   |  September 10, 2008  7:59 PM
SQL Server 2005, SQL Server errors, Versioning