Questions tagged [sql-server-2005]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
80 views

Unable to Connect to SQL Server 2005 through ODBC drivers from Windows 2012 server

We are unable to connect to a specific Database server which has SQL Server 2005 installed on Windows 2003 server from any of the Windows Server 2012. It used to work till last week, the only change ...
0
votes
1answer
48 views

Obtain SQL Login account password

Is there anyway I can obtain a SQL Login account password, I did not create the logins so I would like to see what the password is for a certain SQL login. Thanks!
1
vote
1answer
55 views

32-bit Enterprise SQL 2005 on 64 bit Windows 2008 Server Standard. Memory configuration

Working on a project we need to first stabilize and then upgrade. We have a 32bit Enterprise edition SQL Server 2005 installed on a 64 bit Windows 2008 standard Server. The server has 64GB RAM ...
1
vote
0answers
24 views

Connecting to SQL2005 from Windows 2016

I am trying to connect to a SQL2005 running on a Windows 2003 Server from a C# application running on Windows 2016, and am having trouble. The connection uses OLE DB, not ODBC. When I try to connect, ...
-1
votes
1answer
260 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?
0
votes
2answers
44 views

SELECT highest quantity in related table, exclude if there is a tie

I have a SELECT statement that pulls in product information from a related table, and finds the product with the highest quantity associated to it for that transaction. This is shown below and working ...
1
vote
0answers
20 views

SQL Server 2005 Full Text Catalog files got deleted

I have SQL Server 2005 database. One day we noticed the production backup is not running, and the cause was that the full text catalog was offline. Further analysis showed that the full text catalog ...
1
vote
1answer
29 views

SQL Server 2005 Analysis Services won't start

We use SQL Server 2005 and sometimes our Analysis Services won't start. A simple reboot solves the problem, however, I'm trying to find a solution that does not rely on that. If I try to start it ...
0
votes
0answers
28 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 ...
1
vote
1answer
146 views

Create SQL job to send email in Excel format

I am not skilled in SQL and need some help. I have a SQL2005 server and I created a job to send an email with a CSV attachment. My job runs fine but I need the end result to be an Excel file in ...
0
votes
1answer
33 views

Replication stalling on one subscriber

I currently have transactional replication set up for three databases from the same Publisher to the same three Subscribers in SQL Server 2005. Publisher and Distributor are on the same server. One ...
1
vote
1answer
92 views

Could anyone please help me understand MSSQL Compatibility Level?

I have a task to upgrade a database from SQL Server 2005 to SQL Server 2012. So I took backup of the old database and simply restored it onto SQL Server 2012 (SP3). Executed query on New database: ...
3
votes
2answers
661 views

Upgrading SQL Server 2005 to 2016

I have a requirement to get rid of our old servers, however one of them includes a database server that is currently using SQL Server 2005. We have a new server running with 2016 so I wanted to know ...
-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 @...
3
votes
2answers
314 views

Trying to check if a string contains a number exclusively

I have been trying to write a function to check if a string contains a number without that number being part of a bigger number (in other words if the number being searched for is '6' and the string ...
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
373 views

UPDATE with JOIN: Incorrect syntax near the keyword 'RIGHT'

I'm using SQL Server Management Studio 2005. I want to look up a column value in another table, using a shared ID tblOrder_ordernr in both tables, but only update one table. To me, the query is ...
2
votes
3answers
233 views

SQL Server Transaction Log VLFs not being released (Status 2) on log shipped Database

Have seen a couple of posts similar to my scenario, but nothing that actually resolves my issue. Scenario: Routine index rebuild happens, once a week, 2 AM Saturday morning. Log file grows about 15x ...
3
votes
1answer
69 views

Is there any way to add a witness without restarting the witness afterwards?

I want to add a third instance of SQL server to my mirroring pairs to act as a Witness. When I set the witness, the mirror remains disconnected from the witness and the mirror's log accumulates errors....
3
votes
2answers
272 views

Can a diagram be created from deadlock xml extracted from the ring buffer in SQL Server 2008?

In later versions of SQL_Server, we view the event file in the object browser to look at deadlock diagrams. This particular client has SQL 2008 (compatibility 2005) and the only copy of deadlocks have ...
0
votes
1answer
58 views

Inherited Permissions: SQL Server 2005 vs 2016

Question: I have a SQL Server 2005 server and a SQL Server 2016 server. On each server is a database (A) with a stored procedure that selects data from a view in Database (A) The view in database (A) ...
3
votes
1answer
340 views

SQL Server 2016 Restore Failure on DB Using Clustered Shared Volumes (Error 7627)

We are new to using clustered shared volumes and SQL Server 2016 Enterprise Edition. When restoring SQL Server 2005 databases with full text search catalogs onto our new 2016 instance, we get the ...
-2
votes
1answer
242 views

I want to prioritize which record to select from multiple records which have same ranking

The table structure to solve | **Email** | **Product name** | **price** | **Creatdt** | |R@gmail.com| ABC | 9.99 |05/07/19 12:30:21 | |R@gmail.com| efg | 12....
1
vote
2answers
999 views

UPDATE in combination with nested SELECT queries and LEFT OUTER JOIN

I have a problem with an UPDATE statement that contains a nested SELECT statement in combination with LEFT OUTER JOIN statements. Situation: In our database there is a new column added to all people ...
0
votes
1answer
80 views

Check connection details to SQL Server 2000/2005

I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014. I don't have direct access to the databases and I want to know all applications connecting to it and connection ...
1
vote
1answer
120 views

How to know if that execution plan is suitable for this query (Sql server 2005)?

This is my query. Declare @Pivv NVarchar(Max), @Query NVarchar(Max), @Pivv1 NVarchar(Max), @Columns NVarchar(Max) Select @Pivv = Coalesce(@Pivv + ',' , '') + ...
2
votes
1answer
62 views

SQL DBA data type is changed after upgrade

We have recently upgraded our SQL Server Database from SQL 2005 to SQL 2014. We are experiencing slowness in both SSMS and application as well while executing a SP in SQL 2014. After checking through ...
2
votes
2answers
558 views

Error -2146825284 / 0x800A0BBC when trying to write file

I have a query which uses sp_OAMethod @init, 'SaveToFile', NULL, @fPath, 2 to write from an image column to disk. It is failing with an error which I think relates to file permissions. -2146825284 / ...
3
votes
1answer
685 views

SQL Server service permissions on network share depending on IntegratedSecurity=true/false

Our company receives a daily file from one of our customers. It is an EDIFACT file translated to XML and downloaded from an SFTP server. We have developed one (c# console) application that: Download ...
0
votes
1answer
121 views

Fetch data from SQL Server table of the ERP DB

I have pretty old ERP system running on SQL Server 2005 (about 20GB database. Largest able has 2 million rows). Unfortunately, the ERP can't run on SQL Server 2008 or newer. I have a huge amount of ...
0
votes
1answer
51 views

Disaster recovery/Server Migration for databases that are permanently in Standby

I've got an old 2005 server where 8/12 of the databases are in Standby/Read-Only. This server has 81 jobs, many of them with unique id's for names. One of these jobs is called Replicate, and it calls ...
0
votes
2answers
496 views

How to Backup Remote Database to FTP server

I can connect to a remote SQL Server via Management Studio. But, when I create backups, they get created on the server's disk. How can I transfer them to an FTP server? I only have a login to the MS ...
1
vote
1answer
637 views

how to find number of empty tables in any schema?

I want to query how to find all the empty tables in my schema HR i already tried with select * from dba_tables where owner='HR' and num-rows is null; but i dont know if this is the correct logic or ...
-2
votes
3answers
155 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 ...
6
votes
2answers
653 views

Why is datalength of decimal 5 regardless of precision?

I'm trying to better understand numeric types in SQL and have read that the decimal type will always require 17 bytes. However, the MS Docs list a table indicating the amount of space used depends on ...
5
votes
2answers
2k views

Can send test database mail but job emails failing

I stopped receiving sql agent job failure notifications in the recent past. Upon investigation the error reported is: The mail could not be sent to the recipients because of the mail server failure. ...
2
votes
1answer
2k views

How long will a truncate table take on 252M Rows (170GB data)?

I understand that there are many variables in this and am not looking for an exact number of min:sec :) I've read many resources that state that a TRUNCATE uses far less resources than a DELETE and ...
3
votes
1answer
518 views

Will DB backup time and size be decreased after truncate large tables

Two tables in our SQL Server DB equate to 500M rows and 350GB of data. Disk space is an issue where we keep backups and the time to execute backups is as well. We plan to truncate these 2 tables. I ...
1
vote
0answers
48 views

Deadlock During Insert into One Table

I have a multi-threaded application that does an insert into a table using a stored procedure, and it is causing deadlocks in the database. I ran a trace on my database, and the deadlock processes are ...
-2
votes
1answer
83 views

SQL Server detected a logical consistency-based I/O error [closed]

Please provide the solution for the error message below Msg 824, Level 16, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:87552775; ...
0
votes
1answer
45 views

Advice on deleting all rows and reclaiming space of very large table

I'm not a dba...let's start with that :) I'm an app developer. But our database has an archive table which is 252 million rows and 170GB, and I've been tasked to fix it (actually, there are multiple ...
0
votes
1answer
4k views

What causes “lock request time out period exceeded” when droping a column?

I created some columns in our production database but now I need to drop one. However this seems impossible and I do not know why. I dropped the column in our development database just fine. I ...
2
votes
0answers
244 views

Unexplainable behavior of SQL Server under Windows Authentication

The versions affected are SQL Server 2005, 2008, 2008 R2. If we grant CONNECT SQL to public server role, any AD account can log in to server. So we'll have all the AD members on the server without ...
2
votes
1answer
74 views

Page Splits on an empty table

I have a monitoring tool that alerted me to high page splits, 50% of new allocations. After some Google Fu, I found the following query to look and see: SELECT IOS.index_id, O.NAME ...
-1
votes
1answer
469 views

How to raise an alert when a table reaches a certain size? [closed]

I would like to set up an alert when the disk space used by a table reaches a certain size. I am aware we can set up an alert for file group\log file\database reaching a certain threshold. It would ...
0
votes
2answers
65 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) ...
3
votes
3answers
2k views

How can I get satisfactory random numbers from the RAND function (or elsewhere)?

I'm creating a pseudo-random data set for application users to train on. I'm surprised that if I seed the RAND() function with 1, 2, 3, etc., I get very nearly the same result from the seeded ...
2
votes
1answer
2k views

Sending email from SQL Server without using DBMail [duplicate]

Is there a way to send email from SQL server stored procedures without using DBMail? DBMail is hard coded by default to use base64 encoding for email messages. As far as I can tell there's no way to ...
4
votes
1answer
3k views

Querying XML nested nodes

I need to integrate a daily XML file into my system. The XML file has an schema similar to this: create table txml(id int identity, data xml); insert into txml (data) values (' <order> <...
0
votes
1answer
44 views

SQL Server restore database files [closed]

Say I'm using SQL Server and have set sa password in security. Can the database files be copied to another computer (running same SQL Server setup but with different sa password security) and restored ...