Click here to Skip to main content
15,667,949 members
Home / Discussions / Database
   

Database

 
AnswerRe: default settings SQL Server does not allow remote connections. Pin
subai9-Jul-08 2:59
subai9-Jul-08 2:59 
QuestionHow to find the Table exists in a Data Base Pin
pallaka8-Jul-08 22:16
pallaka8-Jul-08 22:16 
AnswerRe: How to find the Table exists in a Data Base Pin
Ashfield8-Jul-08 22:47
Ashfield8-Jul-08 22:47 
GeneralRe: How to find the Table exists in a Data Base Pin
TheFM2349-Jul-08 4:46
TheFM2349-Jul-08 4:46 
QuestionChanging between mssql and access through connection string Pin
Y_R8-Jul-08 22:10
Y_R8-Jul-08 22:10 
AnswerRe: Changing between mssql and access through connection string Pin
Mycroft Holmes9-Jul-08 17:36
professionalMycroft Holmes9-Jul-08 17:36 
GeneralRe: Changing between mssql and access through connection string Pin
Y_R12-Jul-08 21:40
Y_R12-Jul-08 21:40 
GeneralRe: Changing between mssql and access through connection string Pin
Mycroft Holmes13-Jul-08 12:39
professionalMycroft Holmes13-Jul-08 12:39 
Y_R wrote:
But I don't create the queries manually

This where you have a problem. You are using the MS built in tools and therefore have only limited knowledge and understanding of the mechanics of the database and the DAL.

I suggest you completely reengineer your application to use a proper data access layer where you have control and understanding of the DAL and database operations.

As for
Y_R wrote:
Is there a way I can view the query created by it?

I have absolutely no idea (but would expect it to be there somewhere) as I have only used the built in stuff enough to identify what a disaster it can be.

BTW this is not a rant against you, everyone has to start somewhere and you have asked intelligent questions and shown a willingness to learn. Do some reasearch into DALs, there are plenty of examples around.

Never underestimate the power of human stupidity
RAH

GeneralRe: Changing between mssql and access through connection string Pin
Y_R13-Jul-08 22:53
Y_R13-Jul-08 22:53 
QuestionHow Can I Do This Select Statment Pin
Zeyad Jalil8-Jul-08 20:58
professionalZeyad Jalil8-Jul-08 20:58 
AnswerRe: How Can I Do This Select Statment Pin
Ashfield8-Jul-08 21:58
Ashfield8-Jul-08 21:58 
GeneralRe: How Can I Do This Select Statment Pin
Andy_L_J9-Jul-08 0:39
Andy_L_J9-Jul-08 0:39 
Questionnormalization terms Pin
Pankaj Garg8-Jul-08 19:18
Pankaj Garg8-Jul-08 19:18 
AnswerRe: normalization terms [modified] Pin
leoinfo9-Jul-08 4:08
leoinfo9-Jul-08 4:08 
QuestionMS Access Connection String Pin
kadkir8-Jul-08 17:41
kadkir8-Jul-08 17:41 
AnswerRe: MS Access Connection String Pin
Jack Brando8-Jul-08 19:19
Jack Brando8-Jul-08 19:19 
GeneralRe: MS Access Connection String Pin
kadkir8-Jul-08 19:35
kadkir8-Jul-08 19:35 
GeneralRe: MS Access Connection String Pin
Mycroft Holmes9-Jul-08 17:44
professionalMycroft Holmes9-Jul-08 17:44 
QuestionMS SQL Server Multiple Roles per User Pin
Jack Brando8-Jul-08 17:34
Jack Brando8-Jul-08 17:34 
AnswerRe: MS SQL Server Multiple Roles per User Pin
Ashfield8-Jul-08 22:03
Ashfield8-Jul-08 22:03 
QuestionCommunicating via Windows Service object Pin
Richard Blythe8-Jul-08 5:07
Richard Blythe8-Jul-08 5:07 
AnswerRe: Communicating via Windows Service object Pin
Pete O'Hanlon8-Jul-08 8:56
subeditorPete O'Hanlon8-Jul-08 8:56 
AnswerRe: Communicating via Windows Service object Pin
Mycroft Holmes9-Jul-08 17:47
professionalMycroft Holmes9-Jul-08 17:47 
QuestionDB2 Query Validation in C# Pin
Member 19917268-Jul-08 2:03
Member 19917268-Jul-08 2:03 
AnswerRe: DB2 Query Validation in C# Pin
Ashfield8-Jul-08 4:46
Ashfield8-Jul-08 4:46 

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.