RSS

Sql Server 2005 Interview Questions and Answers 


 

Sql Server 2005 Interview Questions and Answers
How do I restore a database in Oracle 10 g using vb.net 2005. I am creating a application that merges database from MS SQL Server 2000 to Oracle 10g but I want the code using which I can transfer the database from MS Sql 2000 to oracle 10g using vb.net 2005. Pls Help me
I was looking at this site.

http://www.microsoft.com/technet/communi...

and this sentences exactly.


Host: Bruce (Microsoft)
A: There is a sample report posted on the public newsgroup that shows how to sort columns.

Host: Bruce (Microsoft)
Q: How do I find the sample report that shows how to sort columns?
A: In the microsoft.public.sqlserver.reportingsvcs newsgroup search for the Sorting thread posted on 1/27/2004.

but here in news group, I can only find upto 3rd month of 2004. Can any one help by letting me know how to access this article or give an example of enabling the option of user clicking on column header/button to sort the records by column. This I only want in sql server reporting services 2000. Not in 2005. Thanks in advance.
http://msdn.microsoft.com/newsgroups/def...
IN THE SQL SERVER 2000 AND IN ALSO IN 2005 WHEN GOING FOR THE LOGGING IN TO THE SQL SERVER USING A PUBLIC IP, AND GIVING THE SQL SERVER AUTENTICATION IT IS GIVING THE FOLLOWING ERROR

Server: Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

THE SAME ISSUE HAPPENING WITH THE ODBC CONNECTION. CAN ANYONE EXPLAIN ME WITH THE FOLLOWING ERROR

DO NOT GIVE A SUGGESTION OF REINSTALLATION, BECAUSE TRIED THAT ONE TOO

REGARDS

CHAITANYA BABU YANAMADALA
I am moving from VB 6 to Visual Studio 2005.
How can I write code which is path independent (for MS Access) and server-independent (for SQL Server) i.e where the user can enter the path of the database and the SQL Server at runtime, which will be passed to the connection string.
I am actualy doing my MCA project.
My project is in SQL Server 2005 and Informatica.Im doing a 'Banking sector Analysis Project'.I want to create report based on fixed deposit,savings and Loan.I dont know what kind of Report that i want to create.You have any idea about it?
At work: We have one server (Win 2000) called Web2 and it has the purchasing program on it. We have another server (Win 2000) called DBase1 which has SQL 2000. We have another server (Win 2003)called DBAPS which has SQL 2005. We had web2 pointing to dbase1 sql and changed it to dbaps sql.

Our problem is that throughout the day web2 will stop pointing to dbaps and we will have to reset the iis in dos and then it starts back up and is working. A few time it would start pointing back to dbase1.

What is going on? Does anybody have any idea? This did this before by losing connection to dbase1 and we had to reset it several times. We had a programmer come in and he fixed it, but he has since left and now we are not going to get him back for a while. We are trying to figure out what is going on. He did something in some of the .asp pages to fix this.....I am not a programmer, so I don't know!
my teacher give me c# project.the project is
1.have a form that have username and password with their coresponding textboxs.
2.there is SQL SERVER 2005 database table called login that contain username and password columns.
Q:cross check textbox values with database table column values to filter the right users.
I think this can be done using datatables.but i want u to help me even by giving me books to read.thanks lot.
I have some experience in programming ASP.NET, C#, SQL Server 2005 etc. As a way of giving back to the community, I would like to share my knowledge via online live meetings to those who may benefit from this, free of cost. Some details are here: http://vinbhat.wordpress.com/net-trainin...

I know there are people out there who may benefit from this training. I want to communicate this to those who may be interested. How do I let few people know about the class?
I am a hard-core developer that uses SQL Server 2005, as well as Visual Studio simultaeneously. Is it possible that I am able to run so many programs and instances of IE that my desktop can no longer open any more programs/windows? When I open a number of programs and files at the same time, I can't even look at my mail! I have to close a program to view mail, but the memory doesn't show it's maxed out, it shows that I'm using 50% of it and I still can't open more things... can someone please explain?
I did graduation in computer science from university in august 2006. My minor was in mangement information system. I am not interested in programming for its coding. But as management jobs are not so much available, I have to look for programming/coding.
I have some questions. Just try to give me some idea.
1. What is "writing test plan, test execution, web testing, backend testing."?
2. How much knowledge is needed to say proficient on "C Sharp using Microsoft SQL Server 2005 as the database" and "report design using Crystal Report in C Sharp"? Or from where I can get that knowledge?
3. What does it mean by having solid understanding on "Object Oriented Architecture and Design" and "Microsoft Dot Net framework" and "all stages of Software Development Life Cycle" (In theroy or coding)?
I am 46 and some friends encouraged me to learn on how to become a Windows System Administrator. I am preparing myself for 1 test SQL Server 2005 certification. Also I was told to learn Msql on linux. Will all that be enough to get a job as System Administrator? I have been around Pcs for 10 years but never did anything professional with them. I am giving myself 1 year. Where should I go? Is it realistic at my age to start that? Please give a honest answer. Thx guys.
I am actualy doing my MCA project.
My project is in SQL Server 2005 and Informatica.Im doing a 'Banking sector Analysis Project'.I want to create report based on fixed deposit,savings and Loan.I dont know what kind of Report that i want to create.You have any idea about it?
I can't figure out what programs I can keep on my computer and I want to clear up some space. Can someone tell me which of these I CAN deleted? Thanks

Agere Systems AC'97 Modem
Apple Mobile Devive Support
Apple Software Update
Bonjour
HP Product Detection
Java 6 Update 6
Java 6 Update 7
Microsoft SQL Server 2005
Microsoft Windows User Migration Tool Version 2.61
MSXML 4.0 SP2
MSXML 4.0 SP2 Parser and SDK
Synaptics Pointing Device Driver
Windows Live Installer
Windows Live Sign-In Assistant
It always says this

Sorry, we couldn't find http://localhost:50004/SendClientCommand... Here are some related websites:
Sponsored Links
Choose Microsoft
Learn how Microsoft SQL Server 2005 Powers Enterprises
microsoft.ca/bigdata

BLAH BLAH BLAH.

How can I get it to stop doing that? I even tried to put broadclip under my SAFE LIST in INTERNET OPTIONS.

THANK YOU SO MUCH IF YOU CAN HELP ME!<3
Hello, I have completed a software product that is a very simple and powerful point of sale software for Sales in shops, i have implemented cash and credit sales, inventory, stock management, orders, quotation, tax calculation and auto generated invoice, payment voucher and customer credit and debit accounts.

The application is done in SQL Server 2005, and VB.NET its very powerful and easy to use application yet i could sold to 2 guys locally they use in their shop and they are happy. but still i have never got enough customers may be i have not much idea about marketing.

Is there any site where i can sell this application or is there any one who can help me to sell my application ?


Thanks
RSS
12345653Showing 46 to 60 of 795