Run Querys After Silent Installtion SQL 2005 Express
Mar 1, 2006
Hi,
I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.
What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.
Thanks
Robert-Paul
View 4 Replies
ADVERTISEMENT
May 11, 2006
Following is the error log the installtion gave. I have widows 2000 professional running on my machine.
Please help...thanks
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.0.4 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpdotnetfxdotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer'
Read string value '6.0.2800.1106'
Setting value '6.0.2800.1106 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2800.1106 {string}
Running checks for command 'dotnetfxinstmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfxinstmsia.exe' is 'Bypass'
Running checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfxWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfxdotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfxdotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpressSqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install'
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp"
Downloading files to "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp"
(5/11/2006 8:36:41 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://ct11pcsapp111/testcentralpoc/SqlExpress/sqlexpr32.exe' to 'C:DOCUME~1csk044LOCALS~1TempVSD6A.tmp'
Download completed at 5/11/2006 8:36:46 PM
Verifying file integrity of C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpressSqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpresssqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:DOCUME~1csk044LOCALS~1TempVSD6A.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70095
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
View 9 Replies
View Related
May 16, 2007
Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
Here is the command line that fails :
"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
Interrestingly, when the following command line is used to launch the setup,
it completes successfully :
"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"
After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.
Any help appreciated.
View 7 Replies
View Related
Feb 21, 2008
Hi,
I want to build a silent setup/installation of MS-SQL-Server-Express 2005 for installation on customers computers.
I want to integrate it in my own setup/installation routine of my application.
How can I do that?
Where can I get Infos or tutorials? Perhaps here ?
Sorry for my bad english
Regards Tron
View 7 Replies
View Related
Feb 20, 2008
Hi,
I would be very grateful if someone could take a look at my command line install and offer advice on if I am doing it correctly.
The reason I am asking is because I cannot seem to get the server installed without having errors during the installation:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error 17113 (0x42D9)"
Looking at the server error log indicates that master.mdf was not in the data directory (I have however specified a different data directory for ease of backup by our software and this is created during the install but does not have this database in the data directory - it is however in the template data directory!
I also get this error when the SQL Server service is started:
"The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59)."
All advice is welcome. Please see below my batch file. Also, if you think I should do this in a different way then please let me know. I basically want to install SQL server on a customer computer and automate the install so the custoemr does not need to enter any information.
The goal of this install is:
[1] Deply a custom .Net application and SQL server at the same time on the same computer without user input.
[2] Allow remote .Net applications (designed by myself also) to connect over a LAN (and later maybe over a WAN) to the database to the above database.
The command line is this (I have also included the batch file I am usign below). For ease of reading I have put the parameters on a new line below:
setup.exe /qb
username="CustomerUsername"
companyname="OurCompany"
addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
disablenetworkprotocols="0"
instancename="MSSQLSERVER"
INSTALLSQLDATADIR="c:SqlData"
USESYSDB="c:SqlData"
SAVESYSDB="1"
SQLAUTOSTART="1"
SECURITYMODE="SQL"
SAPWD="#StrongPaSSword#"
======= Batch file Start ======
SET MODE=/qb
SET SETUP_EXE=sqlfilessetup.exe %MODE%
SET SQLDATADIR=c:SqlData
SET SET_USERNAME=username="CustomerUsername"
SET SET_COMPANYNAME=companyname="OurCompany"
SET SET_ADDLOCAL=addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_DISABLENETWORKPROTOCOLS=disablenetworkprotocols="0"
SET SET_INSTANCENAME=instancename="MSSQLSERVER"
SET SET_INSTALLSQLDATADIR=INSTALLSQLDATADIR="%SQLDATADIR%"
SET SET_SAVESYSDB=SAVESYSDB="1"
SET SET_USESYSDB=USESYSDB="%SQLDATADIR%"
SET SET_SQLAUTOSTART=SQLAUTOSTART="1"
SET SET_SECURITYMODE=SECURITYMODE="SQL"
@REM === RE-INSTALL PARAMS - NOT CURRENTLY BEING USED?? SHOULD I ADD THESE ALSO? ===
SET SET_REINSTALLMODE=REINSTALLMODE="omus"
SET SET_REINSTALL=REINSTALL="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_REBUILDDATABASE=REBUILDDATABASE="1"
SET SET_SAPWD=SAPWD="#StrongPaSSword#"
@REM === START THE SETUP / RE-INSTALL ===
START %SETUP_EXE% %SET_USERNAME% %SET_COMPANYNAME% %SET_ADDLOCAL% %SET_DISABLENETWORKPROTOCOLS% %SET_INSTANCENAME% %SET_INSTALLSQLDATADIR% %SET_USESYSDB% %SET_SAVESYSDB% %SET_SQLAUTOSTART% %SET_SECURITYMODE% %SET_SAPWD%
======= Batch file End ======
Your advice is kindly welcome.
Thank you
Kind regards
Paul
View 2 Replies
View Related
Dec 12, 2005
I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies
View Related
Oct 21, 2007
Hello All Great Developers,My Brothers...
blease help me
I am a new in this domain, I need to Know if I can make c# porject
with SQL server Express Database,
and I need to make install to this project to work in any PC without install any another tool or sqlserver program,
blease answer me ,blease
View 7 Replies
View Related
Mar 14, 2006
I am writing an application that requires SQL Express to be installed alongside.
So I try to do the following - Before installing my application, I pop-up a link which leads to "SQLEXPR.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLServer <other parameters> /qb " .
But this displays only a basic GUI, which means that the pre-requisite checks for SQL express are not displayed to the user. So if MDAC version 2.8 is not present on the system the installation of SQLexpress fails without any error messages (except in the log files).
( This is not a problem with all pre-requisites :: If .NET is not present on the system, the failure is much more elegant. There is a nice GUI pop-up which requests the user to install .NET 2.0 before installing SQL express.)
On the other hand, If I remove the "/qb" switch, I can get the pre-requisites GUI to display and the end-user can figure out the cause of failure easily enough. But this means that the optional parameters I use, for example the instancename or the authentication mode will not be used during the install
Is there a good commandline switch I can use so that
1) The pre-requisites check screen is displayed
2) All the commandline options are used for installation.
Thanks
View 5 Replies
View Related
Aug 4, 2006
I'm currently building an MSI to install SQL Express and want to install as a new instance, not the default instance, and not into the SQLEXPRESS instance either.
I saw the package.xml for Express in my VS Studio install. How would I go about using this? Or would I have to modify the MSI via Orca or something? I hope not. Wouldn't have a clue where to start.
In short, regardless if there is already an SQL Express instance on the machine or not, I need to silently install a fresh new instance of the server engine only, no client tools except sqlcmd.exe
I have seen that MS would advise that everyone use the SQLEXPRESS instance but I don't agree with it. I don't want other application installs trampling over my server settings and I don't want to trample over others. For example, expose others to TCPIP and CLR when they don't need it, and conversely others swithing them off in a shared server instance when I do need them.
View 7 Replies
View Related
May 25, 2007
Hi!
I have created a setup in visual studio and set the sql server as a pre-requsites.
now when the setup is run from
setup.exe
it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,
I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help
View 1 Replies
View Related
Aug 15, 2006
When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.
I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.
As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.
I've tried:
SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM
SQLACCOUNT=BUILT-INSYSTEM
etc.
and even some different SID as:
S-1-5-18
S-1-5-19
All with no password with the SQLPASSWORD parameter:
SQLPASSWORD=
I still getting the same error while validating the service account.
Is there someone else who knows what I'm doing wrong?
Best regards,
Mattias
View 5 Replies
View Related
Oct 9, 2006
Hey all,
Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.
Thanks in advance,
Bill
View 7 Replies
View Related
Aug 25, 2007
I can't get SQL Server 2005 to update to SP2 in either silent or unattended mode. None of the standard switches work. I've used -s, -m, /q, /qb, and /qn all with no favorable result. I am still prompted for user input at every screen. Suprisingly I've had no such problems with the express edition, just the server itself. Is there a way to make this thing work? Here is the line I've been feeding to the installer.
"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait setup.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart
I have also tried the following since it looks like the file that is unpacked by the SP2 install is actually hotfix.exe
"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait hotfix.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart
I also have tried the following generics:
"<SERVER_PATH>SQL Serversql2005SP2.exe" -s
"<SERVER_PATH>SQL Serversql2005SP2.exe" -m
"<SERVER_PATH>SQL Serversql2005SP2.exe" /q
View 3 Replies
View Related
Aug 17, 2006
Yet another roadblock: Does the standard SQL SE 2005 not install any of the query commands? (isql, isqlw, or osql.exe's). I could have sworn that they were, but every time I go to test the install on my VM none of them are ever installed. If it doesn't is it included in the advanced version of it (which I'd really rather not do)? If still no what's the easiest option I still have open? Can I have my app connect to the master db and run a restore script from the app? I've been arm wrestling with this install for over a week and it's just about brow-beaten me completely.
TIA,
Jayyde
View 3 Replies
View Related
Nov 17, 2006
Hi,
I failed to install SQL Server 2005 to my Win2003 server which has AVG antivirus/firewall installed. It still not work even I disable the firewall. Please advice
Here is the error log
2006-11-17 13:45:12.25 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-11-17 13:45:12.25 Server (c) 2005 Microsoft Corporation.
2006-11-17 13:45:12.25 Server All rights reserved.
2006-11-17 13:45:12.25 Server Server process ID is 3300.
2006-11-17 13:45:12.25 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-11-17 13:45:12.26 Server This instance of SQL Server last reported using a process ID of 2768 at 11/17/2006 1:45:00 PM (local) 11/17/2006 9:45:00 PM (UTC). This is an informational message only; no user action is required.
2006-11-17 13:45:12.26 Server Registry startup parameters:
2006-11-17 13:45:12.26 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-11-17 13:45:12.26 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-11-17 13:45:12.26 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-11-17 13:45:12.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-11-17 13:45:12.28 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-11-17 13:45:12.43 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-11-17 13:45:12.45 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-11-17 13:45:13.48 spid5s Starting up database 'master'.
2006-11-17 13:45:13.51 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-11-17 13:45:13.59 spid5s SQL Trace ID 1 was started by login "sa".
2006-11-17 13:45:13.60 spid5s Starting up database 'mssqlsystemresource'.
2006-11-17 13:45:13.78 spid5s Server name is 'VSMRND'. This is an informational message only. No user action is required.
2006-11-17 13:45:13.78 spid9s Starting up database 'model'.
2006-11-17 13:45:13.85 Server The certificate was successfully loaded for encryption.
2006-11-17 13:45:13.85 spid9s Clearing tempdb database.
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \.pipesqlquery ].
2006-11-17 13:45:13.87 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-11-17 13:45:13.87 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-11-17 13:45:13.87 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-11-17 13:45:13.90 spid5s Starting up database 'msdb'.
2006-11-17 13:45:14.09 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2006-11-17 13:45:14.25 spid9s Starting up database 'tempdb'.
2006-11-17 13:45:14.31 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-11-17 13:45:14.32 spid12s The Service Broker protocol transport is disabled or not configured.
2006-11-17 13:45:14.32 spid12s The Database Mirroring protocol transport is disabled or not configured.
2006-11-17 13:45:14.39 spid12s Service Broker manager has started.
2006-11-17 13:57:11.79 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server Error: 17054, Severity: 16, State: 1.
2006-11-17 13:57:12.34 Server The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
2006-11-17 13:57:12.49 spid12s Service Broker manager has shut down.
2006-11-17 13:57:13.15 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
View 3 Replies
View Related
May 7, 2007
Hi,
I just installed VS.NET 2005 on my computer and along the way SQL Server Express edition got installed too. What is the default sa password right out of the box? I actually want to use Windows authentication but was not able to set my domain account in there w/ administrative rights. I'd appreciate some help here.
Thanks,
Sam
View 1 Replies
View Related
Feb 16, 2007
HI,
i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.
Best Regards
Ihsan
View 1 Replies
View Related
Jul 24, 2007
it's my laptop, i try to install sql server 2005. the installation program dies at the first stage.
the program seem cant finish the Native Client installation and stops for ever. theres no error msg.
the installation program works well on my desktop. does anyone knows what goes wrong?
View 6 Replies
View Related
Jul 24, 1999
I am querying my dBase "Reservations" to obtain a range of dates for
rooms in our hotel that are available for a vacationer to reserve...
this is the my present SQL structure (two tables(roomReserve & roomDescribe inner joined)
**********************
SELECT roomReserve.availibility, roomDescribe.numRooms
FROM roomDescribe INNER JOIN roomReserve ON roomDescribe.code = roomReserve.code
WHERE (((roomReserve.availibility) Between 8/20/99 And 8/23/99) AND ((roomDescribe.numRooms)>0));
****************************
The problem is that I do not want any room open dates (roomReserve.Availibility) to come up if any of the days in between the date range have 0 rooms available (in other words no room available on that date) (roomReserve.numRooms)>0
But they do because the query is not correctly written to be an all or none recordset for the date range time peroid…
For example, if I query for the date range of 8/20/99 to 8/23/99 using a criteria that the room must be available (>0), and let's say the date 8/21/99 has 0 rooms available for the King Fireplace room, then the query's results set gives me a list of the other 3 dates (8/20, 8/22, 8/23) for when the King Fireplace room is available...
I don't want anything thing for that date range to come out if any of the dates (within that range 8/20-8/23) have a room status = 0 during that time period...
I need a way to receive an all or none recordset result... with only one query statement…
I do not want to have to query a query… if that's at all possible…
thank you... chris james
View 1 Replies
View Related
Jun 8, 2007
I just started working with MS SQL. I'm attempting to find the equivalent of the MySQL commands STATUS and SHOW STATUS.
Essentially, I want to connect to the database from a .net app, check the status, such as how many connections, table locks, errors, etc... and display that information on my application.
Any recommendations?
View 5 Replies
View Related
May 14, 2008
select *
from OPS_TimeCards tc
join OPS_TimeCardHours tch on tch.TimeCardID = tc.TimeCardID
join OPS_Projects pj on pj.ProjectID = tch.ProjectID
where tch.TimeCardID = @TimeCardID
Union
select *
from OPS_TimeCards tc
join OPS_TimeCardExpenses tce on tce.TimeCardID = tc.TimeCardID
join OPS_Projects pj on pj.ProjectID = tce.ProjectID
where tce.TimeCardID = @TimeCardID
I have this query but when i try to use the UNION i get this error
Msg 205, Level 16, State 1, Procedure GetTimeCardSearchResults, Line 24
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
I need to run both of these queries but have them return one result set....anyone know how to do???
View 5 Replies
View Related
Sep 26, 2007
Ok in Replication for sql 2000,'
what happens when a query such as 'update tableA set a=1 where id=5' affects 1 row. What will happen when it does not affect any row.
Aaron
View 1 Replies
View Related
Mar 22, 2004
Somebody can give some tips or hints for speed up my querys and procedures from sql and get more performance, what is best to use, joins o cursors, using cursors can give me more performance?
View 1 Replies
View Related
Oct 21, 2005
Hello,
I've got a trouble with my query and left outer joins. I've got 2 tables, table A and B, both have the same record called ID. I used this query:
SELECT *
FROM A LEFT OUTER JOIN B ON A.ID = B.ID
This is OK and works fine, my trouble comes when i have a duplicated ID on both A and B. Instead of return 2 fields, it returns me 4.
Is there some way to force SQl server to return only the first founded on B, but the 2 duplicated IDs on the A table?
Thanks for all.
View 3 Replies
View Related
Apr 17, 2008
I have two databases with table structures exactly the same. The query in one database works and returns correctly. The same query (copied and pasted) in another database returns the correct records but completely ignores the order by. Even stranger, when you are creating the query under modify and run it, it is fine. But when I right-click on the query and go to 'Open View' then the query does not return correctly. Below is the query:
SELECT TOP (100) PERCENT pf.description AS incentive, CAST(i.targetc AS FLOAT) AS targetc, i.targetp, b.basis, d.description, i.iSelect, i.direction, pf.pValue,
pf.pFigure
FROM dbo.PerfFactorWeights AS pfw INNER JOIN
dbo.PerfFactors AS pf ON pfw.incentiveID = pf.incentiveID INNER JOIN
dbo.Incentive AS i ON pfw.incentiveID = i.incentiveID AND pfw.basis = i.basisID INNER JOIN
dbo.Basis AS b ON i.basisID = b.basisID INNER JOIN
dbo.Division AS d ON pfw.division = d.uniqueID
ORDER BY incentive, d.uniqueID, b.basis
View 4 Replies
View Related
Feb 1, 2007
Hi there!I'm programming in delphi and new to querieng MS SQL Server. Is there a wayto monitor the queries sent to the server and something of the returns. Atleast execution time would be interesting ...Thx in advance,Fritz
View 2 Replies
View Related
Aug 10, 2005
Someone asked me a curious question.Can I execute a query to sql server from a bat file? how?If not is there a simple scripting laguage that this person might use todrive his process that is similar to a dos bat file?
View 5 Replies
View Related
Dec 11, 2006
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
View 6 Replies
View Related
Jun 5, 2008
Hello,Could some clarify for me? I’ve been told that I should add lock statements to my database write querys (update, delete, insert). I’m not sure If it’s necessary though. The only documentation I’ve found so far is how to implement a lock statement with threading but I’m not using the threading namespace. What best practice and how would I implement this without threading or should I be using threading?Thanks in advance!
View 4 Replies
View Related
Sep 13, 2006
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies
View Related
Aug 18, 2006
This problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions?
Private Sub UpdateMemberTable()
Me.Validate()
Me.TblMembersBindingSource.EndEdit()
Me.TblMembersTableAdapter.Update(Me.ChurchFamilyDataSet.tblMembers)
Me.TblMemberDependentsBindingSource.EndEdit()
Me.TblMemberDependentsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberDependents)
Me.TblMemberContributionsBindingSource.EndEdit()
Me.TblMemberContributionsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberContributions)
End Sub
View 3 Replies
View Related
Jun 13, 2007
Hi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
View 8 Replies
View Related
Aug 8, 2006
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
View 11 Replies
View Related
