MS SQL Server Express - Is Console Window Available?
Hello everybody,
MySQL has a WebServer console, that lets to create tables via easy to handle SQL queries. Since I am used to SQL Server console, I would like to have such window in Micosoft SQL Server Express coming with Visual Studio 2008. Despite I searched for it, I did not find a database console window.
Does MS SQL Server Express offer a Server Console that lets the database to be accessed via SQL queries, please?
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server Management Console Express And Linked S
Ok so I managed finally to get an Excel Spreadsheet to connect as a linked server. When I right click it , go to run scripts and click on create to i can see the tab of script below: /****** Object: LinkedServer [EXCELLINK] Script Date: 05/17/2008 08:37:04 ******/ EXEC master.dbo.sp_addlinkedserver @server = N'EXCELLINK', @srvproduct=N'Excel', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'c:PRICINGFINAL2.xls', @provstr=N'Excel 8.0' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'EXCELLINK',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'collation compatible', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'rpc', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'rpc out', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'EXCELLINK', @optname=N'use remote collation', @optvalue=N'true' Now I am not sure exactly how to go about querying to pull the data into a table. The table I want to set will have three columns: CREATE TABLE new_price ( item_id CHAR(12), item_lst_lnd_cost DECIMAL(9,2), item_prc_2 DECIMAL(9,2)) the columns in the EXCELLINK linked server spreasdsheet are named the same as the columns above. Once the table is created how do I use the linked server to import the data? Brooks C. Davis IT AdministratorLogistics Manager SFTF LLC dba Ashley Furniture Homestores DELL POWEREDGE 2850 Dual Core Xeon x3 = 1xDB 1xSQL 1xTS | DELL POWEREDGE 2950 Quad Core Xeon = 1xTS | SERVER 2003 | MS SQL 2005 | PERVASIVE EMBEDDED V.9
View Replies !
SQL Server Express 2005 Managment Console Not Logging In
Hi all, We have a machine with SQL Server 2005 Express installed and we use to have no problems connecting to this using the management studio using Windows Authentication. Since yesterday when we open the management studio and press connect using Windows authentication, the logon dialog remains active but does not disappear. In the backgroung I can see the name of the instance on the machine and after a few seconds it goes to green, to show its connected but I can't do anything without cancelling the logon. If I cancel the logon, it sets it is not connected to any server, if i try to launch the instance from the registered servers, with the green connected symbol it hangs. I have left the logon dialog overnight (14 hours) and it still did not disappear. I am looking at any patches that may have been installed but none since the end of May...does anyone else have a similar problem?
View Replies !
Cannot Reset The Default Window Layout In SQL Server Management Studio Express
I have been having problems with SQL Server Management Studio Express, for SQL 2005. The window layout is not right. When I open a new query I can not see the query. Every time I try to reset the default window layout (Window €“ Reset Window Layout), SQL Server Management Studio Express crashes. When I reopen SQL Server Management Studio Express I still have the same problem of not seeing the right window (object explore, summary and properties windows. And the new query in again hidden) If I try to dock the windows SQL Server Management Studio Express close down only showing the one window that I am trying to dock. I have tried to re-install SQL Server Management Studio Express but to no joy. Please help
View Replies !
SQL Express And Console Application
I have created a Web application that uses a SQL Express file Database (mdf). I have also created a console application that looks to the (mdf) in the Web Directory to process some server-side tasks, (Email, process data, etc). Everything works well on my Development Machine, however when I Publish my Web App and Console application to a server, the Web App works fine, the Console App is buggy. The main error I get is ;that the user logged into the server cannot access the Database. (User domcholman cannot access). However this is not always the case, sometimes it works. Question is, how does SQL Express authenticate credentials when in Windows Auth mode? Shouldn't it allow the Service account to access the database? Are there any best practices? Should I use an account and password instead? thanks...
View Replies !
SQL Express And Management Console Ctp Issue
So i installed sql express and the management console and have the sql service and browser running. I try to connect to my instance of sql express with the management console and it says it doenst allow remote connections. error: http://img95.imageshack.us/my.php?image=error28to.jpg What do i need to do to be able to use the management console? I was able to connect before but due to some bad advice think i stuffed up the whole thing and had to uninstall sql express and the management console. I re-installed them both but am now getting this error. what the heck is the deal with this? It shouldnt be this hard! This is in relation to an earlier issue i had trying to get to connect to a database from within visual web developer express and now i can connect to my sql express instance but cant get into the managment studio. :(
View Replies !
Component SQL Server 2005 Express Edition Has Failed To Install - Cannot Create A Top-level Child Window..
Hi All, I'm having an windows app which has Sql Server 2005 Express edition has one of its pre-requisites. When i deployed this app to one of the servers and when my clients tried to download in more than one system, strangely, in one system they got the following error. Component SQL Server 2005 Express Edition has failed to install with the following error message:"Cannot create a top-level child window."The following components failed to install:- SQL Server 2005 Express Edition Would be great if you could throw some light on this issue. Its quite urgent for me to resolve this as this is from the Client side live environment. Thanks
View Replies !
How To Connect To Sql Server As Other's Window Login Rather Than User's Window Login Thorugh ASP.NET.
Dear members, In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication. I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below : protected System.Web.UI.WebControls.Label Label1; private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser"; /* comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate) */ private void Page_Load(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection(_connString); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "select suser_sname()"; conn.Open(); string userName = cmd.ExecuteScalar() as string; conn.Close(); conn.Close(); Label1.Text = userName; } at web.config, I add : <identity impersonate="false" userName="deltasqluser" password="" /> at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication", at query analyzer, I login as "sa" and execute script below : exec sp_grantdbaccess 'deltasqluser','northwind' when I run the ASP.NET script, error at conn.Open(); with error message : Login failed for user 'NT AUTHORITYNETWORK SERVICE'. What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ? Regards, Koronx
View Replies !
Server Management Console Only??
Can the Server Management Studio Express be installed on a machine without SQL Server Express? I have a machine that I use daily that I need to access a remote instance but there is not a need (or space) to fully install SQL Server onto the local machine - all I need is the management tool. I tried installing it but the process errors out, saying a pre-requisite (MSXML6) isn't found. It refers me to a site with all the different SQL Server downloads. All I need is the management tool on this machine. Is there a way to do it? Tried loading "MOM" but it doesn't show up either Thanks Paul P
View Replies !
SQL Server 2005 Management Console
We installed SQL Server 2005 x64 on a server for our client here at our office. We can't connect to it using Enterprise Manager. I'm assuming we need to install the management console because of the differences in 2000 and 2005. The install is for a x64 and our workstations are x32. Do I need to get a media kit for a x32 because the x64 install won't work. Where can I get the install for the x32 Management console and will this work?
View Replies !
MS Console And SQL Server Enterprise Manager Settings Problem
Over the weekend we’ve been moved from an old domain to the new domain. My computer name changed and username changed as well since it’s preceded with the new domain name. So, I am using the new profile now, that is exact copy of the old profile. I used to have a long list of SQL servers registered in MS SQL Enterprise Manager. When I login with the old name (profile) I still can see all these servers. I saved the console settings to a *.msc file. When I login to the new domain and open console by clicking on the saved file I don’t see any of my registered servers. Is there a way to transfer the console settings? Am I missing something? Any help would be greatly appreciated.
View Replies !
Any Documentation On SQL Server State Icons Shown In MMC Console?
Does anyone know of any place I can find documentation on the meanings of the SQL Server state icons displayed in the MMC console for SQL Server 7.0? My server is showing the green running icon but also a vertical red squiggly line. I do not know what this red squiggly line means, and it concerns me. The databases all seem fine, and everything seems to be working, i just have this feeling like something bad is impending and I cannot find anything that tells me what it might be. Any help or suggestions would be greatly appreciated.
View Replies !
SQL Server Enterprise Manager Closing Automatically From Console
This is the weirdest this I have ever seen in a long time. I have MS SQL Server running on a server and use Enterprise Manager a lot. Well, the damndest thing happens when I log onto the server from the console and run Enterprise Manager. If I go into Enterprise Manager, and go to a database and then select a table and right-click, and run the "Open Table" option; the entire Enterprise Manager application mysterously closes. This only happens from the server console and through Remotely Anywhere...it does not happen when I log onto the server from Remote Desktop. Has anyone ever seen this before? Does anyone know a fix for this?
View Replies !
Console Data Connection Problem: Sql Server Doesn't Allow Remote Connections
Hello I have VS 05 professional connected to SQL server express. I am trying to make a simple console connection to northwind database to show the results of a simple procedure. The code is as follows: using System; using System.Data; using System.Data.SqlClient;namespace Chapter6 { class CallSp1 {static void Main() { // create connection SqlConnection conn = new SqlConnection(@"server = .centrinosqlexpress; integrated security = true; database = northwind"); try { // open connection conn.Open(); // create command SqlCommand cmd = conn.CreateCommand();// specify stored procedure to executecmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_select_employees_details"; // execute command SqlDataReader rdr = cmd.ExecuteReader(); // process the result setwhile (rdr.Read()) {Console.WriteLine("{0} {1} {2}",rdr[0].ToString().PadRight(5),rdr[1].ToString(),rdr[2].ToString()); } rdr.Close(); }catch (SqlException ex) {Console.WriteLine(ex.ToString()); } finally { conn.Close(); } } } } The build indicates no errors but the dos output gives the following error: Error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does notallow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, BooleantrustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Chapter10.ConnectionSql.Main(String[] args) in D:PROG_DEVVb.NET_devConsoleAppconnectVerifyAppconnectVerifyAppProgram.cs:line 18Connection closed.Press any key to continue . . . BOTH THE CLENT AND DATABASE IS ON SAME MACHINE. THE DATABSE IS centrinosqlexpress as shown in the code. I
View Replies !
Open Report In New Window: Window.open Method Gives Error
Hi, I am using SSRS Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00. I want to open linked report in new window. I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method. How do I solve the problem? Thanks
View Replies !
Server Agent Window?
When I start the server agent - it opens up a black (command prompt type) window that seems to serve no purpose - that I know of yet. What is this and can I stop it opening up all the time? Thanks JB
View Replies !
SQL Server Window Froze
Hi, It happened to my sql server 5 times in three weeks. The window just froze and no response to any thing for my sql server. I need reboot server everytime to bring the server back. No any error log in SQl or window, Does any one can help on this one? Helen
View Replies !
SQL Server Login Window....
I have an desktop app that uses a system DSN to access SQL Server 7. I backed up a database from another machine and restored it on my machine. Now when my app starts, it prompts for login/pw for SQL Server. I have checked my ODBC connection, and the login and pw are correct. I have also used Enterprise Mgr to check it in SQL Server. Does anyone have any thoughts on why it is now popping up? Drop me a line at bcarlson@documentsolutions.com, and I can answer any questions. I was wondering if any info about the prev machine exists for the database (on the restore)? Thanks, Brian
View Replies !
Sql Server 2000 With Window XP
Hi. I'm new to SQL server. I have here SQL server 2000 and i'm trying to install it on my computer that has the operating system window xp. I'm getting a message saying that the server can't be installed on this operating system. Is there something I am doing wrong? How could i install sql server 2000 on window xp?
View Replies !
How To Open SQL Server Jobs Window From VB. NET
Hello guys,I've one query regarding accessing SQL Server. I want to use SQL Server jobs scheduling functionality. Is it possible to open SQL Server's jobs window from VB.NET? (Server -> Management -> Jobs) Pls. help me to solve this query. Thanks in advance. Waiting for yr reply.
View Replies !
After Restoration Window 2000 Server
hi i got a problem sorry I'm not good at english my windows 2000 os is failed so the os was restored my me after restoration i had a problem the database is running but em and query analyzer is not running and the server manager is not running also should i reinstall the ms-sql server all over or is there other way to correct this problem ? I need your help thanks
View Replies !
SQL 2005 - Window 2003 With IIS Server
Dear ALl, We have SQL 2005 running on Window 2003. Our Dev team created a web application. Which user we need to add in the database and what permission we need to assign him. So web application can do read, write and modify in the database tables. Database name = ACCT IIS server name = MASS (running on different machine win 2003) What role following accounts play in the connection of iis to database server login. 1: ASP.NET 2: MASSii$1 & massiis1 If <indentitt impersonate = TRUE or False> in the config file.. Thanks in advance.
View Replies !
SQL Server 2005 Summary Window
Probably simple but I cannot find the property setting that allows me to change the default date format of the column "Created" in the Summary window. Default it is 2007-11-15. As some tables are changed more than one time in a day, I would like to see also the time as was the standard in SQL SERVER 2000. This is a minor problem but an irritating one! Regards Janne H.
View Replies !
No Indication Of The SQL Server Edition In The About Window
I installed the SQL Server 2005 standard edition after uninstalling the Express edition. When i look in the 'About' screen in the 'SQL Server Managment studio', i don't see indication that the SQL Server 2005 i currently work with is the Standard Edition. There are only categories and their numbers of versions. How do i know that the Edition i work on ,now , is the Standard edition ?
View Replies !
ASP.Net On Window Server 2000 - Database Access
Hi I have problem in configuring my web project on Window server 2000. I have created the web application using Visual Studio 2005 tools. I have configured Window server 2000 with the .Net Framework Version 2.0. I can access the page which doesn't have database access. The connection string in the web config file is giving me the problem that connection string can't be found. Does any one have any idea? My database connection string looks like this. <connectionStrings> <add name="etzAusBldConnectionString" connectionString="Data Source=CASCADE;Initial Catalog=etzAusBldBaseData1;User ID=sa1;Password=****" providerName="System.Data.SqlClient" /> </connectionStrings> Moe
View Replies !
Popup Window Does Not Show In Report Server
Hi, I am stuck and need help. My report accepts 4 parameters two are dates: from and to. Have to make sure that the dates are valid and to-date > from-date. Written the following function and have defined a hidden parameter to invoke it as: =CODE.CheckDates(Parameters!STARTDATE.Value, Parameters!STOPDATE.Value) The problem: In development/preview, it seems to be working fine but not when deployed to server. In there. when the cursor moves between the parameter fields, the browser seems to refresh itself and the function kicks-in and displays a system generated message (not my message and not a popup). It just does not show the popups. I don't have control over the server and need to fix this issue. The questions are: 1. What makes the browser to refresh itself when only cursor moves from one parameter field to the other? 2. Why the popup messages don't show up. Thanks Function CheckDates(FromDate as String, ToDate as String) as Boolean Dim msg as String Dim fdate as Date Dim tdate as Date msg="" If FromDate <> "" If IsDate(FromDate) AND Len(Trim(FromDate)) = 10 fdate = CDate(FromDate) Else msg="Invalid From Date: Please use format MM/DD/CCYY" End If End If If (msg = "" AND ToDate <> "") If IsDate(ToDate) AND Len(Trim(ToDate)) = 10 tdate = CDate(ToDate) Else msg="Invalid To Date: Please use format MM/DD/CCYY" End If End If If (msg = "" AND FromDate<>"" AND ToDate<>"") If (fdate > tdate) msg="To Date should be greater than From Date" End If End If If msg <> "" Then MsgBox(msg, 16, "Dates Verification...") Err.Raise(6,Report) End If End Function
View Replies !
How To Use Sql Server In Limited Window User Account
Ankush Jain writes "I m using Sql Server 2000 in Windoes XP (SP2) with Limited Window Account. I m new to Sql Server.Please You can tell me how to create database. When i expand the console root in Enterprise Manager it will show an error : "A connection could not be established to Local""
View Replies !
Can I Access SQL Server 2005 Via A Window XP Pro Workgroup Network?
Hi, I am new to SQL Server and I am trying to install SQL Server 2005 Express or Stnadard Edition on a computer runing XP pro on a XP's workgroup network using a router. Can I access the the database from another computer running XP pro on the same network? If I can, what setting do I need when installing SQL 2005 in order to do this? Any help is appricated.
View Replies !
Between Window Guest Login And SQL Server Reporting Services Permission
When I open the SQL Server Reporting Services report on the browser from a remote PC, it prompts for password to connect to the PC that the report resists. The default user name is Guest. I unchecked the ReportServer Integrated Window authontication and checked the Anonymous Access in IIS, then I got an error "The permissions granted to user 'mydomainmyAccount' are insufficient for performing this operation. (rsAccessDenied)". How can I by pass the Window Guest login without changing the permission in SQL Server Reporting Services? Thanks. DanYeung
View Replies !
Cannot Find Server Or DNS Error When Using JAVASCRIPT Window.open With DNS Alias
Using SQL Server 2000 Reporting Services and want to open new IE window to link to a site. We are using IE 6.0. I am using the following Navigation "Jump to URL" in report: javascript:void(window.open('http://www.microsoft.com/en/us/default.aspx')) This works as expected if I am not using the DNS alias to reference Reporting Services. But if I use the DNS alias when referencing Reporting Services, then when I click the link in the report I get the "Cannot find server or DNS Error" in the IE window that opens. Everything else works correctly in the reports when I use the DNS alias. Anyone have a clue why this is happening? Thanks, DR
View Replies !
Using User Defined Data Type (UDT) In A Sql Server 2005 Database + Window Application.
Hi, I am using VS2005 C# + sql server 2005 Express edition. I need to using a database that uses my own defined data types to define its tables columns. I already have designed a Database projact and create the new UDT as follows: Create a new Database project in the Visual C# language nodes. Add a reference to the SQL Server 2005 database that will contain the UDT. Add a User-Defined Type class. Write code to implement the UDT. Select Deploy from the Build menu. Now I need to ask some quistions: 1- When I try to add a new query to a table that contains my new data type in its columns,if I try to exexute the query the next message appears: 'Execution of user code in the .Net framework is disabled. Enable "clr enabled" configuration option'. How can I doing that?? 2- I need to use that database - which has the new data type - in a traditional ' Visual C# Windows Application' instead of 'Database', but: when I try to add a new Data Source that contains the tables that have the new data types in its definitions, the next message appears: '<AyaDatabase.dbo.MyNewUDTTable> User-defined types(UDTs)are not supported in the Dataset Designer.' So, how can I resolve that problem?? please help me. Thanks in advance for any help. Aya.
View Replies !
SQL Server Agent Job Step Properties Window Loses Property Values Containing Semicolon (;)
Here's a weird one: We are setting up a job for the SQL Server Agent via SSMS. The Job Step Type is SSIS. In the Job Step Properties window, on the Set values tab, you can enter Values to override your package variables - normally all well and good. However in this particular case, the variable Value contains semicolons ( - it is a Connection String for an ODBC driver. Eg: Driver={Client Access ODBC Driver (32-bit)};system=MYSERVER;... The behaviour for this Value is weird: If the Value is not surrounded with double quotes ("), the job fails with "The command line parameters are invalid." If the Value is surrounded with double quotes ("), the job will run as intended. The catch is: that entry and any subsequent "Set Values" entries disappear next time the Job Step Properties window is opened. This looks like a bug with the parsing of those strings by the Job Step Properties window? Or am I missing something? Mike
View Replies !
C# Console Access Sql
hi, all, i am using VS 2005. the c# program and sql data(Database1.mdf) including Table1 are within the same project.how can i use the C# program to access the data within Database1.mdf?such as what is the ConncetionString of that?any simple sample codes? btw. i have tried: String connStr =@"server = (local)etsdk;database = Database1;integrated security = sspi;";
View Replies !
New SSB-Management Console
Hi, we are currently planning the development of a new SSB-Admin-Tool for SOA environments, which will allow dynamic configuration during MSBuild, register and monitor all services, dynamically configure routes (supporting gateway-servers and services registered on multiple servers for fail-safe). I would like to know if MS is currently working on something similar (the Service-Listing-Manager is buggy, old and seems to be dead on GDN) and what the community thinks.
View Replies !
Isqlw.exe From A Console App
Can someone who knows a lot more about this than me please tell why, when the following code executes, I get a pop-up window telling me the usage of isqlw.exe? <code> strQueryCommandPath = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\"; strArguments = "-S(local)\SQLEXPRESS "; strArguments += "-Usa "; strArguments += "-Padminmlc "; strArguments += "-i" + strCurrentDir + strFileName + " "; myProcess.StartInfo.WorkingDirectory = strQueryCommandPath; myProcess.StartInfo.FileName = "ISQLW.EXE"; myProcess.StartInfo.Arguments = strArguments; myProcess.StartInfo.UseShellExecute = false; return myProcess.Start(); </code> I've also tried it with a space in between the - switch and also with quotes around the switch arguments. I've put the entire path in just the StartInfo.FileName instead of switching the working directory as well. I can't for the life of me get it to actually fire off this command for some reason. p.s. I've also tried using "/"s instead of "-"s as well.
View Replies !
SQL Server 2005 Start Jobs Window And Job Activity Monitor Do Not Show Job Status Correcly
Hi, We have development and user acceptance (UA) servers. When I start a job on the development server, on the management studio, Start Jobs window and Job activity windows indicate "Executing" until the end of the job and finish with "success" or "failure" But on the UA server, second after I start a job, Start Jobs window comes up with "success" or failure" and Job activity monitor says "idle" but Job continues to log without any error message and updates the tables. So these two windows are not reliable at all. I have to add that I have only job operator rights on the UA server. Does anybody know what the reason is ? Thanks
View Replies !
Different Login && SQL Console Root .....
Logged on local Administrator on one of my sqlserver 2000 "ABC" and registered 5 sql groups and linked 50 sql2k servers from MSDE to Standare (all sp3). Now, I need a different login on this machine "ABC", how could I get back all the SQL Enterprise Manager Console Root Setting and connections like before? thanks David
View Replies !
I Need A Singe Example Using Console Utility
Hello, I need to use the console and I never did that. I tried with the Book on line to make a little file .BAT using console /sservername /ppipe_name Could cou give me a single example and try to explain how to complete line by line (in Sybase <expression> type info to console is enough !) a log file the users will read after in the Internet application. Thanks Axel
View Replies !
MSDTC Admin Console
Hi All, When I type "DAC" at the command Prompt ... it doesn't launch the Admin Console for MSDTC .. Do we have to install something to get this Admin console working... Thanks, Venu
View Replies !
|
TRACKER
