| sql server 2008 Interview Questions and Answers |
|
|
So, I'm trying to make my own private server, (no, i'm not copying Citrix or anything along those lines) and my main problem is opening the file "MapleStoryServer.sln" in Microsoft Visual C++ 2008. And when it does open and debug it, it says "My SQL: failed."
Help please!
10 points!
|
|
|
|
Our FIRST robotics team is making a database for scouting, and our php is not working, we don't know what's wrong, because the "or die(mysql_error());" is not working. If we switch to a windows server and use ASP.NET / Microsoft SQL Server, will we be able to use breakpoints like the ones in visual basic to see what is going on during the running of the program? We only have Visual Studio Pro 2005, so 2008 tips won't help.
Thanks,
Joe
|
|
|
|
I need to make a software using Visual Basic as the frontend, and something like MS SQL Server or Access as the backend. Its a single user app, basically an Electronic Medical Records System for a single doctor. Which program versions do you suggest I should use for this? Visual Basic 2008 or VB6, and SQL server of Access, and if SQL server, which version of it. I wanna use software thats preferably relatively new, should offer all the functionality i need, but not be overkill for the simple application, and must be easy to deploy on a slow machine.
|
|
|
|
Well I'm trying to save some space on my computer and I've been going through my installed programs list and I found all these:
Microsoft SQL Server 2005
Microsoft SQL Server Compact edition [ENU]
Microsoft SQL Server 2008 Management Objects
Microsoft SQL Server Compact 1.5 SP1 Design Tools English
Microsoft SQL Server Compact 1.5 SP1 English
Microsoft SQL Server Native Client
Microsoft SQL Server Setup support files (english)
Microsoft SQL Server VSS Writer
Just wondering if they are all neccersary, or are some of them out of date and can be uninstalled or what?
|
|
|
|
im connecting ms sql server 2005 with vb.net 2008. so i have a table in the database called fee_table with columns fee_code, fee_name, fee_amount. fee_amount has a data type varchar(50), so when i view the data in a datagridview in vb.net, they will show as it is. how do i make fee_amount display in the datagridview such as if in the database it is written as 123456789.345 it will show in the datagridview as 123,456,789.35
oh yah i know theres a datatype in sql, money, so i used that but what happens is there's no comma and it has 4 decimal places fixed. >__< im formatting it for money by the way.
i kept researching online and applying the codes in vb but it wont work. no luck >__<
thanks in advance
|
|
|
|
I have already learned SQL using MySQL 5.0, now I want to learn SQL Server. However, I do not know where to start? When I went to Microsoft site, I just got confused. Should I learn Microsoft SQL Server 2005 or 2008? I know that only Microsoft SQL Server 2005 Express is free. So, if I learn the Microsoft SQL Server 2005 Express Edition, can I still claim that I know Microsoft SQL Server in my resume? Please let me know.
By the way, is there any video tutorial site for learning Microsoft SQL Server? If you know, please let me know. Thanks!
|
|
|
|
We are trying to utilize a similar architecture in using a Microsoft SQL server as is used by one of our company's subsidiaries. They use Microsoft server 2005 and I believe that server 2008 is currently available. Does anyone know of any incompatibility between SQL server 2005 and 2008? I believe we would be using XP on the system. We are trying to match the server architecture as our subsidiary but want to watch out for unforseen problems.
|
|
|
|
I have recently formatted the windows server and changed its name at our workplace. Now, the Sql Server 2008 which I used the login for the old domain on my computer requires that user which does not exists anymore. Any way I can re-connect to that server in an alternate method?
|
|
|
|
i m doing mca ignou and want to do sql server course which version will b the best as a fresher and for jobs as well?? And can anyone appear directly for the exams certification from Microsoft?? plz answer if anyone has some exp.....
|
|
|
|
I wanna make a program in Visual Basic 2008, that can access data in a SQL Server. I need some reference material to guide me through installation of SQL Server, creating and managing the databases, accessing them programatically through Visual Basic code, and deploying the databases. Can someone refer me to any books, or more preferably, websites or ebooks?
|
|
|
|
It is important please give me the resource link too.
|
|
|
|
If you have been studying 2005 I would stay with it. You think everyone you will try to hire with will be running the newest Microsoft database? No one trusts their data to new OS' without some bug testing first. You will get a great job if you complete the 2005 track.
|
|
|
|
Is there a SQL Server 2008 -Developer Edition?
|
|
|
|
i want to know, wheter it is necessary to install sql server 2008 before installing visual studio or it will work even if i install after intalling visual studio?
Please help i am trying this for 10th time becoz i there was problem of connection with sql serer 200, 2005 was installing always with errors on my laptop.
now i want to give my best shot... thanx for help
|
|
|
|
is there any difference in structure of database files created in sql server 2008 express edition & full edition of sql server 2008 having same field structure? is it possible to simply move/copy express edition database as it grows, to full fledged sql server 2008 or we need to create database first on sql server 2008 and then import from express edition database? Thanks for your time and support.
|
|