<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Parsing T-SQL Statements with SQLDMO</title> <shortcut>sqldmoparsesql</shortcut> <description>Illustrates how you can parse T-SQL statements against an SQL Server with SQL-DMO.</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <declarations> <literal> <id>strSQLToParse</id> <type>System.String</type> <tooltip>The T-SQL you want to parse.</tooltip> <default>"SELECT Ouch Invalid SQL!"</default> </literal> <literal> <id>strSQLServer</id> <type>System.String</type> <tooltip>The name of the SQL Server you want to parse against.</tooltip> <default>"MYSERVERNAME"</default> </literal> <literal> <id>strLoginID</id> <type>System.String</type> <tooltip>The login ID used to connect to the SQL Server you want to parse against.</tooltip> <default>"sa"</default> </literal> <literal> <id>strLoginPassword</id> <type>System.String</type> <tooltip>The login password used to connect to the SQL Server you want to parse against.</tooltip> <default>"password"</default> </literal> <literal> <id>strDatabase</id> <type>System.String</type> <tooltip>The database you want to parse the T-SQL against.</tooltip> <default>"MyDatabase"</default> </literal> <literal> <id>strDatabaseOwner</id> <type>System.String</type> <tooltip>The owner of the database you want to parse the T-SQL against (can be null).</tooltip> <default>"dbo"</default> </literal> </declarations> <code language="CSharp"> <![CDATA[ // NOTE: This code snippet is designed for VS.NET 2005 or later. // Add a reference to the SQLDMO.DLL file; // usually located in <SQLServerInstallDrive>:\Program Files\Microsoft SQL Server\<Version>\Tools\Binn SQLDMO.SQLServerClass sqlServer = new SQLDMO.SQLServerClass(); try { String strSQLToParse = $strSQLToParse$; sqlServer.Connect($strSQLServer$, $strLoginID$, $strLoginPassword$); SQLDMO._Database db = sqlServer.Databases.Item($strDatabase$, $strDatabaseOwner$); try { db.ExecuteImmediate(strSQLToParse, SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_ParseOnly, null); } catch (Exception e) { // Parse error... } } catch (Exception err) { // SQL-DMO Error... } finally { sqlServer.Close(); sqlServer = null; } ]> </code> </snippet> </codesnippet> </codesnippets>