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.
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....
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?
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.
how i can do it?Under Xp/2000, i write a application that stop/start this serices, butunder Win98, how i do it?Exists a method via SqlServer or a dos command to stop/start the MSDEprogram?Thanks a lotTomas--Questa è una firma automatica di MesNews.Sito: http://mesnews.no-ip.com
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
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)
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
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.
A 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
Hi 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.
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, 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?
I am building reports using MS Visual Studio, and in the Preview tab I have the Refresh button and a button with a X to stop a report while rendering. However, when I deploy the report to the reporting server and I run it from the application the X button is not there, and users would find it useful sometimes to be able to stop long running reports. Is this a configuration change?
I am importing a .xlsx into at SQL Server 2014 table. I would like to import each row with an ID and stop at the notes that are listed at the bottom. Please see attached image. How do I tell my SSIS Data Task to stop importing at the first blank row?I never know how many rows of data I may have so I can not use a fixed row number to stop at.
I'm using a SSIS cube as source for reporting services. In my DataSet I have 3 parameters: Year, ProductGroup, Product. By default all parameters are cascading when defined on the DataSet. This is great for ProductGroup -> Product, but I don't want it for Year -> ProductGroup (I want to avoid the roundtrip). I removed the link in the generated MDX, I removed the parameters on the DataSet, but when I run the report, ProductGroup is still grayed out until I choose a year.
I am using SQL Server 2012 SP1. I have built an SSIS package that imports flat file data from various files to SQL Server. I have got it to do everything I want it to do when things are going well, and am now on what I want it to do when it encounters a failure executing specific tasks and containers. For example, I have a Foreach Loop container that executes a dedicated stored procedure for each csv file in the target folder. If any of the store procedures fail to run for any reason I want to carry out certain actions.
For the most part I think I will be fine using the Event Handlers. What I can't seem to find is how to tell the package to stop executing on a Failure event after carrying out the actions defined by the relevant Event Handler. Or, perhaps it isn't necessary as that would be the default behaviour on a failure?
We are using Office 2010 on Citrix with the RCO Master Data Excel addin. I am getting many calls from users that the Addin has disappeared from the Excel menu. Can re-enable it by going to files->Options->Addins and manage COM addins. Have not been able to work out why it becomes disabled. Any registry setting that I can use to stop it from being disabled?
I am importing a text file with a column (serial numbers) with alphanumeric data, some mixed and some only numeric. The very large values that are all numeric are being converted to exponential when I run it thru an import package in SQL Server Integration Services (2005)
Ex. 4110041233214321 --> 4110040000000000 (displays as 4.11E+15)
In the past I dealt with this by importing the text file into Excel and changing the format of the column to number. This works even when many of the values contain alpha characters. I am not sure how to accomplish this same thing without going thru Excel. If you have any ideas on this I would be happy to hear from you.
I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.
I cannot run the sql server 2005 analysis services from my configuration manager. I noticed this today for the first time but I don't think I changed something special since last week.
I found the log file in C:Program FilesMicrosoft SQL ServerMSSQL.2OLAPLog but I can't post it here since it's too long and I found this :
Message: Erreur OLE DB : Erreur OLE DB ou ODBC . (Source: \?C:Program FilesMicrosoft SQL ServerMSSQL.2OLAPLogmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)
This repeats many times in the middle of the file but there is no date on it so I can't say if it helps.
If this isn't the good one, please can you tell me where to find the log that can help resolve the problem.
After i configure the Merge Replication, my sql server services wont start again.
The error show that "The request failed for the service did not respone in time fashion. Consult the event log or other application error logs for detail"
I am not able to start Integration services on my windows 2003 machine. I get the below error. The request failed or the service did not respond in a timely fashion. Consult the event log or application error log for details. I am a newbee for MS SQLSERVER. I did not see any errors in the event log. I checked the sqlserver log and found the below message. I am not sure if this could be related. The SQL network Interface library could not register service principal name (SPN) for the SQL service error: 0x2098. This machine is clustered and integration services seems to work without issues on the first node.
I have a client server application and it is running in the following configuration: SERVER A: MS Server2003 with MS SQL2000, Our ERP application software is installed on this server as is MS SQL200.
Server B: is our e-commerce server and it is running MS Windows2000 server OS and no MS SQL. The e-commerce application is pointed to the active SQL server on server A. I am trying to run a software version upgrade on on software application (which was successfully run on server A) When we try to run this upgrade on server B we get a message: " Setup is unable to start MS SQL Server Services, please start and try again"
I do not understand what is going on with this. SQL & SQL Service Agent is running on Server A. Any suggestions as to what I need to do?