Cannot load file..another DLL Hell

I got Visual Web Dev Express 2008 for my day job ( because it is free know ), when I tried to create a connection through SQL Datasource or Entity Model or LINQ or any means through editor, I get the below error saying, but no clue..but luckily google saved my time.

"Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified."

The quick fix is, download the below 3 setup and install to get rid of this error.
            Microsoft SQL Server System CLR Types
            Microsoft SQL Server 2008 Management Objects
            Microsoft SQL Server 2008 Native Client

Download –http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist

Know more about- SQL Server 2005 default Database.

Hi all, Since my new project task requires me to learn SQL Server 2005 stuffs..right now I’m into Sql server learning…here is the snippet of my learning..SQL Server 2005 default databases are- master,model,msdb and tempdb.

(1)master -composed of system tables that keeps track of server installation as a whole and all other databases that are subsequently created. The SQL Server Management Studio query window defaults to the master database context. Any queries executed from the query window will execute in the master database unless you change the context.

(2)model -template database. Every time a new database is created, SQL Server makes a copy of the model database (and all of the objects in it) to form the basis of the new database. If you want all your new databases to inherit certain properties, you could include these properties and objects in your model database.

(3)msdb -contains the metadata and database objects used by the SQL Server agent that performs scheduled activities such as backups and replication tasks.

(4)tempdb -temporary database or workspace recreated every time SQL Server is restarted. tempdb is used for temporary tables created by users and to hold intermediate results created internally by SQL Server during query processing and sorting.

Catch you all with more stuffs…

Try Microsoft® SQL Server™ 2005 assessment test –!!

 

Discover now..!!!

(a) Introducing Microsoft® SQL Server™ 2005 for Database Administrators

to determine how much you know about the new features of Microsoft® SQL Server™ 2005.

(b) Introducing Microsoft® SQL Server™ 2005 for Database Developers

to determine how much you know about the new features of Microsoft® SQL Server™ 2005.

(c) Introducing Microsoft® SQL Server™ 2005 for Business Intelligence Developers

to determine how much you know about the new features of Microsoft® SQL Server™ 2005.

 

take assessment : http://assessment.learning.microsoft.com/test/home.asp

SQL server 2005 – Books Online for download

SQL Server 2005 CTP June 2005: Books Online – English (110 MB)

• Setup& upgrade instructions
• Info about new features
• Features supplied by SQL Server 2005
• How to use the SQL Server 2005 features
• Doc for the graphical tools, command prompt utilities, programming languages, and APIs that are supported by SQL Server 2005
• Descriptions of the sample databases and applications included with SQL Server 2005

Direct download from _ >

http://www.microsoft.com/downloads/details.aspx?FamilyId=F0D182C1-C3AA-4CAC-B45C-BD15D9B072B7&displaylang=en

Mahe~

Microsoft Sets Launch Date – NOV 7/2005

Microsoft Sets Launch Date for SQL Server,Visual studio and Bizstalk server  2005

 Countdown to launch has begun !

SQ.Server(TM) 2005, V.Studio® 2005 and Biz.Server 2006 will launch the week of November 7 –  Officially announced.

Microsoft also had more than 40 partners announce support for Visual Studio 2005 and SQL Server 2005 today. It also continues to deploy SQL Server 2005 and Visual Studio 2005 internally.
Microsoft have more than 80 applications in production using SQL Server 2005 today, with 10 instances of SQL Server 2005 that are storing multiple terabytes of data. These SQL Server 2005 installations have been responsible for processing more than 7 billion transactions against their SAP system SQL Server 2005 database to date, which includes processing close to 3 million invoices and more than 1.6 million sales orders.
This news has been announced in TECHED 2005. for more info…http://techedbloggers.net/

 

Mahe~

SN Informtics 🙂

149 Articles about SQL server from FTPOnline–good collection

All about SQL Server in 149 Articles :

Check out these essential articles on SQL Server for programming and administration needs. http://www.ftponline.com/resources/spcollections/sql/default.asp