Good one Jim! Is this headed for one of those "It depends on what your definition of 'is' is." conversations? I should know better on a site full of DB...

Please re-read my post. SSMS will help you.

IIRC Personal Edition was not free.

Awesome 😎

Possible values for Edition property:

http://msdn.microsoft.com/en-us/library/ms174396.aspx

Express Editions:

> 'Express Edition'

> 'Express Edition with Advanced Services'

MSDE:

> 'Desktop Engine' (Not available for SQL Server 2005 and later versions.)

Red flags everywhere :exclamation:

It sounds like you're headed into dynamic-sql-hell :sick:

Are you confident in your design? If not, if you want to share a bit more about what you're trying...

My solution makes use of a Tally table. If you're unfamiliar with those please have a look through this article: http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

Build Tally table:

--=============================================================================

-- Setup

--=============================================================================

USE tempdb...

Yikes! Risky assignment.

It does not appear that the product itself requires the .NET Framework, but the Installer does :hehe:

http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx

That said, if you're using SQLCLR you may have issues if you...

If you're ditching SQLDMO you might as well ditch VB Script as well and move to PowerShell. There are tons of examples online of scripting out DB objects using PowerShell...

You can use the LIKE operator on the results of an XQuery value() function.

Modified Example B from http://msdn.microsoft.com/en-us/library/ms178030.aspx

USE AdventureWorks

GO

SELECT CatalogDescription.value('

declare namespace PD="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

...

SSIS does not work like that.

You'll need to pull the SQL Server data into an SSIS recordset, iterate over it and issue an update in Sybase for each row.

Or...

Direct from Kevin Cox (on Microsoft SQLCAT Team) in a "What's new in SQL 'Denali'?" presentation HTTP endpoints were pulled from the SQL Server product almost as a direct result...

Just a stab in the dark:

MySQL requires that each login be associated with an IP address or range. Is your server coming from an IP that is in the range...

USE msdb

GO

IF EXISTS ( SELECT *

FROM sys.objects

...

+1 from me too

I agree that you have chosen a good starting point.

Pros:

> You'll get type-safety out of your PropertyType-specific tables

Cons:

> You will avoid the trap of creating one...