how i can do it?
Under Xp/2000, i write a application that stop/start this serices, but
under Win98, how i do it?
Exists a method via SqlServer or a dos command to stop/start the MSDE
program?
Thanks a lot
Tomas
--
Questa è una firma automatica di MesNews.
Sito: http://mesnews.no-ip.com
Hello,
Does any one know how I can start and stop the sql services with the net use command?
Thanks,
Anthony
I need to remotely start and stop SQL from another machine from a program or command line. Thanks in advance.
View 1 Replies View RelatedHi friends,
I have quick question. Ihave a job which consists of 9 steps. 9th step is:
Exec xp_cmdshell 'c:mssql.bat'. in this batch file I am stopping and starting SQL services using net stop and net start command. This job is running perfectly but it is not giving the job history when I right click the job and view job history I can't see anything where as if I check the checkbox for Show step details it showing first 8 steps information but it is not showing 9th step information. Even I checked the Sysjobhistory system table in MSDB it shows only 8 steps information.
What is the reason....
Thanks,
Mohammed.
Hi,
New here:) and hoping someone might be able to shed a little light on a problem I am having.
I have a job scheduled, which needs to be periodically stopped and then restarted.
After looking through various places I think the start method and stop method are the best bets?:rolleyes:
But not really sure to be honest.
Can anyone give me some tips/pointers/opinions on what would be the best way to do this. (have tried to setup a job with the said method in each step - but it doesn't like my syntax.
Thanks in advance
Cheers
Troy
Hello.
Is there any way to schedule stop and start of NT services
at a particular time daily.
For eg: If i have a service by name TemServer and if i need to stop
that service each night at 9:00 and restart as soon as it stops.??
And Is there any way to start and stop the services of NT from
workstation. Each and every time i am going to the server room for
stopping the service and restarting.
Any suggestions and comments are always welcome.
Advance Thanks
MAK
What is the best way to programatically stop/start SQL Server? I want to stop it to do backups and then restart it.
I was hoping to do it within SQL Agent but it depends on SQLServer so you can't do a restart.
Any help greatly appreciated.
What is impact, if i stop and start Synchronization, for one subscription.
When i start, will it resync all tables by dropping and recreating at subscription.
On Publisher, Â
from Location Publiction,Â
  right click on subscription,Â
      select View Synchronization Status,  From here, stop and start
Hi,
We want trace ALL activity on prod
server between 3:00 AM and 3:15 AM
Profiler has stop time option ,but
no start option.
I am looking for example how it could be done
Thank you
Alex
Profiler was run against a database looking for "long running" queries. I used the Duration column to filter out the queries that I didn't want. When reviewing the output, I noticed that for some queries the StartTime was equal to the EndTime even though the Duration was set higher.
My question is, "What can account for this discrepancy and what inferences should I draw about the difference?"
Does the difference represent a resouce being locked or some other type of blocking (Duration) and once the query was allowed to run, it completed quickly?
TIA
=======================================
If Tyranny and Oppression come to this land, it will be in the guise of fighting a foreign enemy. -James Madison, fourth US president (1751-1836)
HELLO,
I want to create a package which start and stop the SQL server's services... i know i can achive this via NET COMMAND.... but i coudnt find in which task (SSIS) I can place that command?..
I also came across that I can achieve this using Execute Process task but for this I have to define executable file.... actually i dont want ne thing outside from my SSIS package
CAN I ACHIEVE THIS WITH IN SSIS PACKAGE?
is there ne other alternative?
regards,
Anas
Hi,
I want to tell to user about SQL Server Configuration Manager and wants to allow him "START / PAUSE / STOP" for SQL Server Express in system Tray. It is easy for the end user who don't know SQL Server.
Thanks
Hi
What SSIS Task or process can i use to stop my Control Flow Process from running?
I created a SQL Task to do a count on a table to see if there is data, if the count is > 0 then the Control Flow task must continue, else it uses a RAISERROR statement which i use with the event handler, but i want to put something in the event handler to stop the process then and not continue?
Any help will be greatly appreciated.
Kind Regards
Carel Greaves
gday, how do i see what i wanted to see
View 2 Replies View RelatedA few service stop/start/restart questions on SQL Server 2005 SP2, whichI'll call SQLS.It looks as if there are *potentially* 6 ways to start/stop SQLSServices like the engine itself, integration services, reportingservice, Agent..-SQLS Configuration Manager-SQLS Surface Area Configuration (for Services and Connections)-Mgmt Studio Local (on server)-Mgmt Studio Remote (on client)-Windows Control Panel->Admin Tools->Services-Command Prompt (ala net start MSSQLSERVER)By policy, I am /not/ Administrator on the server. But I am SysAdminrole in SQLS. I have had various levels of success starting/stoppingservices in the ways listed above. In some I get Access denied, and inothers I get no msg and it simply doesn't work.Is there some special non-Admin OS group I need to be in to start/stopservices? Is this handled differently in the different interfaceslisted above?It seems like my best success for starting/stopping the engine and Agentis in /local/ Mgmt Studio, but /not/ remote Mgmt Studio - the optionsare greyed out on a remote client. Is this by design? Is it a SQLSbug?I'm sure I'm not the only SQLS DBA who does not have Admin rights on hisserver who wants to start/stop services. Generally speaking, how isthis intended to work?Any help appreciated.Allen JantzenA freshly minted DQLS DBA
View 1 Replies View RelatedHow to use the "Analysis Services Execute DDL Task" in SSIS to stop or start the Analysis Services.? Many thnaks.
View 5 Replies View RelatedHi
I have upgraded my local to sql server 2005, but still need to access the remote instance which is still at version 2008/8.0.
Enterprise Manager has been removed (by the SQL server 2005 installation)
Does anyone know how I can restart older version of SQL server instance (ie 2000/8.0) using SQL server Management Studio?
I don't have admin access on the server which the sql remote instance is hosted. Can get around it by asking the sys admin guy to do it for now but would prefer to continue to be able to do it myself.
SQL Server Configuration Manager can only manage SQL server 2005 versions - a nice little caveat!
Is there a way to stop/start remote services using 'net stop/start'? - without having to write code....
I'll continue to search for a solution, but if someon can point me in the right direction, I'd be most greatful.
hien
I'm getting this error message when I upgraded the SQL Server to install SSIS and other components.
===================================
The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)
------------------------------
Program Location:
at Microsoft.SqlSac.MainPanel.ServiceProgressBar.RefreshService()
For some reason the status lights in my Enterprise manager are no longer working. I am connected to the databases, but because the indicator lights are not working, I can`t get a quick visual status of my servers.
Any way to get my lights back on?
Hello everyone.
I have a question about granting enough rights to allow a non admin user to start and stop a sql server service via the SQL Server Management Studio by right clicking on the server node.
I have changed the acl's of the SQL Server service security and gave the user rights to start and stop the service. This does allow them to connect remotly to the server using computer manager and they successifully start and stop the service. But, in SQL Server Management Studio the option still does not show up, unless he is a admin of the server.
Does anyone know what other security settings I need to address for the start and stop to show up when I right click on the server node?
Thanks for any help
I expect to create a trigger to post updated data from GoldMine hosted in MS-SQL to my migration MS-SQL database in the appropriate tables mirroring the destination PICK data tables.
Then, start an ActiveX DTS package to migrate the data via a PICK DSN to data tables in a PICK database.
Currently the dba has been able to use VB6.0 with ADO to push data into PICK. He also was able to do similar using MS-Access.
However, PICK (RainingData) is of the opinion that he must script a PICK server side Basic (RealBasic) insert script to receive the data from a VB6.0 application triggered by MS-SQL.
I think that I could skip the Basic script and go direct with ADO in DTS as he has before with VB6.0 with a user form.
Can I have the trigger start the DTS or should I just schedule it to run as often as necessary to update the PICK database?
FYI, this is a one-way data flow into PICK.
TIA
Anyone within the L.A. CA area that has experience with PICK and MS-SQL can get some well paid consulting hours. I'm just the GoldMine GMT whose been enlisted to get the job done, but would appreciate an expert with PICK to join the project.
jEfFp...
After installing WebMatrix on my computer, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Nothing displayed after I installed MSDE, such as the typical "Installation is complete."
Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP Home.
Any help or suggestions are truly appreciated.
I have spent megabucks buying a book called MSDE Bible and they have started the book by not telling how you create a database (with all the exact steps required so you can actually work with it. I find this highly unprofessional, and wonder if the authors David C Walls and Denise M Gosnell actually know anything about teaching. (One enormally teaches step 1 before step 2 where I come from - obviously not in some places). Anyway, later on in the book there is an example on creating a database.
My problem is that it does not work because I do not understand what is required in terms of security clearance / user names / passwords / user authority. (They also assume you know all about that too).
All I have done is installed MSDE 2000 Rel A and am now trying to use it. The only question I was asked during the install was to define a "Strong Password" and thats all.
I am now attempting to
1) Create a Database
2) Create a table with some fields
3) See if I can access the database
Now is that too much to ask ?
Here is the code that supposedly creates the database:
The problem is in the connect - something to do with security of some sort that is completely overlooked.
dim oMSDEserver
dim oDatabase
dim oDataFile
dim oLogFile
set oMSDEserver = CreateObject("SQLDMO.SQLServer")
set oDatabase = CreateObject("SQLDMO.Database")
set oDataFile = CreateObject("SQLDMO.DBFile")
set oLogFile = CreateObject("SQLDMO.LogFile")
oDatabase.Name = "scheduling"
oDataFile.Name = "sched_data"
oDataFile.PhysicalName = "c:mssql7datasched_data.mdf"
oDataFile.Size = 5
oLogFile.Name = "sched_log"
oLogFile.PhysicalName = "c:mssql7datasched_log.ldf"
oLogFile.Size = 3
oLogFile.MaximumSize = 50
oDatabase.Filegroups("PRIMARY").DBFiles.add(oDataFile)
oDatabase.TransactionLog.LogFiles.add(oLogFile)
oMSDEserver.connect "0kh2h","sa","" <<<<<< PROBLEM HERE
oMSDEserver.databases.add(oDatabase)
oMSDEserver.disconnect
I have not done anymore than install MSDE and run this code - what steps have I missed please ???
Please explain this simply for me.
(I understand DAO / ADO and Access programming but have never used DSN's and SQL Server connections)
While installing the MSDE I get the folowing error:
A storng SA password is required forsecurity reasons.
Please use SAPWD switch to supply the same.
Refer to readme for more details.
Setup will now exit.
Thanks in advance
Mustapha
Hi,
I have installed the MSDE and use mixed mode authenticaton.
The SQL Server Agent will not start due to login failures.
Normally, I would use the Enterprise Manager Managment wizard to
correct the System Account and Connection Credentials.
Can anyone tell me how to achieve this using OSQL?
Thanks
Please help! I cannot debug CLR procs remotely. Whenever I try to start debugging in VS2005 I get the error: Unable to start T-SQL Debugging. Could not attach to SQL Server process on .... I have clr enabled set to 1 and I have Allow SQLCLR Debugging set on. But I continue to get this error. Any help would be greatly appreciated.
Thanks!
GN
Hi,
I am a VB programmer and we have a VB application that uses Access as its db (~500MB mdb file) using DAO.
We want to upgrade to MSDE/Sql Server because we have clients that will use around 5 connections to the db and others with no more then 20 users.
I was asked to build a simple test program in Vb under MSDE that will
enable us to test few clients working simultaneously (I have few days for that).
There is so much material on MSDE and we just ordered an MSDE Developer
guide book from the Amazon that will arrive in a few days.
The amount of material is confusing like hell and I didn't work with ADO
before, I don't even know if to work with Access 2000 or with a different db, can you advice ?
Do you know of a good sample that show a beginner like me how to access
MSDE from VB using ADO?
If you do please please advice it will ease the pressure and the days are
numbered.
Thanks a lot.
Yossi
the service is already automatic, but when starting Windows XP MSDE "asks" to be installed correctly, run setup again and as you can imagine i did so. I can't find the answer
please help me
Castrogeneris
Is it possible to manually force/call/start the system AUTOSHRINK process? I have an issue that appears only when the engine shrinking process is running and I need this to reproduce my bug.
I know how to start a "regular" database shrink process with:DBCC SHRINKDATABASE(xxxx);, but this is not the same as one started from the database engine.
Hello, I have a Question/doubt on SqlDependency.Start/SqlDependency.Stop.
After the implementation of my solution the question sounds "stupid" ... maybe is only the stress due to the fact that I'm going to deploy the application on Test.
Anyway.. I developed this application (windows application) that uses query Notification features to subscribe and get notification from Sql Server 2005 so it use the tipical pattern: SqlDependency.Start, SqlDependency_OnChange,SqlDependency.Stop.
This is application is installed on several client so actually I get have several notifications running on the Server.
When one of the client exit the application and call SqlDependency.Stop the service, queue and procedure are dropped.
Does the command drops all the query notification' service, queue and procedure running on the instance or only the one created by the specific user?
Thank you
Marina B.
I've installed Visual Studio 2005 Professional evaluation edition on both my desktop & on the server to try out the Debugger to be used with my Stored procedures
I got this error message every time i try to 'Step into Stored Procedure' from my desktop to connect to the stored procedure which resides on the Server.
Error message: Unable to Start T-SQL Debugging. Could not attach to SQL Server Process on 'Server1'.The RPC server is unavailable
The 'Step into Stored Procedure' works though if I open the stored procedure directly on the server.
Both my PC and Server has been installed with Remote Debugger and my windows login has been assigned permission to debug on the debugger that resides on the Server and has sysadmin server role on SQL 2005 both on PC and Server.
Can someone tell me what i miss out to debug Stored procedure in the SQL Server 2005 on the Server from my PC?
Thanks in advance.
Windows XP, SP2; MSDE 2000 Release A - on some installs of the XP SP2 MSDE installation fails, the section of the install log that applies is:
View 3 Replies View Related
Hi,
I was trying to extract data from the source server using OLEDB Source and SQL Server Destination when i encountered this error:
"Transaction (Process ID 135) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.".
What must be done so that even if the table being queried is locked, i wouldn't experience any deadlock?
cherriesh