Questions tagged [sql-server-2005]
SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.
1,328
questions
0
votes
0
answers
16
views
Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation
I want to upgrade existing SQL Server 2005 Express (SP3) with Advanced Services (x86) ESN (Spanish) to SQL Server 2014 Express Advanced Services.
Before i upgrade I need to patch SQL Server 2005 with ...
0
votes
1
answer
85
views
Issues with SQL Server DB Migration
I have two instances of Microsoft SQL Server. One is running MSSQL 2005 and the other is running MSSQL 2019.
We recently migrated our DB engine from 2005 to 2019. We have a webserver that runs off IIS ...
- 3
0
votes
1
answer
150
views
SQL Server 2005 error after update to windows 10 [closed]
I have a SQL Server 2005 database that I can see in SQL Server Management Studio Express. There is a front end application, but since the upgrade to Windows 10, I cannot access the database with it. ...
- 103
0
votes
1
answer
255
views
Anything but small ODBC queries failing over long distance VPN after SQL Server Swap
I recently swapped database servers (restored databases from old to new and then swapped IPs)...
Old: Sql Server 2005, Windows Server 2003
New: Sql Server 2008, Windows Server 2012
All processes ...
- 629
0
votes
3
answers
304
views
Move .bak database file from backup location to another server
I have been tasked with moving a .bak file from a live DB, from its backup location to another server where it gets re-imported into a test environment. If I copy and paste the file, it copies fine. ...
0
votes
0
answers
120
views
SQL2005 Index exists in sys.indexes but not on table
I have a routine that runs through all the non-clustered indexes in a given database on SQL2005 (SP3), and reorganizes and rebuilds them (if fragmentation > 20%). This process is erroring out on ...
- 53
2
votes
1
answer
454
views
How to PIVOT data from MSSQL query and Fetch to PHP view
I have a MSSQL 2005 Database with query content like this :
nopas
code
name
order
00115301
D031
ADAM
1
00130015
D031
ADAM
2
00149998
D026
JAMES
1
00149970
D028
FIKI
1
00142641
D028
FIKI
2
...
- 21
0
votes
2
answers
5k
views
Materialized view in SQL Server
Have a bit of glitches from the time I was using SQL Server back in 2006 and the many other databases I played with (and which I have not touched since then).
I need to create a materialized view to ...
- 225
0
votes
1
answer
115
views
How to make date intervals from a list of date
How to make date intervals from a list of date (Group by columns A and C, the date range consists of a continuous date sequence):
1
vote
1
answer
88
views
Update statistics
For the data retention purpose I am deleting records from some 60 tables. Some of the tables have less number of records while some have more. I don't want to update the stats for all the tables. Is ...
1
vote
1
answer
77
views
script insert SQL Server 2005 from SQL Server 2014 Express
I have a database in SQL Server 2014 Express, and I want to import it to SQL Server 2005.
I have generated the scripts to generate the database and to insert the data. All the script generated to be ...
- 23
1
vote
0
answers
2k
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, ...
- 41
1
vote
1
answer
2k
views
Join a 'default' value only when there is no fully matching record
I need to be able to join to a 'default' row in a table (righttable) only when there is no matching record for both fields in lefttable. Below is the raw contents of the tables
#lefttable
----------...
- 629
1
vote
1
answer
22
views
In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?
We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
1
vote
2
answers
232
views
Error while running sp_blitz in 2008 SQL Server and lower versions
I have created an SSIS package to run sp_blitz in my production servers. The stored procedure runs fine for servers having a version higher than 2012 but fails for 2008 and 2005.
Please find the ...
- 868
-3
votes
2
answers
30
views
Select all records from 2 separate tables [closed]
I have 2 separate tables with no links between them. A customer table and a product table.
For each customer I wish to create a new row for each product in the product table
I want the results to ...
- 1
1
vote
0
answers
310
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 ...
- 11
0
votes
1
answer
296
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!
- 15
1
vote
1
answer
153
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 ...
- 203
1
vote
0
answers
123
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, ...
- 171
2
votes
1
answer
4k
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?
- 31
0
votes
2
answers
82
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 ...
- 101
1
vote
0
answers
47
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 ...
- 11
1
vote
1
answer
45
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 ...
- 11
0
votes
0
answers
41
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 ...
- 101
1
vote
1
answer
5k
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 ...
- 13
0
votes
1
answer
216
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 ...
- 121
1
vote
1
answer
163
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:
...
- 189
4
votes
2
answers
6k
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 ...
- 41
-2
votes
1
answer
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
2
answers
3k
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 ...
- 629
0
votes
1
answer
35
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 ...
- 5
0
votes
2
answers
2k
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
3
answers
1k
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 ...
- 41
4
votes
1
answer
517
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....
- 165
3
votes
2
answers
930
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 ...
- 305
0
votes
1
answer
351
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
1
answer
664
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 ...
- 31
-2
votes
1
answer
3k
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.99 ...
- 1
1
vote
2
answers
2k
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 ...
- 13
0
votes
1
answer
640
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 ...
- 101
1
vote
1
answer
131
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 + ',' , '') +
...
- 13
2
votes
1
answer
81
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 ...
- 21
2
votes
2
answers
2k
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 / ...
- 123
3
votes
1
answer
7k
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 ...
- 23.2k
0
votes
1
answer
369
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 ...
- 103
0
votes
1
answer
57
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 ...
- 2,562
1
vote
2
answers
971
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 ...
- 21
1
vote
1
answer
1k
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 ...
- 19
-2
votes
3
answers
860
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
...
- 189