for SQL Server 2005, major build version 9.00.xxxx.

learn more… | top users | synonyms (2)

2
votes
1answer
27 views

App domain is marked for unload due to memory pressure

In my sql server log (2005 SP4) I have this message every couple of seconds : "AppDomain XXX [DataBase.dbo[runtime], YYY] is marked for unload due to memory pressure" Our server : Windows Server ...
2
votes
2answers
48 views

Running query progress indication

I have a query: SELECT * FROM OPENQUERY ( oracle, 'SELECT * FROM [some_table]' ) It runs for about 7 hours. I only need to run this query once to import data into a new system when we ...
0
votes
1answer
25 views

XML Network Call to Application from SQL Server 2005

We don't really have a DBA here, just a semi-experienced SQL Developer and me. I've only got about a year's experience myself and we're the only programmers for our small business. We're trying to ...
1
vote
1answer
29 views

standard steps to Restart Seconday server in Logshipping setup

I have to reboot my Logshipping secondary server. what are the steps need to be taken on primary and secondary servers to make the reboot clean and without hurting logshipping. env : SQL server 2005 ...
0
votes
0answers
17 views

Mirroring traffic looks normal but externally reported bandwidth of mirroring traffic is much higher

We have a live sql server in one location, running MS SQL Server 2005 Enterprise on Microsoft Windows Server 2008. We have a similar server in an alternative location (connected by vpn) serving as a ...
5
votes
3answers
206 views

SQL Performance issue after migration from SQL Server 2005 to SQL Server 2012

Yesterday we migrated a SQL Server 2005 database to SQL Server 2012. We made a full backup and restored it on the new server. Problem now is that the database on SQL Server 2012 is much slower than ...
0
votes
1answer
82 views

Restoring a SQL Server 2008 R2 backup on SQL Server 2005

I'm getting an error whenever I restore a testing database on SQL Server 2005 that was backed up from SQL Server 2008 R2. It seems that I cannot restore from a higher version of sql onto lower ...
1
vote
1answer
62 views

Database never maintained

Just moved from wrong forum i paste here my question: I just got a new client recently migrated from SQL Server 2000 to SQL Server 2005 due to vendor application limitation to new releases. Vendor ...
1
vote
0answers
22 views

Inside stored procedure, set column names of returned query according to variable

I have a query which I'd like to reuse, instead of having many different copies of it just for the sake of changing the column name. The report (for example) uses the same query, but there are either ...
0
votes
0answers
25 views

How to analyze incoming DML in SQL Server 2005?

I have database and specifically one table that is used for batch data transfer from another organization. With each run the table is truncated and rows are re-inserted. I want to handle that process ...
0
votes
1answer
26 views

Cannot access Properties page of a database

I'm in the process of decommissioning a database server and migrating the databases from one server to another. I was attempting to get the the properties of the database and received a SQL Error ...
0
votes
0answers
21 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
3
votes
2answers
145 views

Find which session is holding which temporary table

We have a SQL Server 2005 database the temp database has become full. By going into SQL Server Management Studio I can see all the temporary tables in the tempdb. Is it possible to tell which session ...
1
vote
1answer
59 views

How to transform this result set?

I have the result set above that I stuffing into a table variable @ApptTemp, and trying to transform it into something similar to the one below. Note that of the 4 rows that have a description of ...
0
votes
1answer
16 views

SQL Server 2005 Whole-Migration, which databases should I recreate?

In relation to my question about SQL Server 2005 migration procedure, I am re-creating the databases on the new server. I noted that the old server has the following databases (outside of System ...
0
votes
4answers
66 views

SQL Server 2005 - 2 sets of backups - 2 maintenance plans?

I did my best to search for an answer to this question and couldn't find a scenario quite like this. I'm a fairly new DBA in the sense that I haven't had a ton of training, I basically took the job ...
1
vote
1answer
45 views

Procedure to wholly migrate SQL Server 2005 to a new server

I'm tasked with 'rebuilding' a database server, because the old one is dying. To reduce potential for the new server f**king up, we had decided to rebuild the server as similar as possible to the old ...
4
votes
2answers
147 views

Query tuning to meet timeout settings [closed]

We have an web app with a 30 second time out on search screens. I've analyzed the original query and added a missing index for one of the query's 9 joins. Other things like expected and actual ...
1
vote
0answers
23 views

Will installing WebMatrix (and Consequently SQL Server CE) Break My Current Installation of SQL Server 2005?

We have a server that has (and needs to keep) SQL Server 2005. We are hosting intranet sites on one server (server 1), but have a database on another server (server 2). One of these sites uses AJAX ...
1
vote
2answers
52 views

Will creating an index improve performance on a full scan [closed]

Will adding an index on a Large data warehouse table (8Million rows, 200+ column) make any difference to the query time if all I am doing is selecting all rows from the table ? Thanks
2
votes
2answers
43 views

Replication between SQL Server 2005 - 2005

I'm hoping to get some help with a SQL Server 2005 replication issue. In short, in replication monitor, (On the Publisher), on the 'Distributor to Subscriber History' tab, I see two lines under ...
0
votes
1answer
60 views

SQL Server 2005 - Generate and Bulk Insert 3 million rows across 2 tables

I have a task to programmatically generate 3 million different rows of data and insert them into a database table for test purposes. I have written a VB.NET program that handles the generation of row ...
0
votes
1answer
21 views

What is the MS_PerfDashboard schema in msdb?

We just migrated an old reporting server (running on 2005) to 2012 and some of the database performance monitoring jobs have started failing. I looked into them and found that they use a couple of ...
0
votes
1answer
46 views

Looping through string, adding all numbers e.g. '123' = 1+2+3, demo with working loop included

This works to output the string 123456 as: 1 2 3 4 5 6 Code: declare @string varchar(20) declare @index int declare @len int declare @char char(1) set @string = '123456' set @index = 1 set @len= ...
0
votes
1answer
34 views

Best Isolation Level to avoid deadlocks in Sql Server [duplicate]

I need execute un update statement over an sql server table, this table is used by another process at the same time. because that sometimes deadlocks ocurs. wich Isolation Level do you recomend for L1 ...
1
vote
1answer
34 views

Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection

I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode. The page verification is set to TORN_PAGES detection. So, far the backup has been corrupted when we ...
1
vote
1answer
58 views

Using “Generate Scripts” with EMERGENCY/SINGLE USER mode

I am trying to create an INSERT script to salvage data from a single table in a corrupt database. I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
7
votes
2answers
302 views

Is adding index on bit column significantly slow down inserts?

I have a table with about 1 million to 5 million records. Small part of that records have one of bit column set to 'TRUE'. Need to fast find that records. I think that index can speed up searching on ...
1
vote
0answers
39 views

In SQL Server sp_cursorprepare/sp_cursorexecute run extremely slowly

I'm running an application (Pentaho user console with the Saiku Ad-hoc plugin) which creates a query and runs it using sp_cursorprepare & sp_cursorexecute standard stored procedures. My model is ...
0
votes
0answers
39 views

Master Slave Databases and their architecture

We are currently using Sql Server 2005. We currently have separate databases for different instances of our application. The application is a heavy in terms of data and processing. We now want to ...
5
votes
1answer
27 views

Why are zero length spaces being returned from a Union All against an empty table in SQL Server 2005 but not SQL Server 2012

Supporting an existing VB6 app with a SQL Server 2005 back end and we're migrating our database server to SQL Server 2012. Created a backup of the production database and restored it into a dev ...
2
votes
1answer
42 views

SQL Server Merge Replication Dummy Update issue

We have SQL Server 2005 SP4, using merge replication. We started getting this error when the subscribers try to replicate (not all of them but most): The process could not deliver dummy update ...
1
vote
2answers
69 views

Does RAM taken up Shared Memory connection counts against Max Server Memory?

I have an app that's local to the SQL Server and thus has a Shared Memory connection to it. I was wondering whether the RAM taken by the connection (including data transfers) counts against the max ...
3
votes
3answers
130 views

Is there a way to execute sql statement in sql server based on sql server version?

I would like to create computed index on a table if sql server is 2008 or newer and a simple index if sql server is 2005 or older: -- check for sql server version if (select ...
0
votes
0answers
44 views

linked server to a network csv file

I am trying to create linked servers from SQL 2000 and 2005 to a network share csv file. I am using Microsoft Jet 4.0 OLE DB Provider with "text" as the provider string. With regards to security, I ...
3
votes
0answers
69 views

Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?

I have an app (windows service) local to the SQL Server box. It calls a sproc on the SQL Server box that returns a ton of data and thus causes ASYNC_NETWORK_IO wait. The database connection from is ...
1
vote
1answer
281 views

Query that displays backup information (successful and failed) SQL Server

I have two jobs that backs up two different databases. Job 1 backs up DB1 Job 2 backs up DB2 DB1 fails to back up due to low space on Drive 1 resulting to a Job 1 failure. To fix that issue, I just ...
0
votes
2answers
208 views

c# Backup sql server database, error Operating system error 5(Access is denied.)

I have been trying to backup an sql server database, and I understand that this error is in regards to drive write protection. I am at the end of my rope with this, as nothing that I have found online ...
2
votes
0answers
59 views

backup history script produces incorrect results

I have a database that is backed up via maintenance plan. The database is scheduled to be backed up at 8:00PM. It usually takes 6 hours to complete. According to this query, SELECT distinct ...
7
votes
1answer
120 views

Necessary to include clustered index columns in non-clustered indexes?

Considering that a non-clustered index is based on the clustered index, would it be necessary for the non-clustered index to list any of the columns contained in the clustered index? In other words ...
4
votes
1answer
128 views

Is ASYNC_NETWORK_IO wait type anything to worry about?

In looking at the list of sprocs that take long time to execute, one stands out as causing the most wait. However, most of that wait (81%) is ASYNC_NETWORK_IO and I know why: the sproc transfers ...
0
votes
0answers
54 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
3
votes
1answer
317 views

How to improve Procedure Cache Hit Ratio?

From what I can tell Procedure Cache Hit Ratio below 95% is a problem. On my box, the values hover from 85 to 95%. How do I fix this issue? The server seems to have plenty of RAM so that ...
1
vote
2answers
70 views

Linked Server Has Run Out Of Memory

So I have a stored procedure that calls an AS400 Linked server. Now, the stored procedure will execute successfully. However, it is used in a SQL Agent Job and each time the job runs, it gives the ...
0
votes
2answers
9 views

One of the Database Ownerhas been Removed and corresponding property changes in sql server

A database has been created on SQL 2008 by a user named user1 ,on dec 2013.Today ,we are going to remove that user(/owner) from the server.What will be the owner property of the database show then?
1
vote
1answer
61 views

How do I find out if Sql server Agent's login has rights to a DB?

How do I find out if the SQL server Agent's login has rights to the target DB, that is the DB on which I will be executing a query ? Also, how do I find the service that's controlling Agent on the ...
5
votes
2answers
323 views

Issues with TempDB mdf file ever increasing

I have a tempdb growth issue. Let me preface everything by giving my tempdb settings. Even with no queries running on the database/server tempdb keeps on increasing in size, at first rapidly and ...
0
votes
2answers
46 views

Combine tables only if no results

We have a table FOO that has a huge amount of data in it, most of which is only used infrequently and by (slow) user-interaction. We would like to move all data that is more than 12 months old to an ...
1
vote
1answer
197 views

'Tempdb' is full warning message in SQL Server 2005

I am using SQL Server 2005. it's a running plant, Everyday large number of data posted into SQL Server 2005 SELECT TOP 5000 [T_idx], [T_TAG], [T_Date] FROM [house].[dbo].[total] ORDER BY T_Date ...
1
vote
1answer
59 views

Tool for identifying stored procs with deprecated syntax?

I have to move a DB running in compatibility mode 80 (SQL Server 2000) on a SQL Server 2005 to a SQL Server 2012. How can I scan it for stored procedures that might break due to deprecated or ...