Click here to Skip to main content
15,908,455 members
Home / Discussions / Database
   

Database

 
QuestionAppend data within XML file using form Pin
gdmoland9-Apr-12 8:56
gdmoland9-Apr-12 8:56 
AnswerRe: Append data within XML file using form Pin
Mycroft Holmes9-Apr-12 12:42
professionalMycroft Holmes9-Apr-12 12:42 
QuestionDatabase Pin
Ngobi Arthur8-Apr-12 5:57
Ngobi Arthur8-Apr-12 5:57 
AnswerRe: Database Pin
PIEBALDconsult8-Apr-12 6:03
mvePIEBALDconsult8-Apr-12 6:03 
GeneralRe: Database Pin
gdmoland9-Apr-12 9:13
gdmoland9-Apr-12 9:13 
GeneralRe: Database Pin
PIEBALDconsult9-Apr-12 9:25
mvePIEBALDconsult9-Apr-12 9:25 
AnswerRe: Database Pin
Eddy Vluggen9-Apr-12 10:36
professionalEddy Vluggen9-Apr-12 10:36 
AnswerCant see database in SSE after importing with SSMA[solved] Pin
Richard.Berry1006-Apr-12 19:34
Richard.Berry1006-Apr-12 19:34 
I'm trying to import an Access 2007 db using the SQl Sever Migration Assistant into a SQL Sever 2008 Express database. All the steps work fine in the migration assistant, and in the pane on the lower left I can even see the db in the target server, but when I open the SQL Sever Express db with SQL Sever Management Studio, the db is not there?

I can browse the following folder from windows and I can see the MDF file, but if I try to attach the db, I can browse as far as the DATA folder, but I cant open it to select the actual db.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\simmstock.mdf

Also if I try to move the mdf file, Windows wont allow it because it is being used by SQL Server???

Solved: I had another instance of SQL server installed on the machine that I was not even aware of Smile | :) (probably from a Visual Studio Installation) and I had migrated the Access database to the wrong server instance

modified 8-Apr-12 10:44am.

QuestionGet a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 4:26
Richard.Berry1006-Apr-12 4:26 
AnswerRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 4:33
mvePIEBALDconsult6-Apr-12 4:33 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 5:04
Richard.Berry1006-Apr-12 5:04 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 5:11
mvePIEBALDconsult6-Apr-12 5:11 
AnswerRe: Get a datarow with a query OLEDB - VB.net Pin
Eddy Vluggen6-Apr-12 6:02
professionalEddy Vluggen6-Apr-12 6:02 
Questionsql server Pin
hamakhoshi5-Apr-12 23:01
hamakhoshi5-Apr-12 23:01 
AnswerRe: sql server Pin
Mycroft Holmes5-Apr-12 23:14
professionalMycroft Holmes5-Apr-12 23:14 
AnswerRe: sql server Pin
PIEBALDconsult6-Apr-12 3:28
mvePIEBALDconsult6-Apr-12 3:28 
QuestionMerget Replication Issue Pin
Ahmed Barradah5-Apr-12 9:37
Ahmed Barradah5-Apr-12 9:37 
AnswerRe: Merget Replication Issue Pin
Mycroft Holmes5-Apr-12 12:58
professionalMycroft Holmes5-Apr-12 12:58 
QuestionSSIS Development Workflow Pin
cjb1105-Apr-12 0:26
cjb1105-Apr-12 0:26 
AnswerRe: SSIS Development Workflow Pin
PIEBALDconsult5-Apr-12 5:03
mvePIEBALDconsult5-Apr-12 5:03 
AnswerRe: SSIS Development Workflow Pin
Mycroft Holmes5-Apr-12 12:55
professionalMycroft Holmes5-Apr-12 12:55 
GeneralRe: SSIS Development Workflow Pin
cjb11013-Apr-12 0:21
cjb11013-Apr-12 0:21 
QuestionCan Not Resolve The collation Conflict Pin
yousefshokati1-Apr-12 19:02
yousefshokati1-Apr-12 19:02 
AnswerRe: Can Not Resolve The collation Conflict Pin
Bernhard Hiller1-Apr-12 21:26
Bernhard Hiller1-Apr-12 21:26 
QuestionHow do you lock records in Access 2007 Pin
Richard.Berry1001-Apr-12 9:14
Richard.Berry1001-Apr-12 9:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.