hi,
i am having sql7 with sp2.
Recently our server got bounced back. No body stopped the server, there are no work load at that time. Server suddenly stopped and started.
It is weired.
Can anyone have any clues , how it happened and why it happened.
Thanks!
__kavira
I save Table size and recs. no every day. and check it some days.
...
insert into @t
exec sp_msforeachtable 'exec sp_spaceused ''?'''
...
But Today I saw sudden increase size in a table. about 128 MB in a day. (Average Growth fro this table was 4 or 5 MB in a day)This growth was for Only 4222 Records. While for more number of records (about 7000) in yesterday we had only 2 MB GRowth!
This Table information (Now):
sp_spaceused 'Table1'
Result:
name ---Rows --reserved --data
Table1--1021319--460328 KB --283104 KBI Try to gess The reason. I copy These new records to another table.But The result was more strange : on new table the size of these record was : < 1 MB I copied All records to another table . The size was : 148 MB (while this is 283 MB in my real database)
Anyone got any "gotchas" or "nightmares" they want to share out of experience where the services have been shutdown without the proper forethought?
I'm trying to put a case in for a SQL DBA to be paged and to be in charge of shutting down the services and/or put together a checklist of things to verify first.
While I realize shutting down the services is supposed to be a graceful shutdown process I'm willing to bet there are a host of considerations.
Appreciate any Input.
Regards
I have a SQL Server agent that keeps stopping for no reason. It happens about every other day. I have to go in on the server and manually start it. What would cause this to happen? We have about 50+ computers that need to sync with the server and do so successfully without having to manually start the agent every other day. How do we fix it?
View 17 Replies View RelatedWhat problems could be invoked by stopping SQL Server and copying a user databases data and log files and pasting these files over existing files on another machine.
Ex:
MyDB on Server1
MyDB on Server2
Stop SQL Server Server1 and Server2
Copy Server1.MyDB files
Over write Server2.MyDB files
Start SQL Server Server1 and Server2
Make sense. This scenerio seems to work but wonder what side affects could result.
Any comments would be helpful!!
Does anyone see any negative consequences to stopping and starting SQL Server nightly?
View 2 Replies View Relatedhi.
how can I copy any mdf file to another folder without stopping sql server?
Hello All...
I am new to this forum (and new to SQL for that matter), so I hope this isn't a stupid question. I tried searching for the answer but couldn't find it here.
I am trying to start & stop SQL server through the command line so I can start & stop it as a scheduled task. Are there any switches for sqlmangr.exe I can use? Maybe another way?
Thanks....Dave S. <majordis@weco-group.com>
How execute extended proc on stopping ms sql server (it mean beforestoping).Is it possible to handle this?Or is in system proc a'la sp_on_stop?Thx
View 2 Replies View Relatedwe run ssrs 2005 sp2 hotfix applied - how do we troubleshoot a problem where the report server service is stopping unexpectedly several times a day. When this happens please tell me what happens to the reports that are currently running. I believe that
1) a current subscription that is running will fail - not sure if it will try to restart itself 3 times or not
2) connection to the report server db cannot be made when that occurs
this is a huge problem for us and we dont know what is causing it or how to fix it. Any suggestions would help. I can tell you that our customers flood the server with subscriptions
When I configure and test and OLEDB connection SQL Server 2005 keeps stopping with an error message as shown below. The problem seems to happen when I open the connection for ediing in Data Flow Window. There is a consistent pattern of errors (in there Event Log) relating to the Evnet Log prior to this error occurring.
Any idea what the problem is?
I have to say that my experience with SSIS has not been very encouraging so far.
Event Type: Error
Event Source: MSSQL$SQL2005
Event Category: (2)
Event ID: 17311
Date: 23/01/2007
Time: 2:06:41 PM
Description:
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9f 43 00 00 10 00 00 00 ŸC......
0008: 14 00 00 00 53 00 59 00 ....S.Y.
0010: 44 00 2d 00 4c 00 2d 00 D.-.L.-.
0018: 30 00 31 00 33 00 32 00 0.1.3.2.
0020: 36 00 5c 00 53 00 51 00 6..S.Q.
0028: 4c 00 32 00 30 00 30 00 L.2.0.0.
0030: 35 00 00 00 11 00 00 00 5.......
0038: 45 00 78 00 61 00 6d 00 E.x.a.m.
0040: 70 00 6c 00 65 00 48 00 p.l.e.H.
0048: 69 00 73 00 74 00 6f 00 i.s.t.o.
0050: 72 00 69 00 61 00 6e 00 r.i.a.n.
0058: 00 00 ..
Hello,
SQL Server 2000 services getting stoped automatically when system get reboot. When system reboot they started and after 5 minutes they were getting stoped.
I went through the event log file and found that an error is occuring in sql server with number 17148.
And I also observed that there is a file called "C : P r o g r a m F i l e s V E R I T A S B a c k u p E x e c N T b e n g i n e . e x e" is executing during the maintenance process,which is stopping the sql server services(agent and olap)
This problem is generating error in sql server with above mentioned number.
regards,
vnk.
Hi guys
I've been dealing with a few problems with SQL Server 2005.
We don't want to give our DBA's local administrator access to the servers so we had a problem with SSIS which I managed to resolve by adding their global group into the local DCOm group and modifying the security properties of MsDtsServer.
Another problem I've come across is when you log into Management Studio as an account that has local administrator access to the server you have the Green symbol next to the registered server, you can then right click and Stop, Restart services etc.
If I log into Management Studio with an account that has full SQL sysadmin rights but not local administrator rights to the server then the Green symbol doesn't appear and the Stop, restart options are all greyed out - all other functionality appears okay, they just seem to lose the ability to remotely stop and start services.
All of the above is with Windows Firewall turned off, if the user has local administrator rights but the SQL Server has the Windows Firewall switched on they are unable to remotely stop and restart services.
Port 1433 is open on the firewall and program execptions are there for sqlbrowse.exe
Anyone come across this particular problem before?
Any help would be appreciated.
Cheers
Hanley
Trying to install SQL Server 2005 x64 Enterprise Edition during the "Workstation components, etc." part of the install, the install stops and gives me this error.
----------------------
Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024893
Error message: The system cannot find the path specified.
Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified.
[Abort] [Ignore] [Retry]
----------------------
This install is being attempted on 3 seperate servers all running Windows Server 2003 R2 Enterprise x64 Edition (Service Pack 2).
Futher notes:
Distributed Transaction Coordinator services is setup and running (started).
I checked to make sure there are no MSMQ components in the COM+ Application struture in Component Services.
I've never had any issues logging in, and now today I'm getting this error: Exception Details: System.Data.SqlClient.SqlException: Cannot open database "HRIService" requested by the login. The login failed. Any have some knowledge to drop on me concerning this? Here is the entire error:Server Error in '/HRIService' Application.
Cannot open database "HRIService" requested by the login. The login failed.Login failed for user 'IT-P02ASPNET'.
Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "HRIService" requested by the login. The login failed.Login failed for user 'IT-P02ASPNET'.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Cannot open database "HRIService" requested by the login. The login failed.Login failed for user 'IT-P02ASPNET'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
I work for a small analytical laboratory. I'm mostly the net admin guy,
but I do the db stuff (poorly) and other things.
Last night right before closing my users started experiencing bigtime
slowdown. This morning it was magically better for a short duration.
As the day went on the problems got worse.
We use MS Access as a 'front end' to talk to the SQL server. My users
would go into fields and toggle on (or off) something they wanted.
Sometimes the system acted as in the toggle never happend (cant
generate a report without the right options toggled).
I'm not very DB savvy, so I checked all the other things I was having a
problem with that day to see if it was direct correlation.
A few people have suggested I defrag the hdd as well as the SQL db. I
have maintenance plans set up to back up the db and transaction logs
daily (and weekly). However the maintenance plan that had "reorganize
data and index pages" checked has been disabled for 2 months, since it
seems it never finishes. It would run, and then one of my other plans
would run (several hours later on the weekend).. and I'd come in on
monday and find 3 maintenance plans all bound up.
Usually I had to stop the SQL server and re-start it as the 'stop'
option for maintenance plans wasn't being responsive.
At any rate. I'm looking for suggestions. The DB is (after a shrink)
7GB. I don't think is excceptionally large, so I'm not sure why I'm
experiencing these problems.
I found some scripts for DBCC SHOWCONTIG and DBCC INDEXDEFRAG. But I'm
not sure how to execute them in a scheduled fashion? Is this just done
in the maintenance jobs?
My users need to use this system (reliably) asap tomorrow. I'm going in
2 hours before the office opens in hopes of saving the day and anything
I could arm myself with to make this process easier would be completely
awesome.
So with that in mind. I'll stop rambling.
Ah yes, some information regarding the system:
Windows SBS Server 2k3
SQL Server 2000 w/ SP3 (or maybe 4?) (came with SBS 2k3)
Hardware:
AMD X2 4800+
2GB ECC RAM
160GB x 2 Sata Raid config.
1x Gigabit Network Card
(Not connected to the outside 'world' at all).
Thank you for your consideration,
Ryan
I have an asp page that inserts several pieces of input into an SQL database. Page was working fine, and Im not sure what could have changed to cause the following error when data is entered into one of the fields:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'room'.
/Global.asp, line 20
where global.asp line 20 is oConn.execute cSql
In this case the text I input was: this room is big
I also tried input of fdsa, and recieved the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'fdsa'.
/Global.asp, line 20
More Details:
The field I am inserting this value into is a (nvarcar(1000),null).
None of the other fields on the page have a problem, and this is the last value insert into the database.
Any suggestions or ideas on where I should look to begin solving this issue.
Thanks!
I am working on a web application at work where we are using a SQL Express 2005 database.
We have 2 environments, my development environment which involves my local machine and VS 2005 Pro, and the database on a seperate server.
The client environment is on another server on another network also running SQL Express.
I was working on Friday, everything was fine and dandy. I was sick yesterday. When I come in today with no code changes (checked SVN) I am now suddenly getting timeout problems.
Error Type:
Database
Message:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I thought maybe this was just a problem with my machine so I've checked another development box here, same problem.
Also, the client emailed and they are getting the same problem. Thier environment is using a compiled version of the code from last week. No changes.
Did something happen yesterday or today that requires a patch or upgrade? Why would these failures suddenly appear? What can I do to troubleshoot this?
Thanks,
James
Hi. I recently upgrading my dev machine to Vista and VS 2008 simultaneously (clean install) and upgraded my VS2005 project, which was previously using SQL CE 3.1. Now when I compile and run it, I get a database exception telling me to upgrade my database to version 3.5!
First of all, I tried running the Repair() method to upgrade the database file, but then I get an exception telling me the password is incorrect (it most certainly is not, I didn't change a thing), so it won't even let me upgrade it.
Secondly, I even tried removing the reference to System.Data.SqlServerCe and manually adding the verison 3.1 reference back, but it still for some reason loads version 3.5 instead of version 3.1.
So! Please either tell me how I can properly upgrade my users' database file to version 3.5 and have it work with the latest libraries, or tell me how I can at least use the old libraries like I was under VS2005. The .dll files are all present in the project and I haven't changed them at all, they're being properly copied to the output directory and everything. I even checked the "Specific Version" attribute on the reference in the project, but no help.
Do I have to do something special to tell my application to load the local copy of the assembly as opposed to, say, one in the GAC?
I have been developing a database in SQL Server Management Studio Express for the past few weeks. I have been writing stored procedures and functions, creating and deleting tables, etc., etc. and everything has been working just fine.
Today, however, if I try to run any of the functions I have written I get "Invalid object name 'functionName'."
This occurs even if I create a new function, execute the CREATE statement. Then if I refresh the Functions folder I can see my newly created function, but I cannot run it.
This is terribly frustrating.
Does anyone have any ideas as to what might have changed? I am logging in as the same user, on the same machine that I have always logged in on. I created the database that is giving the error.
When I right-click SQLEXPRESS in the object browser, and go to Permissions in the Server Properties dialog, no permissions are selected as "granted" for my login name under any of the Logins/Roles. (ex. BUILTINAdministrators: my login name is listed in the "Explicit permissions for BUILTINAdministrators" list, but no permissions are granted. If I go down the list selecting [checking] the various permissions, then close the dialog. When I open the dialog again, rows have been added to the list that have the Permission name, then "sa" listed as the Grantor, with that row checked. But, there are still no checks next to my login name.)
The only thing that has changed on my machine, that I am aware of, is that a Windows Authentication update ran on my machine earlier today. I am using Windows Authentication in my SQL Server instance. I assume it has something to do with that.
Please help. This is urgent. We have a presentation on this project in 3 days.
ugh.
Thanks in advance for any help you can provide.
Hello:
We have a new sales force automation application for sales rep to log their contacts, etc. It runs on mssql 6.5, sp 4.
They log in and leave their connections on without logging off or leave their coonections idle .
We set the user connections fiarly high but we are concerned that the max amount of user connections weill be consumed and the sql serve becomes locked.
My questions are:
1) Is there any parameter in the sql server configuration that will log off idle users have a certain time and dsiconnect them?
2) A backup of the database will be made each night. If there is no parameter, would it be a good idea to stop and start the sql server every night to release the idle connections?
3) If so, how to stop sql server from the commadn and start it with a command line command and do this in a batch file as a scheduled task?
4) Is there any other way to release these idle connections each night?
Any information you can supply will be appreciated. THanks.
David Spaisman
I have a database with tables that are used for various front-ends, Access 97 and ASP. All of a sudden, my "Stores" table will not let me add, edit, delete, insert records. I checked security permissions everywhere and cannot figure out why this is happening. Is there something linked to this that might be running a process that might be causing this?
TIA,
Bruce
I have several databases on a 2012 instance that are mirrored to a second server, and log ship to a third server for reporting purposes.Recently, for two of the databases, the log shipping has been failing at least once per day, and sometimes more often.
i have deleted and recreated both the mirroring and log shipped databases on several occasions, but the problem is still happening.The log shipping restore jobs don't get marked as failed in the job history, but if you expand the history you can see errors such as this:
Date21/11/2013 13:00:01
LogJob History (LSRestore_OAK-DCSQLDB1_OtherCarrierLive)
Step ID1
ServerCHERRY
Job NameLSRestore_OAK-DCSQLDB1_OtherCarrierLive
Step NameLog shipping restore log job step.
Duration00:00:30
Sql Severity0
[code]....
Restoring a new backup of the database cures the problem for anywhere between 15minutes and 12 hours, but it always seems to re-occur.I have run DBCC on the source databases with no errors reported, and five other databases have the log shipping working without errors.
I've got a job that sends out the results of a stored procedure in anemail via xp_sendmail. The job code is as follows:DECLARE @rlist varchar(1000)Declare @Q varchar(100)Select @Q = 'EXEC impact_exec..TLD_Reconciliation'Declare @Sub nvarchar(60)Select @Sub = 'TLD Reconciliation - Condensed Report'SELECT @rlist = 'jmiller@wbhq.com'exec master..xp_sendmail @recipients=@rlist,@query=@Q, @subject=@SubThe error message I get when running this in Query Analyzer is:ODBC error 7410 (42000) Remote access not allowed for Windows NT useractivated by SETUSER.In Enterprise Manager the owner of the stored procedure in question isdbo. Our SQL guru here suggested I change the owner of the storedprocedure from dbo to myself.I did that and got a warning message that changing the owner willbreak connections. (I'm paraphrasing here because I don't rememberthe exact wording of the warning.) Anyhoo, after changing the owner,and then trying to run the code in Query Analyzer I got the errormessage that the stored procedure could not be found.I'm not sure what to do here. I've never seen the error messagebefore. This same query worked just fine a couple of days ago.Any ideas?Thanks,Jennifer
View 1 Replies View RelatedHi,
We're running a replicationprocess for months now, and 2 days ago it broke down, for no appearant reason I can detect. The setup is this:
A SQL2K server has a publication defined on a database, consisting of several dozen tables. It is a transactional publication, running continuously. There is 1 subscriber, a SQL2005. Both servers run with Win2003 and all have the latest servicepacks.
Up until 2 days ago there was hardly a problem. Then I received errormessages on being unable to load into a specific table. That table had been changed on that day, namely, 1 column was changed from CHAR(13) to CHAR(12). I do not know if this has any relation with the problem we experience.
Currently the databases are structural the same. I could not get the replicationprocess to work and deleted all, publication on server1 and subscription on server2. I tried to setup a new transactional publication, which is not a problem, however, I cannot create a succesful subscription. I receive the message:
The process could not bulkcopy into table 'Tablename', where tablename is the changed table...
Again, both tables in publisher and subscruiber are the same in all respects. When I remove the offending table from the publication, the same message now with another tablename... Removing this table will result in again this message with another tablename...
I am really flabbergasted. Any idea where to look at?
TIA
I've been building and running script tasks for years without issue. Then all of sudden last week Visual Studio starts showing the "Task is configured to pre-compile the script, but binary code is not found" error anytime I open a script -- even I make no changes. If I copy the dtsx package to another machine, the script compiles fine and I can see the binary data in the raw .dtx file -- so I know the code is correct.
I can also reproduce the error simply by adding a new script task, going into "Design Script", make no changes to the default code (which is basically one line: Dts.TaskResult = Dts.Results.Success) and simply press "OK" on the Script Task Editor.
I've been trying to find some VS setting somewhere that might stop the script IDE from producing the binary code, but I can't. It doesn't seem to be project setting, because all my SSIS projects are now suffering this problem on my main dev box.
Anyone experience this?
I have had SQL2005 on a server for a very short period of time. Today I found that I am not able to execute an SSIS package in debug. It give me an error stating that the evaluation period has expired for data transformation services. I went to check the version by querying, but nothing happens when I click on the Server Management Studio link.
Has anyone seen this before or how long the trial version should last?
Does anyone know what version may have been installed on my server?
Thanks,
We have an application in which one particular stored procedure goes from .3 second response times to 20-40 second response times, suddenly, at seemingly random times of the day. Recompiling that particular stored proc fixes the problem temporarily.
The 3 main tables have between 500K and 1.5M records, are defragged daily and contain the past 42 days of work. Old records are deleted once daily. The slowdowns do not conincide with the deletions, occuring without a clear pattern. Nothing else on going on on that server -- it is dedicated to this one app. Nothing shows in event log. It is clustered Windows 2003, with SQL Server 2005 RTM version. SP2 of SQL2005 due for an install next Monday. This behavior also was seen when the app was on a different server running SQL2K SP3, so think the underlying problem is some sort of design issue with the app, not a SQL server bug. Has anyone seen something like this and what suggestions do you have for doing a permenant fix? Think that a recompile of the sp causes a new execution plan, but why would that be necessary daily or even several times a day? 30-50 users are banging away at it. The app is an order entry system. The tables contain what are basically order histories and label data. Am running out of good ideas. Thanks for any help.
I would like to create a job that wakes up every 5 minutes or so and stops any job that has been running for, say, more than an hour.
Alternatively, when it is a jobs scheduled time to run, if the job is already running, I would like it to stop the previous execution and start over.
Thanks
Hi, I am unsure whether i can delete some system created tables from a database.
I was testing replication and then used the wizard to disable it all. I am however left with three tables that are replication based that have not been deleted. they are :
MSreplication_subscriptions
MSsubscriptions_agents
MSsubscriptions_properties
these tables are causing problems with some third party software due to the length of their names. I have tried to 'Exec sp_rename' but i get an error saying the objects are not valid for this operation.
Can i just delete them or will this cause problems if i want to start up replication in the future?
Quick question...
I was under the impression that RAISERROR stopped excution in my DTS SQL Task, but it really just passes right over it.
For example:
RAISERROR('test error',19,1) WITH LOG
CREATE TABLE delete_me (data int)
Even though I rasie the error, the table still gets created. Any ideas on how I stop the task from going to the next line?
I'm trying to stop a SQL Server Agent Backup job if it is running past 7 a.m. Can you reply with your ideas.
Thanks.
Deb Dawicki
Sansum Clinic
System Administrator III
805-692-6422
In query analyser, I can stop a script with the "return" statement butif the script contains multiple batches (separated by GO) then thereturn statement only stops the current batch.Is there a way to stop the whole script?
View 2 Replies View Related