Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

Cannot load file..another DLL Hell

I got Visual Web Dev Express 2008 for my day job ( Angry 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

Advertisements

May 6, 2009 Posted by | SQL SERVER - My Own code | Leave a comment

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…

February 6, 2007 Posted by | SQL SERVER - My Own code | 1 Comment

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

July 19, 2005 Posted by | SQL SERVER - My Own code | 1 Comment

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~

June 13, 2005 Posted by | SQL SERVER - My Own code | Leave a comment

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 🙂

June 8, 2005 Posted by | SQL SERVER - My Own code | Leave a comment

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

May 18, 2005 Posted by | SQL SERVER - My Own code | 1 Comment

Few Peformance Queries – Sql 2000

5 Performance Queries – SQL SERVER 2000

1. Use "TRUNCATE TABLE  <tname>” instead of “ DELETE from <tname>”
If you want to delete all rows in a table use q2 for better performance –

q1 :delete from <tname>
q2 :truncate table <tname>

TRUNCATE TABLE – frees up space of tables data,indexes etc without log row deletes.

2. Never use [sp_ ] as prefix for stored proc’s – its reserved prefix. SQL server searches for a stored proc with [sp_ ] prefix in the system procedures first,and after that looks for them in client procs. 

3. There are thousands of examples for count(*),but q2 is faster to achieve the same count operation. here is my query tested in my PC…

    q1:select count(*) from pcl
    q2:select rows from sysindexes where id= OBJECT_ID(‘pcl’) and indid <2

4. Add "SET NOCOUNT ON ” statement in stored proc to reduce network traffic.
 
Tested this queries in my QA…it will be helpful,who are all talking with SQL daily in poor bandwidh. I just added this queries in my Query files already saved.

5. BETWEEN instead IN,
 Example Q1:
  SELECT clt_id
   FROM pcl
    WHERE clt_id BETWEEN 1 AND 10

 Example Q2:

  SELECT clt_id
   FROM pcl
    WHERE clt_id IN (1, 2, 3, 4,5,6,7,8,9,10) 

 Q1 is a best query when you think performance wise

Comment,if any one knows more than this…………………

Mahe~
Src: Read somewhere yesterday in book

April 15, 2005 Posted by | SQL SERVER - My Own code | 1 Comment

Mistakenly deleted ….how to recover

Yesterday, gr8 mistake was happened with SQL Server 2000….yes, mistakenly deleted a table values….how to recover..?? It was a great puzzle for me. we have called sql support gurus, no proper help. so i decided to post in group. i got reply, but not yet solved. again i have to debug for option if any.

Mahesh~SIS

——————————————Here is my mail and answer i got ———————

~Maheshkumar.R" <mfcmahesh@hotmail.com> wrote in message
   news:OegPcypOFHA.2736@TK2MSFTNGP09.phx.gbl
Hi groupz, 

while testing, i have deleted online table values, instead local server. Is
there any command to get back those deleted rows frm that table.
i have used, delete from table where b_id=’ ‘

it deleted all the 150 rows, which i have to recover. please suggest me some
recovery command if any..

Mahes~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~“`
Re: mistakenly deleted a table values….how to recover..

Hi,

You can doa point-in-time restore if you have backup and ur database
recovery is set to FULL.

Steps:-
1. Perform a transaction log backup of the original database (If you have
not performed one)
2. RESTORE DATABASE TEST1 FROM Backupfile(Give the correct backup file /
device name) WITH NORECOVERY
3. Restore the subsequent transaction log files in order of backup WITH
NORECOVERY option till the final transaction log file
4. In the the final transaction log restore mention WITH RECOVERY and
STOPAT=’date and time’

Note:
To perform a POINTIN-TIME-RECOVERY your database must be in FULL recovery
model.

Thanks
Hari
SQL Server

 

Thnkz to Hari,Sql server for sharing his comment.

 

April 7, 2005 Posted by | SQL SERVER - My Own code | Leave a comment

Text file creating in SQL ?

Actually i searched for code snippet for creating textfile as output from SQL query. here is the good one i got from msnewsgroup reply http://www.aspfaq.com/show.asp?id=2482

 

March 16, 2005 Posted by | SQL SERVER - My Own code | Leave a comment

Sql tricky queries

Here is the few queries, i tried and collected from some sql websites…

use salesport
EXEC Master..xp_cmdshell ‘Dir c:\’
/* 1.FOR DISPLAYING ALL THE TABLES IN A DATABASE */
SELECT * FROM INFORMATION_SCHEMA.TABLES

/* 2.FOR DELETING FILES FROM SQL */
EXEC master..xp_cmdshell ‘del C:\MAHE.txt’

/* 3. Use Sysobjects in SQL Server to Find Useful Database Information */
select * from sysobjects where xtype=’U’

/*4.to check sql service starting time */
SELECT crdate AS ‘SQL Server service started approximately at:’
FROM master.dbo.sysdatabases
WHERE name = ‘tempdb’

/*5.  to display date */
SELECT CONVERT(char,GETDATE(),107)
SELECT CONVERT(char,GETDATE(),106)
SELECT CONVERT(char,GETDATE(),105)
SELECT CONVERT(char,GETDATE(),104)

/*6.How to get the first day of the week, last day of the week and last day of the month using T-SQL date functions? */

DECLARE @Date datetime
SET @Date = ‘2001/08/31’

SELECT DATEADD(dd,-(DATEPART(dw, @Date) – 1),@Date) AS ‘First day of the week’
SELECT DATEADD(dd,-(DATEPART(dw, @Date) – 7),@Date) AS ‘Last day of the week’
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,@Date)),DATEADD(m,1,@Date))) AS ‘Last day of the month’

/*7. showing all the device installed */
sp_helpdevice  

/*8. to show the db status */
sp_helpdb

content : original src: extremeexperts.com

Mahe~

March 15, 2005 Posted by | SQL SERVER - My Own code | Leave a comment

   

%d bloggers like this: