.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

A question about Microsoft.SqlServer.SqlParser.dll

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :Sql Server
Hi all, I found this library in SSMS 2008 assemblies, it can parse T-SQL statements into structured XML as well.  'Microsoft.SqlServer.SqlParser.Parser.Parser.Parse(SQL)' This function can resolve standard select/update/insert statements, and it's very useful to us for advance code policies check,  but it's not for all sql commands, for example: 'CREATE TABLE' is okay to go, but 'ALTER TABLE' is not. why? And one thing more, after SQL Server 2008 R2 is installed, this assembly disappeared.:( Is it a half-done job? Where can I find the final version?

View Complete Post

More Related Resource Links

Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies

I got this problem when I tried to migrate one of my web deployment project from vs2005 to vs2010 on windows 7 machine. The exactly error message is like this: Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies. An attempt was made to load a program with an incorrect format.(description) ASPNETCOMPILER(file), myWebDeploy (project) I have installed all of suggested feature packs as suggested by others: SQLServer2005_ADOMD_x64.msi, SQLServer2005_XMO_x64.msi. Can somebody please help? Thanks a lot 

Microsoft.SqlServer.BatchParserClient, Version= -- Again it seems

Ok I created a project and installer, the project uses the SMO assemblies.  On my system and all my test seems it installs and works fine.  After installing on other system I am starting to get error reports because "Microsoft.SqlServer.BatchParserClient, Version=" is not installed on the system.  I have been doing some digging and found the below link but that only seems to help after the fact.  I need to include the correct assemblies in my installer.  Currently the package include the list below which does not include the problem file.  I tried installing SP3 on SQL 2005 but that does not seem to have helped.  What is the correct way of getting this assembly installed on the client server.  I am not happy with giving everyone the below link.http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1 Packaging file 'Microsoft.ReportViewer.Common.dll'... Packaging file 'Microsoft.ReportViewer.WinForms.dll'... Packaging file 'Microsoft.SqlServer.ServiceBrokerEnum.dll'... Packaging file 'WPFToolkit.dll'... Packaging file 'Microsoft.SqlServer.SqlClrProvider.dll'... Packaging file 'Microsoft.SqlServer.SqlEnum.dll'... Packaging file 'Microsoft.ReportViewer.ProcessingObjectModel.dll'... Packaging file 'Microsoft.SqlServer.ConnectionInfo.dll'... Packaging fil

What happened to the backup and restore classes in namespace Microsoft.SqlServer.Management.Smo vers

I do not see these two classes in version 10 of this namespace and I am not finding any documentation explaining what happened to them.

Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=

Hello to everyone. I have a .exe which uses the Server Management Objects(SMO) When I try it on my pc it runs without any problem. But on another pc it gives this error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. I'm using SQL Server 2000 and for the application: Visual Studio 2005. Any idea would be very useful!! Thanks in advance!!

Powershell script that uses Microsoft.SqlServer.Management.Smo.Server need to use Sql Server Autheni

I have written a powershell script that uses Microsoft.SqlServer.Management.Smo.Server.  I have a couple of instances that are on different domains that I must use Sql Server authenication.  I am going to create a report user "sssmorpt".  What is the least a can grant this user to allow me to use Microsoft.SqlServer.Management.Smo.Server to get "$dbsize = $db.size - ($db.logfiles|measure-object -property size -sum).sum / 1024" for all databases in an instances?

Getting "wrong" data out of a microsoft.sqlserver.management.smo.database object property (using pow

My problem:I do something like this:$dbsvr = new-object microsoft.sqlserver.management.smo.server "servername"$dbsvr.databases | ft name,size -autosizeWhen i run this from two different PC's i get database sizes that are all the same (5.25 mb), the size of the first database listed - which is master.I started to try out a few things, and found out that when i run the same command from one of our servers it returns the correct sizes...Anyone have any idea if this a SMO issue, or maybe some package software version issue...- or what?

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found

Hi, I'm getting the following error: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found  when I try and add a excel connection manager to a package being generated programmatically.   I'm working with SQL Server 2008 SP1 (64bit) and Microsoft Office 2007 Data Components (32bit) on a Windows Server 2008 R2 (64bit) The code is executed by a WCF service hosted on IIS7 with the app pool running in 32bit mode. Since this is the 4th environment on which the app is being deployed and the only one that throws the error, I don't think it's an actual problem with the code. One thing that could be significant is that the new box I'm trying to deploy my app to is a VMWare virtual machine whereas all the others are physical servers. What could possibly throw this error? It's very non-descript :( Any suggestions and ideas would be greatly appreciated.

0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

64 bit Server 2003 with Sql 2005 64-bit I can't seem to do a lot of things.  Like... backup the database through the SQL agent.I'm catching flak from the client who was told by a microsoft rep that SQL 2005 works like a charm....It's too late to move away from SQL 2005, we've already migrated systems over to it, and now I'm stuck.This error happens when trying to export to a flat file using Export Wizard(right click database and choose export):===================================An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard)===================================Exception has been thrown by the target of an invocation. (mscorlib)------------------------------Program Location:   at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)   at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[]

Microsoft.SqlServer.Dts and related assemblies to develop custom ssis task are missing

Hi All, I tried to develop a simple ssis task but the problem that I can't refer the necessary assemblies like Microsoft.SqlServer.Dts.Runtime And also Microsoft.SqlServer.DTSPipelineWrap Microsoft.Sqlserver.DTSRuntimeWrap Microsoft.Sqlserver.ManagedDTS Microsoft.SqlServer.PipelineHost What is certan that they aren't installed within the GAC in my case, so where could I find them? I have SQL server 2008 entrprise edition Other question, should I use Microsoft.SqlServer.Dts.Design and  Microsoft.SqlServer.ManagedDTS which are missed too, or they are part of the 2005 version only Thank you   The complexity resides in the simplicity

newbie in Java .... java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Hi All, I am new to java, trying to learn and understand. I downloaded the 2008 R2 SQL server Express, Downloaded the JDBC jar file, unzipped it. and set class_path accordingly in environmental variables. C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc.jar, C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc4.jar Also I have added the sqljdbc_auth.dll in the system32 file as most of the content suggested. I tried running a simple program that microsoft has provided . I have not advanced to programs such as eclipse and others, I am using a simple textpad to write and see if it connects the way it is supposed to . I hope you can guide me through the process. My TCP/IP is enabled, dynamic ip is left to blank, I can successfully telnet to 1433 port . Am I doing something wrong or am I missing a step somewhere   import java.*; public class Connect{      private java.sql.Connection  con = null;      private final String url = "jdbc:microsoft:sqlserver://";      private final String serverName= "localhost";      private final String portNumber = "1433";      private final String databaseName= "Banking";      private final String userName = "sa";   &nb

Problems with SMO 2008 Redist + Microsoft.SqlServer.BatchParserClient

Hi,    I'm trying to run my application using SMO 2008. Everything works just fine if i have sql 2008 server installed.   My problem starts when I try to use SMO 2008 Redist. First it does not install Microsoft.SqlServer.BatchParserClient or Microsoft.SqlServer.BatchParser. After a little research, I found that this is a problem and that these files have to be copied manually to the folder where the application runs.  So I tried copying the files: No luck, i get a Could not load file (Below).  Then i tried to adding these files to the GAC manually: Same thing, Could not load file:   Code Snippet Microsoft.SqlServer.Management.Smo.FailedOperationException: ExecuteNonQuery failed for Database 'DB2008'.  ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)        Then I looked at the version of the files and they seemed to be version, so I went to my app.config and added a bind redirection from to now it finds the assembly but says that Manifest doesnt mach the reference:   Code SnippetMicrosoft.SqlServer.Management.Sm

REBUILDDATABASE and Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException

I am trying to rebuild the master database in SQL 2008 x64 using the following command: setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=instance_name /SQLSYSADMINACCOUNTS= accounts  [/SQLCOLLATION=collation_name] and I get the following error: Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException     Message:          The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. Any idea? Thanks Frank Russo

Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'



I've seen several posts on this forum about this issue, and several have been resolved, but I'm not seeing the answer.

On my Windows 7 machine with SQL Server 2008 R2, I have a Visual Studio 2010 project that uses SQL SMO.

The app runs fine on my machine, but when I publish to another server, I get Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'

If I go to http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

and install Microsoft SQL Server 2008 Native Client , Microsoft SQL Server System CLR Types , and Microsoft SQL Server 2008 Management Objects I stop getting the error.

It seems to me that I should just be able to properly reference what I need and deploy my project...

So- how do I deploy my project without needing these installs?


In His service,
Steve Gray MCDBA
Vice President, 4Penny.net
www.VSToolsForum.com - Dynamics GP development forum
www.devshed.us - Coding blog

sqlserver Question for you


Respected sir,

i ll searching the records will be present in the table by using the like operator...here i had no problam,

i am geting an iisue is while i searching the records with unicode character i am geting no records but in the table i ll have approriate records...

how i can search the records with like operator with unicode characters...

i am writing ------select * from emp where empname like 'k%'---->no problam....

select * from emp where empname like '?%'------>here the problam......

Question on Microsoft Enterprise Library 5.0 for a mobile web application



Our company is in the process of building a new website dedicated for mobile devices.

Since we are starting from scratch, I would like to consider implementing the Microsoft Patterns & Practices Enterprise Library 5.0 on the site.

I would like to ask others what they think

1) Is this too much overhead where speed is mission critical?

2) Have you implemented this library for a mobile site? If so, why? Please describe your experience.

3) Given time and resources, would you implement this library?

I appreciate all feedback



Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=, Culture=


I am trying to use SQL Server 2008 Developer on Windows Server 2008.  Whenever I try to connect to the server, I get this error: "Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."

I found some info at http://blogs.msdn.com/b/ashishme/archive/2009/08/15/could-not-load-file-or-assembly-microsoft-sqlserver-diagnostics-strace-version-10-0-0-0-culture-neutral-publickeytoken-89845dcd8080cc91-or-one-of-its-dependencies-the-system-cannot-find-the-file-specified.aspx, but this didn't help me because it is not on my system, even after reinstalling both SQL Server and .NET Framework 4.  I also saw a this page: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/1115cd55-721d-4974-99b1-d142d1e6a927, but this also didn't fix my problem.

What can I do, or where can I get the missing assemble

On Change:Prevent Evaluation fails with error Could not load file or assembly 'Microsoft.SqlServer.


Hi All,

I am facing a strange issue with Policy Based Management. Exact problem is as below

SQL Setups


I have Lenovo laptop having 3 SQL instances installed on it.

SQL Server 2005 (x86) Developer Edition 9.00.4053  -- Named Instance : SQL2K5

SQL Server 2008 (x86) Developer Edition 10.0.1600.22 -- Named Instance : SQL2K8

SQL Server 2008 R2 (x86) Developer Edition 10.50.1600.1 -- Named Instance : SQL2K8R2


I configured SQL2K8R2 instance as a Centralized Server and registed SQL2K8 & SQL2K5 under this. I configured a new condition by using facet: MULTIPART NAME. As per this condition Table Should start with TEST_ in database TEST . Evaluation Mode set to              On Change: Prevent. Idea is if some one logs to database TEST and tries to create table with name other then starting with TEST_ then it should fail.

I Imported this policy on registered servers thru Centralized Management Server Action, as expected policy got configured on Registred SQL2K8 instance

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend