.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

Toolbox: Database job scheduling, Browser Analysis, and More

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

From a developer's perspective, once a database's schema has been defined and the tables, stored procedures, and other database objects have been created, it can be forgotten, abstracted away into the data access layer of the application's architecture.

Scott Mitchell

MSDN Magazine May 2006

View Complete Post

More Related Resource Links

Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More


If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009

Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs


This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009

Toolbox: Database Documentation, API for Pre- and Post-Conditions, Blogs and More


In this month's column, Scott explores one-click database documentation, covers an API for pre- and post-conditions, takes a look at an interesting blog, and reviews the latest book about the ASP.NET MVC Framework.

Scott Mitchell

MSDN Magazine November 2009

Toolbox: Static Analysis Tools For .NET, Matt Berseth's Blog


This month we take a look at FxCop and other tools that enforce your design rules, along with jQuery.

Scott Mitchell

MSDN Magazine December 2008

Toolbox: Online Scheduling, Jeff Smith's SQL Blog, Easy Regular Expressions, And More


This month Scott looks at improving development skills, writing regular expressions, a web scheduling control and a SQL tips blog.

Scott Mitchell

MSDN Magazine November 2008

Toolbox: Cross Browser Testing, Mock Objects, and Raymond Chen


This month test your web site on many platforms and browsers without setting up a test environment, use mock objects for unit testing, and visit Raymond Chen.

Scott Mitchell

MSDN Magazine June 2008

Toolbox: Database Audit Logs, Joel on Software, Code Handouts, and More


This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.

Scott Mitchell

MSDN Magazine May 2008

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Tool for quick Database Analysis

Hello, Is there any tool or way to check in SSMS which are the bigger tables and the % of the overall database they represent? Regards, Pedro

Migrate SQL2000 Anaysis database to SQL 2008 Analysis

When we try to migrate with the migration wizard we get this error. Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IPartition90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{F82195C2-53A0-41B5-B7D8-7D087BAE32CF}' failed    due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).   Thanks Jim

Analysis Services 2008 R2 Deployment - very frequent database overwrites

When regularly deploying an Analysis Services project from Visual Studio / BIDS to Analysis Services 2008 R2, the database must frequently be overwritten - on almost any change. For example, after a successful deploy and process, a seemingly minor change is made (e.g. changing the FormatString property for an existing Measure, or Arrange Tables in the Data Source View), and the next deploy and process attempt triggers the message: The 'ZZZ' database on 'ZZZ' has changed since the last time the project was deployed. If you proceed with deployment, the database will be overwritten. Would you like to continue? With earlier versions of SQL, this only occurred rarely, e.g. when deploying to a stale server. The impact is that testing almost any change requires a complete re-process of the database. Is anyone else striking this issue?  Thanks Mike

Migration / Export of Analysis Services 2000 database without affecting the source database

Hi! I´m am currently initating a migration of a 300GB Analysis Services database containing approx 50+ cubes. My issue is that the database is somewhat critical, and I just want to get a couple of answers and feedback before i press Go. My plan is to use the "Analysis Services Migration Wizard" to migrate the database to a new (test environment) server. Q1: I just want to migrate the structure, the metadata, is this what the migration wizard does? I don´t have 300GB disk space at the test server to accomodate all the data. We will start off with just a subset Q2: Since the data is 300GB+, it might take a very long time using the migration wizard. If that is the case, can I make a copy of the database in analysis manager 2000 and paste it with a different name, and the migrate this, empty, database? Would you see any trouble with this approach? Any other thoughts on this, somewhat massive, migration project? How would you do it? The most important this is that the old database cannot be touched, since this would mean a reprocess of 300GB data, on a server from the nineties... Cheers,

SQL Server Analysis Services Backup error "Errors in the metadata manager. Either the database with


I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool

<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xm
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of &#39;xyz_old&#39; does not exi
st in the server with the ID of &#39;ABCD\Sql_AS&#39;, or the user doe
s not have permissions to access the object."
Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>

I have tried using different account for impersonation but everything fails.

Any help would be really appreciated.


how to do sharepoint database disk usage analysis and selective replication?



I have a SharePoint 2007 database that is 16GB in size and I want to know why, and how I can reduce the size. Ideally I would like a trimmed replica to use as a developer workstation that retains a good sample data set, and has the ability to be refreshed.

Can you please tell me if there are any third party tools or other methods to accomplish this? I have found the Microsoft tool (stsadm) to be very limited in this regard.

Many thanks.

Deplying SQL Analysis service database using script problem with Impersonation


I have a problem with deploying SQL Analysis database from dev server to production , because I do not have an admin privileges , I cannot use Create script

The only action that I have , is to execute Alter Script against Any Empty database,


However I cannot use ImpersonateServiceAccount because it needs  Admin privileges

So, I always use ImpersonateCurrentUser as you know, I have to supply my credential.


are there any way that I can Deploy the db to the production  with the same impersonation type ImpersonateServiceAccount

as it was before?


thank you

Attach Database in Analysis Services 2005 (SSAS 2005)


Hi Guys,

I have some problem here..

I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..

does anybody have the script to attach the database?


Many thanks and regards...

Roland Andreas

Scheduling ssis package database 2000


Hi Team,

can i schedule a ssis package which is developed on 2000 database?

I have a sql server 2000 server and i am accessing this database using 2005 in another machine and developed a ssis package can i schedule this package?



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