.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

Attaching to a non sqlserver database

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
hyi, is there any way of attaching to a complete dbisam database in sel server?  -  I have an odbc driver, and canm only get the import to work on one table at a time   ta

View Complete Post

More Related Resource Links

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?

SQL Server Management Studio is not attaching a database.

Hi folks,I'm a newbie in development, and i'm facing a grave concern here.  Sql Server Management Studio (2008) does not seem to be able to attach  a database that i've already created in Sql Server 2005 express within my ASP.NET application.  When I try to attach the database, by clicking "Attach" after right clicking the Database note in object explorer, I get to see a dialog box with an Add button.  I then click that button, and try to navigate to the database, and I'm simply not able to reach that folder!!! The folder containing the databse physically exists, but i can't see it when i'm trying to browse to it.This is a Windows 7 (home edition) laptop, with VS 2008.Can someone please help me here???Thanks!

Error in attaching database file and creating a new connection

I am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.Can anyone please tell me what is the problem I am facing?Here are the error message.1. Attach .mdf in SQL database file and open the database in Server Explorer2. Create a new SQL server and attach .mdf

Attaching the Config Database in SharePoint 2007 with STSADM

Hello, We've moved our MOSS 2007 dev environment SQL database to a new server and we're having trouble attaching the config database to SharePoint using stsadm so we can access central admin. Here is the command we're running: stsadm -o setconfigdb -connect -databaseserver kraspsqltest\mosstest -databasename wss_config -farmuser "farmaccountname" -farmpassword "farmpassword" When I run this command (obviously with the correct username and password), the only message I see is: Access denied. I've checked with our DBA and nothing on his end is blocking the command. I do see the following in the event log where the command is being run: "Unknown SQL Exception 10061 occured. Additional error information from SQL Server is included below. 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)" I've also noticed the folder containing the web.config file in IIS is no longer present on the MOSS server. Is this deleted when the config database is detached and added back when reattached? This server was working just fine prior to the database move

[298] SQLServer Error: 9001, The log for database 'tempdb' is not available.

I have SQL server 2000 standard edition running on Windows 2003 server. I am getting this error [298] SQLServer Error: 9001, The log for database 'tempdb' is not available. [SQLSTATE HY000] (ConnIsLoginSysAdmin) I have enough space and tempdb log file set  on unrestricted groeth. I don't know why I am getting this error

adding sqlserver database files in the time of project deployeement

hi all,        how can i add sql server 2005 database files in the time of a windows application project deployment i have designed a project in Visual Studio 2005 using vb.net language and i want add sql server 2005 database file to it. i am connecting to sql server database by the connection string not using any any dataset or anything else. so how can i add database file ... please replay... 

creating custom table in share point database in sqlserver is fine ?


we are creating custom table in share point database in sqlserver.

is it fine to create custom table?

are we violating any rule  because of the creation of custom table ?

does share point recommended to create custom table  ?

Insert html tage to sqlserver database through asp.net textbox(asp.net 2.0)


Insert html tage to sqlserver database through asp.net textbox

Display it lable control

Best regards

conversion from 4D (4th Dimension database) to sqlserver 2005?


Hi There,

 I am just wondering if any one can help give some ideas how to migrate from 4D Database to Sqlserver2005? if you are wondering what 4D is? its a ralational database but I very interested and keen to migrate the whole database ? any ideas on this would be much appriciated




Sqlserver 2008 R2 "eval version" installation failed. - reason :wait on the Database Engine recover


Please can someone assist me. I have installed twice and get the same result ( & uninstalled) Everything passed during pre install process but installs with failures. OS = Windows vista home basic

Database Engine Services  - failed

SQL Server Replication -failed

Full-Text Search -failed

Reporting Services -failed


Log details are below.

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893608
  Exit facility code:            1306
  Exit error code:               24
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:        &n

Microsoft SQL server 2005 database LDF MDF files attaching issue


Dear all,

Last month our Windows 2003 server hardware raid was failed, all live databases available on this raid partition, now we have recover all databases which MDF and LDF files.

 Below is the error snap link. http://cid-51b01a6564f704c6.photos.live.com/self.aspx/Kamran/Error%20Snap.png

We are in the process of attaching the Recovered Database “nice_interactions ” using .MDF and .LDF files; it prompts the Following error [Please view the snapshot below for reference]. Kindly advise further how to restore or attach database using .MDF and .LDF files which is not cleanly shutdown.

Microsoft SQL forwarding to following URL in the Detail of below  listed Error while we are trying to attach the recovered .mdf file.



Need help in this regards.

Kamran Khan


Attaching a 2007 content database to a 2010 Farm

I attached a 2007 content database to a 2010 farm. Is it possible for me to get the 2010 site templates on the sites in that content db?
James Grizzle

error while attaching database


hello, i am trying to attach database



sp_attach_db 'survey_p1174994', 'D:\survey_p1174994.mdf', 'L:\survey_p1174994.ldf' and I am getting the following error:



Script SQLServer - 2000 database


Hi Gurus,

I need your advice, how to go about the following task which i need to do

1) Create SQLSERVER 2000 database creation script. This will have script for all objects in database.

2) Update the header of each sql files based on the template provided.

for task 1 i can create the sql scripts using enterpirse console for sqlserver. Database have lot of indexes and table. how to find the logical sequence the sql scripts(with out hit and trial) ?

for task 2 do you know any documentaion utility  which can apply header template to each database object sql script ?




If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Rajender Saini Aditi Enterprise Solutions - Partnering Innovation | www.aditi.com

Problem attaching database to Cluster Volume?


I am currently working with a SQL 2005 SP3 2 node cluster. When I view my Drives, it looks appears like the following:


C: (System Drive)




Q: (Quorum)


The databases on this server have the Data file on J and the Log file on N.  I have noticed space getting a little tight , so I decided that I wanted to leverage the additional drive K since it is much bigger than either the J or N drives, but when I attempted t

Insert Image into Sqlserver database by using c# asp.net

Insert Image into Sqlserver database by using c# asp.net

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.
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