I appear to have fixed the issue, but I'm still not sure what it was. I could not find any issues with the data (no invalid characters or strings)...

No, there are no identity or datestamp columns in the table. The primary key is generated by the app, and there are a couple of datetime columns but no...

I am getting the same error in snapshot replication. SQL Server 2005 SP2 on publisher, distributor and subscriber. Publisher and subscriber databases have the same collation. I...

Hi Mud. I forgot to post the new version that I made once I remembered that not all FKs have only one column. Below is a longer version...

I recently needed to script out all foreign keys in a database, and figured I would post that script.

SELECT'ALTER TABLE [' + RTRIM(tabowner.name) + '].[' + RTRIM(tab.name) + '] ADD...

If you forget to include stats in the restore stored procedure, you can use the LiteSpeed stored procedure xp_slsreadprogress 'database ' to retreive the percentage complete. This stored procedure...

The instructions to create the SQL_Install folder worked great! Also, it appears that there are problems with installing the workstation components if you have Visual Studio 2008 installed. ...