SQL Server 2005 Interview Questions 

where can I download adventureworkslt version 611 or below. I already download from codeplex but the version is higher than 611 and not supported on my SQL Server 2005

thanks
NP

Hey, I've got SQL Server Express Edition 2005. I am currently logging in via my system account but want to switch it over to a new login. I am an administrator. How do I do this, preferably without reinstalling.

It sounds like a common task.
Imagine a form, where users can pick one or more colors they like. I use a form with multiple checkboxes. Each checkbox represents one color. (the checkboxes with colors are generated dynamically from table tbl_Colors) Each color has its unique colorID that is submitted as the checkbox value. With the colorID is also submitted the userID, that is stored in a hidden field. All goes into a table (tbl_Users_Colors), that has two columns (userID, colorID). This is a linking table between tbl_Users and tbl_Colors. Their relationship is one-to-many, so one user can pick more colors. This should insert multiple rows in the table tbl_Users_Colors.
eg:
userID colorID
1 ............ 5
1 ............ 7
1 ............ 12

I can't get it work. As soon as the form submits more than one checkbox, I get the message that the number of values doesn't match the table.

I use ASP, Dreamweaver8 and MS SQL Server 2005

Please can someone help me to solve it?

How do I return a temp table as a datatable from sql server 2005 stored procedure?

Starting my IT Career with a MCSA or MCDST?
Some suggested me to become a Web Developer???

I am 52 with almost no IT experience. I know my way around with XP and that's about it. My goal is one day to become SQL Server 2005 Administrator but I was told to become a windows administrator first. Now I am told that nobody will hire me without any IT experience and that I should troubleshoot PCs in some call centers and be a help desk employee and pass my MCDST. Now help desk troubleshoot all day minor things & don't make more than $15/h. Even if I have experience as an help desk IT is it going to put me eligible to be hired as a Windows Admninistrator later on? I wion't have any Server 2003 experience as Help desk IT guy so what is the point of all that. PLEASE HELP.

I am new to SQL Server 2005 and expect to post many questions here because it is convinient for me. My current question, does SQL 2005 commit changes automatically when updating data inside stored procedures or do I need to specify commit or set any flags at the begining of sproc declaration? Thank you.

I think these all have something in common, but I'm not exactly sure what. I think a few months ago, someone on my computer tried to get Visual Basic 6.0, but accidentally downloaded these instead:

Microsoft SQL Server 2005
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files (English)
Microsoft SQL Server VSS Writer
MSXML 4.0 SP2 Parser and SDK
MSXML 6.0 Parser
OpenPG Secure Module 3.2

I know it's quite a hefty bundle, but help would much be appreciated. I was just wondering how many of these programs I could safely remove.

I have a LAN and there is 40 workstation running on windows XP pro and there is a stand alone Server running on Windows Server 2003 with SQL Server 2005 Installed on it, named DDSRV. It can be ping by DDSRV itself but while pinging from other machine, the reply is request timed out. Can Anybody tell me what is the resolution for this problem.

Thanks
Mustafiz

hai, am developing a simple project using visual basic 2005 with SQL server express edition, But i dont know how to conect a databse with this programe. is there any sample project in vb 2005 with sql expres? if u know any web addresses, pls share with me, or give thne connection codings, thanks in advance,
aneslin

I'm using EMS SQL Manager LITE 2005 for SQL Server and I thought there was a statement to write the results of the query to a file on my hard drive. This free tool doesn't have this functionality (the full one does have "save query results as abc.txt") and my query result has 80k rows - it's taking forever for the machine to copy/paste them.

Thanks in advance!

HI friends

I am planning to build a Login Form ( Stand Alone Application). its part of my Project .

Here i had 2 Text Boxes Named Username TB and Password TB and a Login Button .
With MsAccess or Sql Server .. my Form has to Validate the data. I dont know How to validate the Username and Password in the Database. Once Validation Got done, Main Form Should Open.

I hope U understood my problem. I Donno How to Look into Database and compare the Username and Password ,the user Enters.

Thank You

Subhash.

I was thinking going for MS SQL Server 2005/08 but a friend of mine told me that I will be in higher demand if I learn it under the platform Unix or Linux. What are your recommendations guy? Thank you.

Microsoft SQL Server Setup Support Files (English)
Microsoft SQL Server VSS Writer
Microsoft User-Mode Driver Framework Feature Pack 1.0
Microsoft Visual C + + 2005 Redistributable
MSXML 4.0 SP2 (kb936181)
MSXML 6.0 Parser
Microsoft Compression Client Pack 1.0 for Windows XP
Microsoft .NET Framework 2.0

Do i need these programs??

Dear all,
I was thinking to develop the business application using the Front-End as MS-ACESS and Back-End as SQL-Server 2005. Now, I would like have a menu options instead of using switch board buttions so I request all expert to give an idea with advantage and disadvantage of using custom menus or toolbar in MS-ACCESS application. If you recommend switch board button menus why? give me some comments

Thanks in advance,

I'm putting together a VB 2005 Express Edition application which use the built-in Microsoft SQL server to store data.

I've got my code almost working but it's not putting the data into the database (and it's not giving me any errors either)

Here's the code.

Dim da As New FrameworkDataSetTableAdapters.ProjectsTa...

Dim projects As FrameworkDataSet.ProjectsDataTable = da.GetData()
Dim row As FrameworkDataSet.ProjectsRow

row = projects.NewProjectsRow()

row.projectName = "Missing-Auctions.com"
row.linkText = "Missing-Auctions.com"
row.url = "http://www.missing-auctions.com"
row.description = "Find misspelled eBay auctions"
row.keywords = "ebay typos, auction typos"
row.name = "Missing Auctions"
row.email = "info@missing-auctions.com"

projects.AddProjectsRow(row)
projects.AcceptChanges()

Note that there's a ProjectID column in the table as well which is the table key.

So, what am I doing wrong ?