Click here to Skip to main content
15,900,461 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL to get DataTypes Pin
John-ph30-Sep-07 23:21
John-ph30-Sep-07 23:21 
QuestionMaking columns to rows in SQL Pin
Trav128-Sep-07 2:28
Trav128-Sep-07 2:28 
AnswerRe: Making columns to rows in SQL Pin
Farhan Noor Qureshi28-Sep-07 9:59
Farhan Noor Qureshi28-Sep-07 9:59 
QuestionMicrosoft OLE DB Error Pin
paresh_joe28-Sep-07 2:04
paresh_joe28-Sep-07 2:04 
AnswerRe: Microsoft OLE DB Error Pin
originSH28-Sep-07 2:11
originSH28-Sep-07 2:11 
GeneralRe: Microsoft OLE DB Error Pin
paresh_joe28-Sep-07 2:40
paresh_joe28-Sep-07 2:40 
GeneralRe: Microsoft OLE DB Error Pin
pmarfleet28-Sep-07 2:46
pmarfleet28-Sep-07 2:46 
QuestionDatabase status during Database Refresh operation - Help required Pin
sarayumadhavan28-Sep-07 1:20
sarayumadhavan28-Sep-07 1:20 
Hi,

I am need of information regarding Database status during Database Refresh operation in sql server 2000.

The application uses 2 DB’s say db1 and db2. The db1 (read-write) and db2 (read only) resides in the server1. The db2 resides in server2 also.

Requirement: When the db2 in server1 is down i.e., when the DB refreshes, it throws an error and the application will not be able to access the DB tables. In that case, we should connect to the server2 and access db2.

Problem: In order to switch from server1 to server2, first we should check the status of db2 during refresh in server1.

Error during DB refresh:
Msg 927, Level 14, State 2, Line 1
Database 'Database_name' cannot be opened. It is in the middle of a restore.

If we can find the status of DB during refresh operation, this scenario can be handled and can be switched to server2.

Thanks,
Sarayu



Sarayu
AnswerRe: Database status during Database Refresh operation - Help required Pin
Paul Conrad2-Oct-07 10:23
professionalPaul Conrad2-Oct-07 10:23 
QuestionSQL Query Pin
Ashish_Sood28-Sep-07 0:55
Ashish_Sood28-Sep-07 0:55 
AnswerRe: SQL Query Pin
andyharman28-Sep-07 1:57
professionalandyharman28-Sep-07 1:57 
AnswerRe: SQL Query Pin
sarayumadhavan28-Sep-07 2:03
sarayumadhavan28-Sep-07 2:03 
QuestionSQL Express Installation Problem While Deploy .NET Poject Pin
ahsansharjeel27-Sep-07 21:55
ahsansharjeel27-Sep-07 21:55 
AnswerRe: SQL Express Installation Problem While Deploy .NET Poject Pin
Farhan Noor Qureshi28-Sep-07 9:53
Farhan Noor Qureshi28-Sep-07 9:53 
GeneralRe: SQL Express Installation Problem While Deploy .NET Poject Pin
ahsansharjeel28-Sep-07 17:31
ahsansharjeel28-Sep-07 17:31 
QuestionHow can I recover the Database.? Pin
pubududilena27-Sep-07 21:37
pubududilena27-Sep-07 21:37 
AnswerRe: How can I recover the Database.? Pin
pmarfleet27-Sep-07 21:59
pmarfleet27-Sep-07 21:59 
QuestionMySQL to MsSQL Converter Pin
totocaster27-Sep-07 21:24
totocaster27-Sep-07 21:24 
AnswerRe: MySQL to MsSQL Converter Pin
originSH28-Sep-07 2:15
originSH28-Sep-07 2:15 
AnswerRe: MSQL Programmer Needed Pin
Colin Angus Mackay27-Sep-07 18:48
Colin Angus Mackay27-Sep-07 18:48 
QuestionDATE COMPARISON In JET SQL QUERY Pin
Nadia Monalisa27-Sep-07 12:08
Nadia Monalisa27-Sep-07 12:08 
QuestionCalling a web service from SQL [modified] Pin
DerekFL27-Sep-07 7:24
DerekFL27-Sep-07 7:24 
QuestionHow to set ExitCode for SQL Job Pin
alex.almeida27-Sep-07 6:04
alex.almeida27-Sep-07 6:04 
AnswerRe: How to set ExitCode for SQL Job Pin
DerekFL27-Sep-07 8:41
DerekFL27-Sep-07 8:41 
Questiondatabase select query probem Pin
Nishad8527-Sep-07 4:49
Nishad8527-Sep-07 4:49 

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.