SQL Server 2005 Interview Questions 

I am trying to use a pass through query to run a stored procedure on a sql 2005 server. I need to be able to pass the arguments that are saved in a table to the stored procedure. This is the syntax i have tried but it doesn't work.

exec dbo.bcsp_getcartonnum [Tables]![Table1]![Field1] ,[Tables]![Table1]![Field2],[Tables]![Ta...

any advice on how I can get this done.

Thanks!

Your help is truly appreciated!

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?

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 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?

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

I have made an asp.net project.M going to deploye it.Simply -I copied all folder and files of my project in C:\\Initpub\webroot.
It working ,but those files are giving exception which having GridView(Means when I am attempting to use GridView's page)--"Error in login 'User-name'".
M using SQL Server 2005,C#,and Asp.net.
Plz send me steps that how I can upload/Deploye my project.

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?

Hi I am having Visual Basic 2005 and SQL Server 2005?,Please send me steps for Database connection?

why do i get an error (login failed for user sa\guest) im using sql server 2005 an vb.net 2005... how can i fix this problem? the application is in the other pc which is a laptop and the database in the desktop,,, the error in detail is talking about the JIT(just in time) but i dont really understand it..kindly help me...

please tell all the steps creating a student information system or information system of dormitory of our university using VB.NET and SQL Server 2005 . i installed it on my PC already...please help i accept IM

How to upload files into a database using a web application? Database used is Microsoft SQL Server 2005 & Programming Language used is Microsoft VB.NET on ASP.NET 2.0. I want to know the way to code to allow file uploading to database. *Note* I want to know how to upload files into database as binary and NOT upload files into the web server or file server.* Thanks in advance.

It might take some time for you.. but please help me.. I just want to know how to make the relation and the database tables. (in sql server 2005, but just the main relations and tables would be awesome).

The database has the next aspects :
- it is a library (bookcase) where persons can loan (rent) books.
- the persons are described by name, address, personal cod number, phone number (just 1 phone number)
- the books are described by title, author(s) list, year of release, publishing house name, domain (math, literature..)
- every book has one or more samples (there can be more copies of the same book); some of the samples can be loaned , and others not. each sample has a code
- there is also staff in the library, everyone is described by name, employment date, and a badge code.
- a person can make a loan for a book (which can be rented, because some of them can't if they're only for the lecture room) for a pre-established time.
- a person can have a maximum number of rented books and not given back; when this maximum number is reached that person can't rent anymore any other book until he brings back at least one
- a person can have at a time moment at most on sample of rented and (in the same time) not given back book
- the samples can be lost and then they are marked as being lost in the database
- some of the samples are only for the lecture room (where people read in the library) so they can't be borrowed.
- also we have to know which member of the staff registered the rent or the giving back of a book.

Ok.. i know is much.. but i really need help.. please... please... All what i need are the tables i have to create and the relation between them. (and also the main keys..) . A database created in sql express 2005 would be awesome, but if you can help me by just drawing some tables anywhere ... would be great..
Please help me.. please.. My e-mail address is nutepuicumine@yahoo.com
Thank you so much in advance.

I am preparing a SQL Server cert. However some friends told me to learn Mysql using linux. But I know nothing about linux so will it be a good idea to use it on Windows? If not how much linux do I need to know in order to use Mysql on linux? That will be a complement to my SQL Server 2005 Cert. Is it necessary? Will it make me more marketable? How long will it take me. I am 46 and have some experience with computers. Thank you & Merry Christmas :)

Does anybody have any advice/links for information on how to setup a maintenance plan for database(s) in SQL Server 2005?

Specifically, in the maintenance plan wizard.. Do I need to run the task labeled 'Check database integrity'? If and when do I need to run the shrink database task? etc.

I've found articles explaining what they are and what they do but not so many telling me yes I need to run it or no i dont.