The log for our SQL 2000 database shows constant "starting up database dbname" entires. Is there a option that causes the databases to constantly be starting or is this a new feature of SQL 2000.
View 1 RepliesHi,
How can I avoid certain messages from SQL Server being recorded into the Event viewer ?
For example, every time I truncate the transaction log with 'Backup log with truncate_only', It is being recorded into the Event viewer as an Error. But, I know that it is not an error.
How can I avoid this ?
Thanks
Hi,
How to log queryresult messages (not result) into file using sql query?
I am looking for storing results into file like (2 Rows affected) and also error messages thrown by system.Any idea?
Regards
Arun.M
Hi All,
As Jamie Thomson has written:
http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
'...we can attach an event handler to the package...and this one event handler will catch all events raised of that event type by every container in the package...'
Fine. Now what I want to do is catch all OnInformation events generated for the package, and disgard all apart from a subset, whose message contains a particular string. So the Q is, how do I/can I interrogate the message for the event that my handler has just caught?
Michael Coles has come up with a neat method of overriding sp_dts_addlogentry, (http://blogs.sqlservercentral.com/blogs/michael_coles/archive/2007/10/09/3012.aspx), but I want to do this within the package, not outside, to avoid the change becoming global to every package writing to the same sysdtslog90.
Hope this is poss.,
Hi:
How can I copy the error messages when I execute a SSIS package?. The Progress tab or the Execution results tab both dont have the means to copy the results. I would like the errors to be output to a text file under a directory on my drive system (some thing like C:SSISExecResults.txt). Is this possible?. If so how do I configure my package to output the package execution results to a text file?.
Any help/suggestions/comments highly appreciated.
Thanks
AK
The log for our SQL 2000 database shows constant "starting up database dbname" entires. Is there a option that causes the databases to constantly be starting or is this a new feature of SQL 2000.
View 1 Replies View RelatedThe ExecuteSQL task makes it easy to capture the resultset of a query or stored proc in a variable. But what about the messages that would normally appear in the Messages tab when running queries in Management Studio or Query Analyzer? There must be a way to display and log rowcounts and other messages that a query normally produces.
Various package/task logging configrations haven't helped. I've read discussions about logging rowcounts in data flow tasks, but what about capturing messages in ExecuteSQL and other control flow tasks that run T-SQL?
I only have enough time to dabble in this technology so I may be missing something obvious or approaching this incorrectly. Any suggestion, reference, constructive criticism or reponse would be appreciated.
I am writting a huge Service Broker Application. I notice that each message that is processed appears in the SQL Server Logs. Currently I am just testing with a single queue and tons of messages are showing up in the log. Is there a way that I can turn these informational messages off? I think in the end I may have something like 15 or 20 queues. These messages are very useful for debugging but I may not desire this extensive logging to be running all the time on all of my queues.
Gary
Hello, I am getting many of these messages in my server's event log (approximately 13 every 5 seconds or so). I have tried clearing the queue with "END CONVERSATION @ConvHandle WITH CLEANUP;" but the event log keeps getting messages. I have attached an example below.
Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 9724
Date: 7/10/2007
Time: 3:52:37 PM
Description:
The activated proc [dbo].[SqlQueryNotificationStoredProcedure-32e779eb-edcb-44d1-ba30-93f46ef9d9f8] running on queue HoudiniPlatform.dbo.SqlQueryNotificationService-32e779eb-edcb-44d1-ba30-93f46ef9d9f8 output the following: 'Could not find stored procedure 'dbo.SqlQueryNotificationStoredProcedure-32e779eb-edcb-44d1-ba30-93f46ef9d9f8'.'
Installed evaluation copy a while ago.
Yesterday got a new server and wanted to detach and move the database from old server. However, SQL server will not start on old server.
New server runs SQL 2000 Enterprise edition.
How do I get my old database detached and moved?
Your advise is appreciated.
My SQL2K was running fine. Yesterday, I decided to install SP3a. During the installation, it failed when apply sp3_serv_repl.sql. And I can't start SQL server anymore. The error is :
FRunCM : Process <> generated Fatal Exception C0000005
Exception Access Violation - SQLServer is terminating this process.
No matter what I did, I couldn't start the service again.
SO I decided to uninstall SQL2K and install again. Installation is ok, no problem. But, again the SQLServer service cannot start up. The same error appeared. Besides, there is also the error about :
Supersocket Error 1355.
I have tried all the suggestions that I can find in the net but nothing seems to work.
Please advise what should I do. Thank you very much.
Philip
Where to start.
I have my 2005 CD ready and server.
So i will install 2005.
How do i start migrating SQL 2000 to SQL 2005 (on our SQL 2000 some of the databases cannot be converted to 2005 as the vendor is not ready.
Is there a way to do each database one by one.....(If so if anyone got any recommendations on how to start this i appreciated it).
Thanks
Hi
We have a demo version of our SQL2000 application that uses MSDE. This has always worked sucessfully in the past.
However, at the most recent installation however there is a problem which I cannot seem to fix.
MDSE was installed on Windows 2000 using the Local Admin account.
When the user logs on to the PC, SQL will not start gives error message '5 Access Denied'.
I have given the local user read/write permission to the Data directory and mdf/ldf files that it contains.
I have tried starting SQL specifiying it to log on using the Local Admin account but it makes no difference.
Does anyone know what else can I do?
Thank you
Mark
I am getting following messages in sqlagent.out. Can anyone help me understand what does these mean.. and what can i do for them?
2006-11-17 15:45:00 - + [235] Job CR QUEUE ON LINE - [HU][10720]20061117 15:44:51 is being deleted (job has delete level 1)
2006-11-20 09:33:20 - + [235] Job CR QUEUE ON LINE - [WM][3293]20061120 09:33:09 is being deleted (job has delete level 1)
2006-11-20 11:24:37 - + [235] Job CR QUEUE ON LINE - [LA][541]20061120 11:24:26 is being deleted (job has delete level 1)
2006-11-20 11:25:24 - + [235] Job CR QUEUE ON LINE - [LA][542]20061120 11:25:16 is being deleted (job has delete level 1)
2006-11-20 11:35:37 - + [235] Job CR QUEUE ON LINE - [HU][10721]20061120 11:35:27 is being deleted (job has delete level 1)
2006-11-20 12:04:22 - + [235] Job CR QUEUE ON LINE - [LB][3920]20061120 12:04:12 is being deleted (job has delete level 1)
2006-11-20 13:30:46 - + [235] Job CR QUEUE ON LINE - [PD][2594]20061120 13:30:35 is being deleted (job has delete level 1)
2006-11-20 15:44:43 - + [235] Job CR QUEUE ON LINE - [LB][3921]20061120 15:44:32 is being deleted (job has delete level 1)
2006-11-21 08:57:46 - + [235] Job CR QUEUE ON LINE - [HU][10722]20061121 08:57:29 is being deleted (job has delete level 1)
2006-11-21 09:00:14 - + [235] Job CR QUEUE ON LINE - [HU][10724]20061121 09:00:05 is being deleted (job has delete level 1)
2006-11-21 09:04:43 - + [235] Job CR QUEUE ON LINE - [HU][10725]20061121 09:04:34 is being deleted (job has delete level 1)
I found a usefull link to my problem : http://support.microsoft.com/Default.aspx?id=277535
But I am unable to find the s80xLang.exe file anywhere. I have looked through all my DVDs and nothing.
Anyone know where to look or download it from ?
I am new to SQL Server 2000, I am looking to set up some type ofloging on out test database.I need to track what table are hit when a record is inserted via afront end piece of software (Struxure).Any help would be appreciated.Daniel KubicekSenior Programmer Analyst - Engineering & ProcurementGrede Foundries, Inc.414.256.9210Join Bytes!
View 1 Replies View RelatedCan you plz tel me where all dts information store in sql server 2000.
is it in the master databse in some table
thanks
sandipan
Please feel free to redirect me if this has been previously addressed. I've read through the FAQ post and searched the forums, and as yet haven't found anything relevant on Google so I'm hoping you folks can help.
I am using SQL Server 2005 Express Edition on a fully patched Windows 2000 Server, and for some reason the database just will not start up when the machine starts or reboots. The service starts fine if I go start it by hand though. This is obnoxious because it prevents me from running fully automated updates to the box since that reboots it at least once a week on "patch Tuesday".
Here are what my related services and their startup types look like:
SQL Server (MSSQLSERVER) Automatic
SQL Server Active Directory Helper Disabled
SQL Server Browser Disabled
SQL Server VSS Writer Manual
This is a production machine so I'd prefer not to run any services I don't have to. All this database needs to do is sit there and get hit by a local Cold Fusion instance that talks to it by TCP/IP. Any administration on it I tend to do locally with Management Studio Express by remotely logging into the server on it's internal IP.
The really weird thing is, I have these services configured exactly the same on development environments I've created in Windows XP and Windows 2003 Server Standard Edition. This seems to be specific to Windows 2000 Server, and I just can't figure it out...
Any advice much appreciated!
I need to determine how often our SRS reports are being used. Is there any internal metric I can set and then check to find this out? We have a lot of reports and want to find out if some of them can be deleted for low usage. I understand SRS 2005 might have this capability but I have heard there's a way to do this in SRS 2000 as well.
If there is nothing internal to SRS 2000 that will do this, I wonder if anyone else has written some code to do this or has some ingenious method!
Thanks for any help!
Hello,
I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.
Hi;I went to the microsoft site to try to find a guide to the errormessages that the jdbc drivers give ( for sqlserver 2000 ).I had no luck.Does anyone know if there is such a guide?I got this mysterious error message below in my logs ( nothing visiblein user land ).Anyone know what it means?Thanks in advanceStevejava.sql.SQLException: [Microsoft][SQLServer 2000 Driver forJDBC][SQLServer]Transaction (Process ID 151) was deadlocked on lockresources with another process and has been chosen as the deadlockvictim. Rerun the transaction.
View 5 Replies View RelatedI have used skiperrors parameter for 2601,2627 and 20598 errors in my Transaction replication setup. When transactions with above error are encountered, its skipped but I€™m not getting sql command that is skipped in MSrepl_errors table. Since SQL server 2000 is not saving transaction sequence number in the MSrepl_errors we are not getting the command, which have the errors.
Is there any way to track the commands those are skipped in transactional replication.
When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?
Thanks!
OK, I've been looking and maybe there is an answer to this somewhere, but I haven't seen it.
I've got a database that has as its status "Shutdown, Normal". All the other DBs on my machine are "Normal" as status. The problem is that the one that is shutdown is the one I really need to be executing in. How do I start it?
Thanks!
Jeff
Hi,
I would appreciate any help or suggesions on starting with database design for an asp.net site.
I know this question maybe sounds silly but I feel stuck and don't know where to start.
Yours sincerely
Andla
Hi,
I have a SQL2k STD with SP3 installed.
Currently, only one database db_XYZ is there. The server has been started up since 07/03/2003 16:00 pm. But in the sql server current log: "Starting up database 'db_XYZ'." info is spreading from that time (16:00 pm) to this morning 10:00am at an interval from every 1 minute to 4 minutes.
Why need to 'Starting up' this database so much times?
This reminds me that this 'Starting up' is kind of 'abused' in many other servers. Any idea?
thanks
David
OK, I am experienced in VB6 but new to SQL.
And I want to use SQL for my database for some software I develop.
I have understood the basic principles how to communicate with a data base using SQL. What I have not understood is how I start a new database for SQL, subject SQL as such is installed on the server. But how to initiate a new data base?
Will really appreciate help with this.
Per Oberg
Greetings,
I am developing a package on my local workstation. I have defined two logging service providers. One is for SQL Server and the other is for the Windows Event Log. I am using the Dts.Log method in a script task to write log entries.
Logging is working properly with the SQL Server provider and rows are being inserted into the sysdtslog90 table. However, the only events that are being logged in the Windows Event Log are the package start and end events which I believe SSIS is doing automatically anyway.
Is there something I need to do to enable WIndows Event Log logging other than defining a log provider and making sure it is checked active? Won't SSIS write to two different logs with one Dts.Log call? Any ideas on what might be going wrong with my approach?
Thanks,
BCB
Hi,
I've got a sitatuation where one of our sql databases appears to be frequently "starting". The log entry looks like:
Starting up database 'Database'.
And seems to occur at irregular intervals and does not seem to be inline with any other db activity....i.e. transaction log backups, insertions or reads.
This DB is fairly busy receving inserts from our PBX CTI software almost constantly.
Note this is the only DB on the server displaying this behaviour (we've got two named instances running with several databases in each).
Any help / pointers appreciated.
Rgds,
SLE
Hi,
I decided to use the SQL Server log provider to store logging data of all my Integration Services packages. I also created some reports about this data for operating purposes.
I have a problem occurs the name of the executing package is not always written to the log,but the name of the single task which failed. But that is not very useful information for operating, because I do not see any chance to get the name of the package by the information which is logged in the sysdtslog90 table in the database which I defined for SSIS Logging.
How do I configure the package to always log the package information into the table, too?
Best regards,
Stefoon
Hello I keep getting Various database connections in MSMSE.
The error is
Micorosoft SQL server management studio express error
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Could not load file or assembly 'Microsoft.SqlServer.Express.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A) (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Strong name validation failed. (Exception from HRESULT: 0x8013141A)
------------------------------
BUTTONS:
OK
------------------------------
I just opened CMD. and did the following
Command Prompt
cd D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
sqlservr.exe -s
and it returned the following
Error : 17112, Severity : 16, State: 1. The error is printed in terse mode because there was error durring formatting. Tracing, ETW, Notifications etc are skipped.
kk so what can I do?
The comapny i work for has a server running the following.
Opteron 246x2
2 Gig memory
320 Gig Sata 2 drives
Windows 2003 Standard Edition
SQL Server 2005 Express Edition. The Free one.
There are approx 10 users that connect to the server.
There are two programs which seem to use sql server. Act 7.0 and service ceo.
When the computer is rebooted its at 0% for sqlserver.exe
Than when all connect it maxes it 50% and its steady there. Seems Service ceo affects it the most.
Told by comapny need to buy full blown sql server to resolve problem. But i dont think this is the problem.
Questions: Is it common for server to be at 50% all the time with sql server running?
And if its not is there a way to reduce the sql cpu usage.
I am new to sql server and have done alot of research and fixes. Ive unsitalled and reinstalled all sql instances and done the tweaks suggested. Any fresh ideas would be great thanks.
John
We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .
MDDB database is accessable & in Log file its recovered fully
Thankx in Advance
Sha