Server Configuration
in [Microsoft SQL Server]
|
SQL Server failed with error code 0xc0000000 to spawn a thread Please help me resolve the error listed below that I received yeseterday from one of my SQL Server 2005 database servers. Error: SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Thanks, ... 19 Feb 2010 21:07
Oracle Linked Server LEFT OUTER JOIN - Inaccurate Results I am running SQL 2008. I have a linked server to Oracle using Microsoft OLE DB Provider for Oracle (MSDAORA). Allow inprocess=Enable, Collation Compatible=False, Data Access=True, RPC=True, RPC Out=True, Use Remote Collation=True, Collation Name=Latin1_General_BIN, SELECTS and INNER JOINS work fine when que... 19 Feb 2010 09:53
Theobald Xtract IS DeltaQ Hi, During a project I gained a lot of knowledge of using the Theobald Xtract IS DeltaQ component, which I like to share with you all. I have written five blog entries on my blog that give a detailed explanation of using the Theobald Xtract IS DeltaQ component in an SSIS project. I hope this will help you all ... 19 Feb 2010 09:53
How do I determine if msdn or license volume copy is installed I want to verify if the SQL 2005 enterprise is installed using a MSDN or volume license copy disc If MSDN was used, will it expired? Version shows 9.00.3042.00. Thanks, Tnt ... 18 Feb 2010 20:45
Snapshot agent uses all available memory on server I have a SQL server. SQL 2005, Service Pack 3, Cummulative update 5. Version 9.00.4230. Default server settings for memory. Server has about 3.5 gigs of memory. I have set up transactional replication to be it's own distributor on this sql server, it is set for a push subscription. I have placed the repldata fol... 18 Feb 2010 13:59
transaction log back up fails with spid53 BlkHeader from strip 0 at........... We had the same issue and this is how we resoloved it : 1. Run "backup log dbname with truncate_only" 2. Do a full backup of the db 3. Start the regular transaction backup That fixed it. From http://www.developmentnow.com/g/118_2004_1_0_0_467587/transaction-log-back-up-fails-with-spid53-BlkHeader-from-str... 17 Feb 2010 14:32
Problem installing SQL Server Express 2008 Hi Greg, There was a problem with the advanced packages last week. Have a look here: https://connect.microsoft.com/SQLServer/feedback/details/527374/download-file-seems-to-be-corrupt-tried-3-times-now-always-the-same?wa=wsignin1.0 I downloaded after the supposed fix but am still having an issue (as you will rea... 16 Feb 2010 22:55
SQL 2005 Saving Stored Procedures and Saving / Implementation I am not totally familiar with the proper terminology and I really appreciate help with the following problem: My two databases, originally from a third party, have over 250 stored procedures each. I have changed about 150 of them in one database. Due to the testing and implementation requirements of the appli... 17 Feb 2010 14:32
Calculate maximum connections during a day Hi, I'm looking for a way to monitor the number of simultaneous connections during a day. Is that possible? If yes, how is it possible? Thank you Fred ... 17 Feb 2010 04:30
unhandled win32 after installing visual studio 2005 I am getting this error when trying to straighten the page in my scanner program which is paperport "an unhandled win32 exception occured in paperport.exe" I tried changing DEP settings per web searches but to no avail. ... 16 Feb 2010 18:24 |