Questions tagged [sql-server-2005]

SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.

77 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
78 views

What are the risks if you rename a server that hosts a named instance of SQL Server (2005) and skip updating the system metadata?

My apologies as this is the last SQL 2005 instance we have and it's pretty urgent or I wouldn't go through all this trouble asking. Questions What is the risk to leave things as they currently are, ...
0
votes
0answers
40 views

Error when deleting file using xp_delete_file on SQL Server 2005

I'm trying to delete old backups with a scheduled job in SQL Server 2005, running on Windows Vista. Here's my script: DECLARE @BackupPath NVARCHAR(1000) DECLARE @DeleteDate DATETIME SELECT @...
0
votes
0answers
21 views

Audit Trail Settings in SQL Server 2005

Where I can find the Audit Trail Settings in SQL Server 2005. Google search gives link to the topics like "how can we create audit tables", but I just need to know where I can see the current settings,...
0
votes
0answers
30 views

Odd Profiler Trace Replay Error

I am working on migrating a client from a really old SQL Server 2005 database server to a SQL Server 2016 install. Everything appears to be fine for database import, validation, testing...etc. I've ...
0
votes
1answer
28 views

SQL 2005 SP2 Database on SQL 2012 Instance

I've an SQL Server 2005 SP2 instance that contain old databases that are not compatible with other SP of SQL Server 2005. Those databases are on physical server that don't have any space to backup ...
0
votes
2answers
68 views

How can I find out what my SqlServer 2005 CPU is mostly working on?

I apologize if this is somewhat of a rookie question. After looking online I found some articles that explain how to find the worker time per query using sys.dm_exec_query_stats. e.g. SELECT TOP(10) ...
0
votes
1answer
45 views

Server and Database role memberships required to add columns and constraints

I have a user with the following server and database role memberships: securityadmin (server) public (server) db_owner (database) db_accessadmin (database) db_securityadmin (database) When running ...
0
votes
1answer
37 views

Linked-server query against remote DB does NOT fail when DB is in SINGLE_USER mode

This is really strange to me. I have a primary server Foo2005 and it has a linked-server entry pointing to Bar2008R2; say the name of the linked-server is BarLINK. I write a query such as SELECT * ...
0
votes
1answer
27 views

unistall sql server 2005

I hope someone can help me . I 've Unistall all components sql server 2005 in the control panel but the configuration tools still there. I try to open HKEY_LOCAL_MACHINE > Software > Wow6432Node > ...
0
votes
0answers
2k views

pros and cons of partition or not-partition this sql server table that is highly hit?

I have a table that is highly hit on my database. this table has 370,370 records. when I run the following select: select [ImageSize] , the_num = count(*) from [dbo].[ProductImages] group by [...
0
votes
1answer
69 views

How do I perform daily, monthly SQL Server 2005 maintenance?

Team, I have SQL Server 2005 and I am new to DBA role and wondering if there is any T-SQL Script/Stored Procedure out there that they will help me accomplish the following on regular basis - Daily, ...
0
votes
1answer
61 views

Sub Query vs Table Filter

I have have been assigned to resolve Performance issue of a Stored Procedure. Select TableTwo.Column1, DatabaseTwo..TableThree.Column2, Sum(TableTwo.Column3) As Column3 --- Section 1 from ...
0
votes
0answers
90 views

SQL query running slow compared to its earlier execution time

One of our application using an SQL query is reported running slow. Current execution time:- 15 minutes and so Earlier execution time:- 30 seconds. SQL-Sentry Plan for the slow query I've checked ...
0
votes
0answers
317 views

Tran Log file growing even after log backups and Log shipping configured

I have log shipping configured for a database in SQL server 2005 with below details: A) Database X hosted on primary: Log backup every 1 hour as scheduled in LS Backup job: Data file: 40 GB and Log ...
0
votes
0answers
507 views

Is my SQL Job causing the High Disk usage?

I have a concern regarding High Average disk queue length for one of my server with below configuration: Version: SQL 2005 with SP3, standard edition. windows: version 2003 r2 SP2 No Processors= 4 ...
0
votes
0answers
88 views

Physical Table being used a Temp Table in a warehosue. Any advantage?

As I stated in previous posts I've inherited a warehouse based on SQL Server framework. In my continuous review of existing components and the practices adopted by the predecessors I found something ...
0
votes
0answers
59 views

select random tuples but prefer old dates

With this table: CREATE TABLE T_TEST ( id int identity, somevalue varchar(256), lastupdate smalldatetime ); i want to select n random tuples which age is older than x days but prefer old tuples (...
0
votes
0answers
123 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, ...
0
votes
0answers
74 views

SQL Server 2005 Create a SQL Server failover cluster check button is not enabled

I try to install SQL Server failover cluster under windows 2003 or windows 2008. In both installing time I found the checkbox enable error. I don't know any changes want to do to windows server before ...
0
votes
0answers
2k views

Cannot recover the master database. SQL Server is unable to run

Right, I powered off development server because it was hanged, when restarted directory services database was corrupted, so fixed it, then figured out that IIS Manager's metadata.xml is messed up, so ...
0
votes
0answers
88 views

Email alerts and Server Side Tracing

This question is in regards to SQL 2005 and email alerts on long running queries. Does this sound like the best approach (with the least impact to the server) to receiving alerts to long running ...
-1
votes
1answer
696 views

Which TLS protocol and ciphers are supported by SQL Server 2005?

What is the latest TLS protocol (TLS 1.0 or TLS 1.1) to be used in SQL Server 2005? Also what ciphers are supported?
-1
votes
1answer
714 views

How to drop partitioned index in SQL Server 2005

I am unable to drop partitioned index due to partition scheme and partition function existence. Table has a Primary Key, a Clustered Index and non clustered indexes. I am running the following query:...
-1
votes
1answer
977 views

Unable to start SQL Server Agent

We are unable to start SQL server Agent and it fails with below error: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)'...
-1
votes
1answer
1k views

FETCH API_CURSOR causing open transaction in tempDB

A select statement run from Oracle 11gR1 to SQL Server 2005 using Gateway leaves an open transaction in tempdb. The user is a datareader in Database XYZ. Not sure why the open tran is in tempDB when ...
-2
votes
1answer
119 views

Get records using multiple tables

DECLARE @EmpTable AS TABLE (EmpId Int, EmpName Nvarchar(255)) INSERT INTO @EmpTable (EmpId, EmpName) VALUES (001, 'Paul') INSERT INTO @EmpTable (EmpId, EmpName) VALUES (002, 'Juan') INSERT INTO @...
-2
votes
3answers
274 views

How to calculate sum of employees late mins and Insert into another table using stored procedure

Employees daily late minutes stored in one table(Attndate) and I want to calculate sum of Individual employees late mins then insert into another table(LateMuster) using sql server stored procedure ...