| SQL Server 2005 Interview Questions |
|
|
Hi, I am studying how to use MS SQL2005 from SQL server tutorial 2005. When I try to do a registration server, I receive a erro 26. I have 3 questions to ask.
When I installed the MS SQL2005 for the first time, I had 2 SQL servers:
1. the MS SQLExpress and MS SQL2005. I did not want to install SQLExpress but it is in my computer. Please explain why it is there...
2. When I try to do registration server, from Database engine -> New -> Registration Server, the new server registration display, from server Name drop down list box, there is only one server display is (local)\SQLEXPRESS. I can register to this one the database that I have, but I need is (local)\MSSQL2005. But where is it.
3. The database AdventurWorks.mdf is located in: C:\Program Files\Microsoft SQL Server\90\Tools\Samples and I believe the database is for MS SQL2005. I have to copy this database to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data for MS SQLEXPRESS.
Would you let me know why and how to connect to MS SQL2005 instead of SQEXPRESS server.
Thanks
|
|
|
|
I have the following sp (stripped down version) which functions property, however it does not return a column name, only "(no column name)". Been working on this for a few days now but getting nowhere. Does anybody have any suggestions?
Thanks in advance
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[sp_Test]
@IncRecIdx int,
@TmpStr varchar(50),
@WrkStr varchar(8000)
AS
---------------------------------------------------------------------------------
set @TmpStr = (select case when chkInc_Abuse_Alleged = 1 then
'Abuse Alleged' else null end from Incident_4 where IncRecIdx = @IncRecIdx)
if len(@WrkStr) = 0 or @WrkStr is null
set @WrkStr = @TmpStr
else
set @WrkStr = @WrkStr + ', ' + @TmpStr
---------------------------------------------------------------------------------
set @TmpStr = (select case when chkInc_Burn = 1 then
'Burn' else null end from Incident_4 where IncRecIdx = @IncRecIdx)
if len(@WrkStr) = 0 or @WrkStr is null
set @WrkStr = @TmpStr
else
set @WrkStr = @WrkStr + ', ' + @TmpStr
---------------------------------------------------------------------------------
select @WrkStr as StrOut
--exec sp_Incident_4_Test 1001
|
|
|
|
I'm trying to set up Visual Basic 2005 Express Edition but I can't do so.Here 's the error message:
Set up has encountered a problem.There 's a problem in installing Microsoft SQL server express edition X86
|
|
|
|
Does anyone know of an easy to use collaborative filtering tool? Ideally, that would be an add-in for Excel to work on an external data source on SQL Server.
Alternatively, any indication on how to code such an algorithm in Excel VBA or VB 2005?
The dataset consists of around 1,000,000 records.
|
|
|
|
i am creating a website. i want a little windows style box to pop up if they click on a certain link, so that ppl have to log on.
if you need a picture of what i mean please send me an email:
john[dot]edwards717 [at] homecall [dot] co [dot] uk
please note i dont have an SQL Server thing and I am just doing this on Windows XP Media Centre 2005, and will be storing the website files on Windows XP Home.
|
|
|
|
????
2007/7 ???????
Word????,??????20??????????????,????????...
2007/8-2007/9 ????(NORITZ)????????
????????,???????,????????
????????????????
??Excel??????????????
????????????????????
????
2005/9- ? ????????? ??
??????????????????????????????????????...
??????????,?????????????????????MTV???...
2007/09- ? ???“???????????”???? ????
????????????????????,?????????????????...
????????????????????????????,?????????...
?????????,??????????????????
????????
? ??????
? ?????Office???????
? ?????C++?VB.net????
? ??SQL Server?????????
???????
????????????????,??,??????????????????...
It is very important to me !
Thanks !!
|
|
|
|
right this is random but......which of the programs on my computer do i really need , which 1ns should i definatly keep , i dont no most of there meanings for being on my computer so here: Microsoft silver lightP2P _energy toolbarDivx codecAdvantage (Powering Daemon tools ) Apple software update ATI Catalyst install manager Microsoft SQL server native client Microsoft SQL server setup support files( english ) Microsoft SQL server VSS writer Microsoft visual C++ 2005 redistributable Atheros WLAN client Adobe reader <<<<:these above are what i dont understand , bcoz i dont use them knowingly. do i need them? explain a couple if you wish and if you have time lol thanks
|
|
|
|
HOW TO?
task 1:
create an auto installer CD for installing
SQL 2005
.NET (framework)
IIS server
DATABASE (application specific tables are already present just install them automatically)
task 2:
create a scrolling table (i guess its done in javascript)
datasets are huge so the page shouldnt scroll just the table.
|
|
|
|
Hi,
I am working on a project using VB.net 2005 as front end and for database SQL server as back end. There r two forms, in first form there r 3 combo boxes which are populated from differnt tables.There are some searching criteria & according to that a DataGridView which is on the same form is populated.The second detailed form will have the value from the specific column of DataGridView of first form.i need values of those fields of a row on form 2 when doubleclicking any row of the DataGridView on form 1.stuck up ,unable to get a solution,can someone plez solve this problem for me.
I am using OleDbConnection,OleDbDataAdapter,DataSet...
Thanks in advance.
Hassan.
|
|
|
|
I have a Windows Server 2003 Enterprise, its running the entire company functions, DNS, DHCP, Active Directory, MS SQL 2005, IIS 6...etc
I am already publishing some test websites to be available in the domain, i was able to do it, now thorughout the domain, everybody can type in their browser: websiteName.domainName.local and access the sites...
I wanna add a new separate 2003 server to use it only for testing my websites, i want it to be visible in the domain as before, and i also wanna be able to use shorter names such as http://sitename
without mentioning the domain name...
I know my case includes many parts so forgive me on that...and thanks in advance for any answers
|
|
|
|
6 years experience with .NET (1.1,2.0,3.0,3.5)
4 years c#
4 years vb.net
6 years MS Access
1 year SQL Server Express 2005
Basic XML skills
Basic C++ skills
Excellent writing skills
All the computer skills self-taught (I was a teacher and am now changing careers).
I have written two programs, one that uses MS Access as a backend and another which uses SQL Server Express 2005.
Would I find work as a programmer, or a technical writer?
|
|
|
|
Can someone help me with this in VB.net. I am trying to insert Data from textBox into a table in SQL 2005.
I have tried something like this, but it won't reconize SQL connection? How can I also repost the data after ONButton Click on the same page to the datagrid?
OnButton Click
Dim sqlStmt As String
Dim conString As String
Dim cn As Sqlconnection (Won't reconize SQL connection)
Dim cmd As SqlCommand (Won't reconize SQL command)
Try
sqlStmt = "insert into Table1 (FName) Values (@Fname) "
conString = "Server and connection here is correct;"
cn = New SqlConnection(conString)
cmd = New SqlCommand(sqlStmt, cn)
cmd.Parameters.Add(New SqlParameter("@FName", SqlDbType.NVarChar, 11))
cmd.Parameters("@FName").Value = TxtBoxNewRN.Text
cn.Open()
cmd.ExecuteNonQuery()
Finally
cn.Close()
End Try
|
|
|
|
I am developing a client/server .NET application that uses a SQL Server Express 2005 back-end. Currently our company does not have a server running IIS free for testing purposes.
I heard there was software, provided by Micosoft, that allows you to run IIS on a Windows XP workstation. If you have heard of this, could you please provide me information or a link regarding this.
Thank you in advance...
|
|
|
|
I have a remote SQL 2005 Express database on a server and have a remote client connecting to the server with SSH. I have the SSH setup right (I think) and I am able to telnet to port 5000 on 127.0.0.1, which is being forwarded to 10.10.10.20 port 1344. When I try to do an ODBC connection to the SQL Server it is not working so I don't know what I am doing wrong. When I try to do the ODBC, I am putting in the SQL instance name (SQLS\SQLExpress) and typing in the correct username and password and it is saying "SQL Server not found". On the SQL Server I have TCP/IP and Named Pipes turned on, as well as remote and local connections enabled. What am I doing wrong!
|
|
|
|
Hello
How can Imy database from database server to antoher server. I amk written a programe into C#.Net 2005.
It was easy to take backup from SQLServer to device from SQL Script.
I am not getting that How can I backup database in http or ftp address.
Please help me if you can...
Thanks Manay Many in Advance
|
|