.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

Microsoft.SqlServer.Management.Sdk Error

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :ASP.Net

I have a SQL Server 2000 database.  I am trying to ssetup a sqldatasource in Visual Web Developer 2008 Express.  I get an error saying "Microsoft.SqlServer.Management.Sdk.Sfc cannot be loaded".  Everything I can find says this is related to 2005 or 2008.  Any ideas what I can look for?




View Complete Post

More Related Resource Links

Microsoft SqlServer 2008 Management SqlStudio Error


I am just installed SqlServer 2008 and then i am getting error when i am exploring server in Management Studio

OS Windows 7 Home Premium.

I and then when i am lunched Management studio there am getting popup window with the willowing error:

Value cannot be null.
Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

Here is detailed information of this error:


Value cannot be null.
Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

Program Location:

at Microsoft.SqlServer.Management.SqlStudio.Explorer.ExplorerViewDescriptor..ctor(IFactoryService factoryService, INavigationViewInfo viewInfo, String urnPath, IDictionary`2 allEntities)
at Microsoft.SqlServer.Management.SqlStudio.Explorer.NavigationService.GetView(String urnPath)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.<GetColumnsFromNavigationService>d__f.MoveNext()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.AddFields(List`1 list, IEnumerable`1 fields, IDictionary`2 allValidFields, AddFieldsFlags flags)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.GetF

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.

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?

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

System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseColl


Hi All,

I am getting the following error while trying to invoke a DB JOB from my application code.

System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91

I have installed my code in application server and the DB where the sql jobs are installed is in another server. (Different physical servers).

When I analysed, I could see that the Application server has Microsoft.SqlServer.Smo version in its GAC. The DB server has got both and versions of the same DLL in its GAC.

I wonder whether this can cause the issue.

Any help is appreciated.

With regards,

Using Microsoft.SqlServer.Management.Smo to backup from remote SQL Server to local drive.


I'm trying to use the Microsoft.SqlServer.Management.Smo class to connect to a remote SQL Server, perform a backup and save it to my local drive.

I currently can only connect to a remote SQL Server and backup and save the backup file to the remote SQL Server drives. The same happens when I connect to a local instance of SQL Server and backup a file, I can only save it to my local drive.

Is there a way to specify to the Microsoft.SqlServer.Management.Smo to save to the [local] or [remote] machines?

Patrick Miron

For more about Microsoft.SqlServer.Management.Smo, check out my other thread at http://social.msdn.microsoft.com/Forums/en-CA/sqlgetstarted/thread/656d522a-06a6-4475-8070-93df75ef83a5

Error in connecting to SQLServer 2005 from Management studio and neither able to start sql service


I had been using SQL server 2005 without any problem but a few days back I started having some problem with my Windows XP Professional sp2 that my pc used to go off after 5-7 mins everytime i started it. So I repaired the OS. Since then,when i opened SQL Server and tried to connect am getting this error---

TITLE: Connect to Server

Cannot connect to POONAM-C586A95C\SQLEXPRESS.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I checked the state of sql serverand it is stopped. What should I do to bring it to running state?

I even added sqlservr exe file to the exceptions in the firewall but i dont think that could hav been a problem b'coz it was working perfectly without any changes in the firewall setting.

Why am I getting this error and how can I remove it?

Please help.

Garbage Collection-Part 2: Automatic Memory Management in the Microsoft .NET Framework


The first part of this two-part article explained how the garbage collection algorithm works, how resources can clean up properly when the garbage collector decides to free a resource's memory, and how to force an object to clean up when it is freed. The conclusion of this series explains strong and weak object references that help to manage memory for large objects, as well as object generations and how they improve performance. In addition, the use of methods and properties for controlling garbage collection, resources for monitoring collection performance, and garbage collection for multithreaded applications are covered.

Jeffrey Richter

MSDN Magazine December 2000

Garbage Collection: Automatic Memory Management in the Microsoft .NET Framework


Garbage collection in the Microsoft .NET common language runtime environment completely absolves the developer from tracking memory usage and knowing when to free memory. However, you'll want to understand how it works. Part 1 of this two-part article on .NET garbage collection explains how resources are allocated and managed, then gives a detailed step-by-step description of how the garbage collection algorithm works. Also discussed are the way resources can clean up properly when the garbage collector decides to free a resource's memory and how to force an object to clean up when it is freed.

Jeffrey Richter

MSDN Magazine November 2000

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

Microsoft JScript runtime error: 'Parent' is null or not an object


Hi friends,

        I got This Error : Microsoft JScript runtime error: 'Parent' is null or not an object

 In runtime,after  click on the check box, It Show "Microsoft JScript runtime error: 'Parent' is null or not an object"

<script language ="javascript" type ="text/javascript" >
        function SelectAllCheckboxesSpecific(spanChk)
           var IsChecked = spanChk.checked;
           var items=0;
           var Chk = spanChk;
              Parent = document.getElementById('gvUsers');          
              var items = Parent.getElementsByTagName('input');                         
              for(var i=0;i<items.length;i++)
                  if(items[i].id != Chk && items[i].type=="checkbox")
                      if(items[i].checked!= IsChecked)

please verify it. 

Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET F

I downloaded the the .Net Framework 3.5 from Microsoft and I am trying to install the .Net Framework 3.5 in a clean Windows Vista Ultimate installation but it fails. The dd_dotnetfx35error file shows:   [03/08/08,19:05:35] Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET Framework 2.0SP1 (CBS). MSI returned error code 1[03/08/08,19:05:46] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0SP1 (CBS) is not installed. Thank you for your help.

Microsoft .NET Framework Error

I just purchased a Compaq Presario CQ62 and already its says that Microsoft .NET Framework 2.0 is required to continue and this it gives a website to download the framework. Yet, I go to the website, download it, and once installation starts, it says that its alrdy installed. I cant find where to uninstall the software. I dont want to delete the incorrect thing and mess up my new computer! I have downloaded the x64 version.

Microsoft.ApplicationBlocks.Updater.Downloaders 64 bit error

Hello, I have a application that uses applicationblocks updater.  It works great on 32-bit machines, but when a 64-bit machines uses it I get the following error: Exception Source:      Microsoft.ApplicationBlocks.Updater.Downloaders Exception Type:        System.TypeLoadException Exception Message:     Could not load type 'Microsoft.ApplicationBlocks.Updater.Downloaders.BG_BASIC_CREDENTIALS' from assembly 'Microsoft.ApplicationBlocks.Updater.Downloaders, Version=, Culture=neutral, PublicKeyToken=null' because it contains an object field at offset 4 that is incorrectly aligned or overlapped by a non-object field. Exception Target Site: SetBackgroundJobCredentials ---- Stack Trace ----    Microsoft.ApplicationBlocks.Updater.Downloader.DownloadManager.SubmitTask(task As UpdaterTask, maxWaitTime As TimeSpan)    Microsoft.ApplicationBlocks.Updater.ApplicationUpdaterManager.Download(selectedManifests As Manifest[], maxWaitTime As TimeSpan) I used reflection to check out the BG_BASIC_CREDENTIALS class and it looks like this: <StructLayout (LayoutKind .Explicit , Size :=&H10 , Pack :=4 )> _ Friend Structure BG_AUTH_CREDENTIALS ' Fields <FieldOffset (8 )> _ Public Credentials As BG_AUTH_CREDENTIALS_UNION <FieldOffset (4 )> _ Pu

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
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