.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

x64 vs x86 (can databases be opened by either?)

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


I just installed VS2010, which by default installed SQL Express 2008 x64. I am part of a team of developers, some of which will only have the 32bit version of SQL Express installed. I went ahead and ran the x64 upgrade process to install R2.

My question is: Can databases created by SQL Express 2008 R2 x64 be opened in the 32bit version of SQL Express 2008 R2?


View Complete Post

More Related Resource Links

Toolbox: Manage databases, easier FTP, and clustered caching


This month's products include DatabaseSpy, FileZilla, NCache, and more.

Scott Mitchell

MSDN Magazine October 2007

Toolbox: Analyze HTTP Traffic, Synchronize Databases, and More


Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.

Scott Mitchell

MSDN Magazine April 2006

Linq with two databases (oracle and sql server)


i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?


Creating Web Databases with Access 2010 and Access Services (Visual How To)

Watch the video and explore code as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Sample: Creating Web Databases with Access 2010 and Access Services

Explore the code in this visual how-to article as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Video: Creating Web Databases with Access 2010 and Access Services

Create an Access 2010 Web database and publish it to SharePoint Server 2010 by using Access Services. (Length: 7:45)

Video: The Access Show: Managing Access Databases with SharePoint

Steve Greenberg recently gave a great talk at the SharePoint Developers Conference about how Access 2010 and Access Services enable organizations to provide better oversight of Access development. Steve and Clint walk you through the key points of this hit session. (Length: 42:57)

Video: The Access Show: Demo of Microsoft Access 2010 Services and Web Databases

Ryan McMinn and Clint Covington have a big announcement for us - Access Services is new functionality as part of SharePoint 2010 that allows users to create databases with forms and reports that run in the browser. (Length: 24:00)

removing guest account from sql 2005 databases

I cannot remove the guest account from my databases.  I know that I cannot and should not remove the guest account from master and tempdb.  but when i try to remove it from other databases I get some message about the guest account being a in schema or something like that.  so what should i do? thanks

Joining tables from 2 SQL Server CE databases

Is it possible to join 2 or more tables in different SQL Server CE databases? I am currently using VB.NET 2008 and SQL Server CE 3.5.

Running a single SQL update query on multiple foxpro databases

Hi, Env : SSIS 2008 My requirement is to run a update SQL statement on multiple foxpro databases. The fox database paths are available in a SQL server table.  I've created a for each loop control and assigned the database path to a variable named dbpath. Within the loop, I added an "execute sql task" control. Now what properties are to be set to get the requirement done. Appreciate any help. Regards. BH  Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

Can we have RoleProvider and MembershipProvider connect to different types of databases?

Say for my ASP.NET application, I have implemented my custom RoleProvider by using my existing Users table on my Oracle 11g database.Then, for my Membership Provider, can I still use the AspNetSqlMembershipProvider that comes with the .NET framework and uses SQL Server?Please share your 2 cents. Thank you.

Combining databases with Identity columns

(Using SQL Server 2005)  I have only a basic knowledge of SQL Server, but need to roll up 5 SQL databases into one database (I guess this is known as "replication"?).  These database are of similar structure and make use of an identity (or autonumber) column.  These id's are also referenced in numerous child tables.  To avoid collisions, this is my plan:   1.  turn off the identity feature of all the columns (but still keep condition of uniqueness) 2.  For each database, assign a unique range of identities (ie, db1 gets 1-500, db2 gets 501-1000, etc) and then renumber these columns accordingly.  The new id's should cascade to the child tables via the table relationships. 3.  Replicate or copy the data of all 5 databases into the new one.  There should be no collisions. 4.  Turn back on the identity feature of the appropriate columns, hopefully everything works as before. After this is done we hopefully can get rid of the 5 original databases and proceed with just one. Should this work and/or is there a better way to do this?  

Trigger a macro anytime a site or web is opened in SharePoint Designer

Within SharePoint Designer (not interfacing with SharePoint services), I would like to have a macro automatically run anytime a web is opened. I assume I need to use the OnWebOpen VBA event but I'm not sure how to write this into a module. Is there any chance someone could assist me with what this sub routine should look like? Thank you! Greg

Browse Button - Creating Mailbox Databases

Hey, Another question.  I have installed exchange 2010 as per the guide.  One issue I experience is When I try creating a new Mailbox Database, it does not give me the browse button to create the database on another drive. Should there be one, even though the instructions  says to Click the Browse button to select the drive where I want the database to reside? Thanks in advance Andrew  
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