SQL 2005 attemted to read or write protected memory.

When we works on the SQL server itself with the SQL Server Manager, we receive regular the following error message: attemted to read or write protected memory. this is often an indication that other memory is corrupt. Google find the following for me, http://support.microsoft.com/kb/926421/, but this update is for a 32 bit environment. Do one of you know a solution for me, or tell me where I can find the 64bits hotfix?

SQL2005 x64 Developer on Win7 - Memory Mgmt

Greetings, I'm doing some development work and I've got the following configuration: - Win7 x64 Ultimate - SQL Server 2005 Developer x64, SP3 - 8 GB RAM The problem that I'm having is that the SQL Server Process is maxing out at ~150 mb, where this is really killing the performance of sql server. I used to have the system running Vista x64 and using the same database doing the same queries, sometimes I'd get SQL Server using up to 5.5GB of memory when doing some intensive queries. I'm no real SQL configuration whiz, but in the past, I've never had to do anything to

ghost cleanup task

I have a server running win2003, sql server 2005 sp3. Yesterday appears the ghost cleanup task on the server. I see that this task increese in cpu time and it cause that the cpu has 100% used. I reboot the server and the task appears again. I read on Internet many options and apply it but it doesn�t work. Do someone know why the process appears even after the server was shootdown? Do you know a way to avoid this task use a lot of cpu? How can I identify the process that is causing this task. Thanks a lot for your help. *** Sent via Developersdex http://www.developersdex

How to configure SQL server 2005 to store/search multiple language

Hello, What specific areas do I have to take care of in order to meet the following requirements: 1. The database needs to store correctly content in English, Spanish, French, Japanese, and Korean. 2. The database needs to return correct results in full-text and field-based search for searches in the above languages. Thanks very much in advance for any info! -David

Transact SQL teaser

Hi Gurus! I need your immediate help with a brainteaser… My problem: I need a setbased SQL for loading a Data warehouse. I have a dataflow with many rows per category. These rows should be grouped per date interval and ID and category. min (from_date) and max (to_date) should be delivered as in the result below. I can easily handle this with a cursor, but that’s to slow… What would you suggest? Best, Jocke The example: ID Category from_date to_date 1691789 43 2004-09-01 00:00:00.000 2005-03-01 00:00:00.000 1691789 43 2005-03-01 00:00:00.000 2005-09-01

SQL Express database size increases dramatically.

Hi, I am using SQL Express for a small application. I noticed the size of database increases by 10 - 15 folds everyday after database is 350mb+. Usually everyday increase is 2mb per day, but now it is more than 20mb per day. There is no change in operation. Pls suggest if there is any flaw in SQL Express. According to spec of SQL Express, it can be used until 4gb size. But the rate it is increasing now, it will be 4gb in no time. Version I am using is SQL Express 2005. Anyhelp. Regards, Biswa.

Forums versus newsgroups - can you indulge a SBS MVP by answering some questions?

As an SBSer since I have SQL on my server I feel like SQL is family so if you'll indulge me in a fishing expedition on forums versus newsgroups. I need to pick your brain a bit if you don't mind? Can I ask some fishing expedition questions because I want to see if my thoughts are on track with others. Just want to see if my thoughts are out in left field or what. I know why I like what I like but I want to know from someone else what they like and why. Do you like forums over newsgroups and if so why? Do you like newsgroups over forums and if so why? How did you firs

Capture Bulk Insert Duplicate Rowcount

SQL Server 2008 Std, SP1, Windows 2008 I am using bulk insert to load a large amount of data into my database. The tables have a primary key with the ignore duplicate values turned on. Everything works just fine, but I would like to track the number of rows from the input file that do NOT get loaded due to a duplicate value. Does anyone know of a way to capture this? Much thanx for any help with this... -- Jeff Carrington DBA comScore Inc.

SQL SERVER 2005 Database Engine Tuning Advisor Error "Statement does not reference any tables"

hi guys, I had a trace file from production (almost all stored proc execution events) and I'm using it to tune agaist the exact copy of production database. After running an hour, the progress shows in the Reason column almost all "Statement does not reference any tables" and there's no recommendation at all. In the statement column for DTA, it shows no real sql statement from the event but some weird statements like "END COMMIT TRAN", "RETURN @@ERROR" etc. I don't understand why DTA can't parse stored proc to see which tables are used but generate this error. Could someone here giv

SQL Server 2008 - Performance Alert Recommendations

Hello, I have just completed a migration from SQL Server 2000 to 2008 and am in the process of applying the finishing touches on the SQL 2008 server. I am currently creating Alerts and was looking for recommendations on what performance alerts to add. I have added a few obvious ones like Deadlocks = 1 and errors/sec > 0 and as I am new to SQL Server 2008 I was wondering what other counters people alert on regularly. I did some quick Googling but couldn't find any satisfactory articles. Some quick specs on my system, the database is primarily a back-end for our Intrane

Is there any way to check GRANT VIEW DEFINITION ?

There is a request to grant privilege to a particular user for viewing stored procedure source code for all databases. We searched the web and applied the following script: USE master GO GRANT VIEW ANY DEFINITION TO User1 Is there any way to check the view definition has been granted ? We have tried sp_helprotect for one of those databases but there is no action shown as VIEW DEFINITION. Your advice is sought. Thanks

Long execution time for UPDATE tbl SET @var = col = {expression} under SQL2000

Folks: We have SP queries like: UPDATE tbl SET @var = col = col + 1 WHERE keycol = x; -- update single row, indexed This query can sometimes sit for several _minutes_ on a MSSQL2000SP4 box, but we don't see similar delays on a MSSQL2000SP4+postSP4hotfixes box under large testing load. Is the performance of this type of query under SQL2000SP4 a known problem that was corrected by a post-SP4 hotfix? {/me crosses fingers} -- John Hardin KA7OHZ Senior Applications Developer, BI Specialist EPICOR Retail web: http://www.epicor.com voice: (425) 245-1800 fax: (

no value to be substituted by NULL word

Hi, I have a table with 5 columns where the last column doesn't have any values. I have to write a query to pull all information from the table (select * from table) but the last column should show word "NULL" as opposed to nothing. The "NULL" word should only be shown in the query result set and nothing should be changed in the table itself. Thank you, T.

A Question about SQL Server 2008 Installation

There are 6 cumulative updates after SQL Server 2008 SP1. If I setup a new server, after install SP1, should I install each of the cumulative updates, or just install the last one? In other words, does the last update include all previous updates? Thanks, Lijun

Identity column not being reseeded

Hi, We are in the process of migrating from one DC to another. I setup a transactional replication using SQL backups for a database that only has two tables which are very actively updated. Here are the steps that I followed in the order: 1) Setup distributor. 2) Restored full backup followed by T-Log backups (from publisher db to subscriber db) until the production maintenance window started. 3) after the maintenance window started i took last log backup and restored at the subscriber. 4) Setup publisher and set allow initialization from backup to true. 5) setup subscribe

What will happen to transaction log if we take a full backup ?

We are running daily database backup and transaction log backup every hour. We would like to know if we make a full backup mid way the day (Like: 12:20pm), can we still be able to restore point in time to a time before that full backup (Like: restore from last night backup and transaction log backup to 11:15am) ? Thanks

newbe question

Hello everybody, I have an VB.net app with a ms sql server database. If I want to deliever the application I should send the database information as well. My question: what is better strategy - to send CreateDatabase query or backup of the database to my customer. What is easier for the customer to get fast the database structure - to create it from the sqlquery or to recreate it from the database.bak? I would like to avoid all problems and to make the job for unexperienced administrators easy. If the customer installed sql server - what tools does he need to be able to use sql

Uninstall SQL2005 Reporting Service

Hi.. I try to uninstall SQL 2005 reporting service from add/remove program, but it didn;t work because it's still there. Does anyone has any idea on how to remove it once & for all? Thanks.

SQL 2005 & server side trace

Hi, I am trying to set up a server side trace where it will collect logins and objects access by a list of users in one database. The problem I am running into is using more then 2 sp_trace_setfilter to capture more then 1 user name. Either I get nothing or get everyone and that is not what I want. Here is a snippet of the code I'm running via a query window. exec sp_trace_setfilter @traceid, 3, 1, 0, 29 -- dbid for MyDatabase exec sp_trace_setfilter @traceid, 11, 1, 6, N'%joesmith%' -- any version of a user with joesmith exec sp_trace_setfilter @traceid, 11, 1, 6, N'

trace logins

How do I trace all logins to a specific database? I want all successful and failed accesses to some of my databases in my sql server. 1. I have about 100 databases, I want to trace accesses to about 20 of them. 2. The databases has several logins each, I don't want to search in logs for every single possible login name, which sometimes are AD groups/accounts (several thousand possible). 3. The databases is sometimes taken offline, the users gets an error - is this possible to trace/log this in any way? I don't mind if failed logins (wrong user/pass) also gets logged. 4. The

Recommendations for self-teaching material for 2005/2008 Business Intelligence Platform?

Hello, can someone recommend a self-teaching material for the Business Intelligence Platform 2005/2008 (Analysis Services, Reporting Services, Data Mining, etc.)? Thanks! Thomas

Is there any access right for Stored Procedure ....

If we create an account that have read access to a database in SQL Server 2005, can it read the stored procedure in that DB OR other privilege has to be granted ? Thanks

SRID values for Spatial Data Tyoes in SQL Server 2008

Hi There I've been investigating spatial data types in SQL Server 2008 for my customers. It appears only certain coordinate systems are supported by SQL Server 2008. How do I request that the missing coordinate systems for my country (New Zealand) get added? More details below: For the geometry data type: None of the local projected coordinate systems for NZ are supported in SQL Server 2008. These supported EPSG codes (SRIDs) are stored in the sys.spatial_reference_systems system view in a SQL Server 2008 DB. (NZ projected EPSG codes are 27200 (New Zealand Map Gri

Can't insert Char(1) into SQL Server from Stored Procedure

Hello I am trying to insert a char(1) field into a table from an ASP.Net/C# application. At first I was inserting rows into the table but none of the columns that I was inserting the rows into were char(1) columns, they were mostly int and varchar columns. Then I found out that there was one column in the list that was not supposed to be an int column but instead it was supposed to be one of the char(1) columns into the table. So I replaced the int column in the list with the char(1) column and since the value of the char(1) column resulted from a CheckBox ('Y' or 'N

Access to SQL Server from DMZ - is Mixed Mode authentication required?

Hi, Can you access SQL Server 2008 in an intranet from a DMZ web server using Windows Authentication? Or do you need Mixed Mode authentication set up? In other words, can you pass Windows user account and password through on a connection string? Cheers, James

ORDER BY not working in VIEWS?

Hi, (SQL Server 2005) It seems ORDER BY does not work when presenting data using a VIEW? If I enter design mode and "execute SQL", the data is sorted, but if I "Open" the view, the data is not sorted. -- Gerry Hickman London (UK)

How do you get a database into recovery mode.

Here is the scenario. I have a database on an equallogic box. The equallogic box does a snapshot at 10:00pm, on sql server i am doing transaction log backups every 10 minutes. The database breaks at 10:30, so I restore to the 10pm snapshot(this is not a sql snapshot). How do I get the database into recovery mode, so I can apply the transaction logs?

DBA Job Change

After working for years as a DBA for my company I would like to transition to another position within the corporation. The company has a large IT department, however I'm not sure what I can transition to being a DBA. I'd like to hear from other DBA's out there that have transitioned to other jobs within or outside their company and if they successfully made the transition. What did you transition to? What IT jobs would a DBA qualify? Thank you very much in advance!! -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201003/1

CHECKDB loop SQL 2008

On my SQL 2008 SP1 server it seems there is a loop of events for 3 of the databases existing on this server. On the Windows Application event log there are intermitently logged events 17137 Starting up database 'db' and then 17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd 07:13:53.453 (local time). This is an informational message only; no user action is required. The date is from a previous maintenance plan. These avents are logged every 20-30 minutes. Same events on SQL logs, too.

Dump Database instantly

Hello, I would like to capture the contents of a database (complete) at a particular instant. This could be triggered for different reasons. At any one of these trigger events (trigger: not to be interpreted as SQL trigger) the entire database should be dumped in whatever state it was. This will be used for analysis later on. How can I achieve this with the least performance impact on the database, application and server? Cheers

orphaned transactions

Hi I have located some orphaned transaction in "sys.syslockinfo WHERE req_spid= -2", but I cant see them using sp_who or sp_who2. I can still kill these using UOW. Any idea why these are not listed in sp_who with spid=-2? thanks in advance -- Regards priw

SQL Server 2005: Management Studio missing after setup

hi everyone i already posted this in the setup group but couldn't get a reply up until now. yesterday i was experiencing some issues trying to install SQL Server 2005 on my Windows Server 2008 R2 box (64-bit). after i completed the installation i can't seem to find the SQL Management Studio. i have selected all components to be installed, including "workstation components, books online and development tools". i tried searching for SQLWB.exe but couldn't find anything. thanks for your help! cheers marc -- MCP, EPM consultant Zurich, Switzerland

Reinstall necessary to rollback SQL 2005 SP3?

I'm very confident that SP3 will be installed without a mishap, but the boss is insisting on a fallback plan. So, I started investigating what it would take to roll back to SP2, and was alarmed to find that an uninstall/reinstall of SQL Server (along with a couple other hoops to jump through) was necessary to roll back from SP2. Is this still the case for SP3? -- Sick of googling, Bob Barrows

plan guide question

Hi, We have stored procedure that performs well on one server, but it takes forever on the other. Databases are the same (backup&restore). Hardware wise, servers are approximatelly the same. I'm wondering if I can generate plan quide for this stored proc on one server, and implement it on the other? Thanks

Estimating application memory requirements

Our company has an app that is heavily dependent Sqlserver. Our test server is 64 bit with 32gb of RAM. I am hoping to find a minimum amount of RAM to recommend to our clients. If i set the MAX server memory value low and then increase that value with the same load, and watch the Sql memory stats will i be able to find the point at which more memory to the process isn't adding value? i am using this for performance counter values http://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/ which looks a lot like this one http://

maintenance plan log files

hi, After I moved sqlagent logs to another drive (Right click Error Logs - > Configure -> change path), I found the Maintenance plans logs can't be generated any more. The job itseld on the job history runs successfully but if I right click maintenance plan-> view history-> show steps and I will see the red error: "Access to the path 'C:\ \Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\ \Log_Backup_Subplan_1_20100301134505.txt' is denied." The path shows the old one. So it seems that I need to change the Maintenance plan log file location separately but I can't find it any

syslockinfo, dm_tran_locks, sp_lock - performance SQL 2008

Has anyone else noticed performance issues with querying syslockinfo, dm_tran_locks and sp_lock since upgrading to SQL 2008? It seems they perform the worst on named instances. SQL 2008 Server 2008 named instance - 4 seconds SQL 2008 Server 2003 named instance - 1 second SQL 2008 Server 2008 default instance - .5 seconds SQL 2005 Server 2003 default instance - .150 seconds Dan

FTS: can I find texts not containing a specified word?

Hi everybody, Is there a way to find all records except the ones containing the specified word, for example, "research''? Unfortunately, texts don't have a common word that could be used as the first operand for operation &! I tried to use in CONTAINSTABLE() such combinations as "*" &! "research", "a" &! "research", but such queries found nothing. Thank you.

Comparing two databases.

Hello readers, We have two databases. Database A which holds our production data. (2 Gig) Based on a old release. Database B which is fresh and new and only holds initial data. (200 Mb) This is a new release. We want to look at the inital data and was is new (and changed) in B. Offcourse all (or most?) identitynumbers have changed in B. The number of tables is thousands. I think this is almost an impossible task, so I do not expact a simple solution, but sometimes some of you have very valuable suggestions which do help. So suggestions are welcome. We asked the people w

Moving Resource Databases

Hi I have tried moving all system databases (and Resource DB) on a 2005 (9.00.3301.00) 64 bit instance to another Drive following the steps outlined in: http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx All visible system databases were moved successfully, but the system still looks for the Resource database in the original location So I had to move the files back. I am unable to attach this database to alter as it is in use. Has anyone successfully managed to move the resourse DB and is there is there anything else I could check to enable me to move the

problem with select

Hi, we have some tables with name begins with figures( like 98765_order). This causes a syntax error when doing a select (select * from 98765_order). Anyway to solve this easily? Thanks Luc

Proc cache consumed with one-time queries

In investigating memory usage os our SQL Server 2005 SP3, I noticed that about 4.3GB of our 32GB phsyical memory was consumed by the procedure cache. In looking at what was in the cache, I found that the overwhelming majority of the stored plans were from queries that will never be reused. In fact 4.1GB of the 4.3GB were plans with usecounts=1. Most of these turn out to be statements generated by Sql Server itself: there are many that are statements generated by SqlAgent, running scheduled tasks. Many more are the backup statements generated for log shipping. In these cases,

Optimizer choice doesn't make sense, goes from index seek to table scan when adding a SARG

Running on SQL Server 2008 SP1. The following select (correctly) uses a non-clustered index on ACCT_TYP_CD returning just over 15000 rows in 41ms. It does a single scan and needs 37 logical reads to complete the query. select acct_cd from CS_FUND where ACCT_TYP_CD = 'G'; Change the query to be this: select acct_cd from CS_FUND where ACCT_TYP_CD = 'G' and GRP_TYPE_CD = 'BKR_RULES'; and the optimizer now chooses to do a clustered index scan, taking significantly longer, 971 ms, 8 scans and over 59,000 logical reads. It returns no rows. The database has auto upd

Sacramento, CA SQL Server group

I'm looking for people in the Sacramento, CA area that would like monthly, or bi-monthly SQL Server User Group meetings. Though there are several rough spots to get over (not the least of which is a meeting place), I'm hoping that there are enough to make it worthwhile.

BUY FAKE PASSPORTS OF FRANCE,FAKE FRENCH PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORTS

Our team is a unique producer of quality fake documents. We offer only original high-quality fake passports, driver's licenses, ID cards, stamps and other products for a number of countries like: USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France, Germany, Israel, Mexico, Netherlands, South Africa, Spain, United Kingdom. This list is not full. To get the additional information and place the order just visit our website: http://www.sellingpassports.com >> Contact e-mails: General support: support@sellingpassports.com Technical support: tech@sellingpas

SQL Server to SQL Server over the Internet

I have a requirement, actually more of a “really-like-to”, to set up a Sql Server 2005 to Sql Server 2005 data posting option over the internet. Obviously things like security, logins and port numbers come into play but what I am looking for in terms of advice is best methodology. I’ve looked at Linked Servers and Service Broker and both seem like they can get the job done; each with its advantages and disadvantages. I’m more inclined to go the Service Broker route but at this point it is only a slightly educated guess. Data volume would not be high and what I am trying to avo

problem slow queries after installing sp4 on sql 2000

hi, we have a sql server 2000 sp3 on a w2003 and some days ago we installed sp4 to that sql instance. We are having some big problems with queries really slow down, taking to much long to complete or locking to themselves, ie. spid 105 locked by spid 105 if you throw a sp_who2. i've read that this was a common problem with sp4, so, is there any way to solve this? some hotfix that i don't know or something? i wouldn't like to detach databases, install sql server again, and reatach all databases.... thanks for any help!

Linking/attaching access tables

Hi Is it possible to link access tables to a sql server 2005 db? I can't seem to find any option in Management Studio. Thanks Regards

sql server agent won't start

hi guys After I moved my sysdatabases and error log to another drive, I restarted the sql server services. The databases look fine but sql server agent won't start. In the error log/windows event log, there's no error message except saying "sql server agent shut down successfully" sth like that. I checked all the data/log/errorlog folder/files permissions and made sure sql server service account (also sql server agent account) have all the permissions but still sql server agent won't start. But then I tried to add that account in the local administrator group on the server and

SQL can't calculate!

Please someone tell me this is possible! I am trying to get the correct calculation from a very simple division: 630/60 which is 10.5. SQL 2008 only displays 10.0. I tried every which way I can think of. Here is all my code: select 630/60 -- should be 10.5 select CAST( 630/60 AS decimal(10,2)) -- should be 10.5 select CONVERT(decimal(10,2), 630/60) -- should be 10.5 select CONVERT(float, 630/60) -- should be 10.5 select CONVERT(numeric(10,2), 630/60) -- should be 10.5 select CONVERT(money, 630/60) -- should be 10.5 I even tried using ROUND but still the same. On my computer