Scripting for SQL Server 2000 with SQL Server 2005

Posted At : March 18, 2008 12:33 AM | Posted By : Jim Pickering
Related Categories: Database, SQL Server
SQL Server 2005 has some issues with generating SQL Scripts for SQL Server 2000. Checkout this blog entry over at The Web Jedi for a detailed description of the problems, followed by a simple solution: You need to make sure you're using SQL Server 2005 SP2, before the SQL Server 2000 script is generated correctly. There's a screen shot at the bottom of the page on his blog that shows how to generate SQL Server 2000 compatible script.

Comments (0) | Print | Send | del.icio.us | Linking Blogs

Configuring SQL Server 2005 Dev Edition for Remote Connections

Posted At : July 26, 2007 11:27 PM | Posted By : Jim Pickering
Related Categories: SQL Server
Configuring SQL Server 2005 for Remote Connections has become far more challenging than it should be for a server product. Microsoft's intentions of protecting us have instead cost developers enourmous amounts of time and money in trying to figure out what was before, quite simple and efficient to install and configure. Based on my experience, hopefully I can help.

[More]

Comments (6) | Print | Send | del.icio.us | Linking Blogs
Copyright ©2007 JimPickering.com. Some rights reserved. BlogCFC was created by Raymond Camden. This blog is running version 5.1.004.