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 votes
1 answer
74 views

Is it possible to create fast (ram only) temporary table for inter software communication purposes in MS SQL Server?

I was wondering that is it possible to create a table that is really fast and temporary (basically one that resides in ram) in MS SQL Server 2005 or later for inter software communication purposes? Do ...
The amateur programmer's user avatar
1 vote
2 answers
131 views

Understanding table locking in MS SQL TSQL Transactions

I wanted to make the old following query safe from data races when running them in parallel. The query checks if a row exists in in a table using specific criteria and if such row does not exist, it ...
The amateur programmer's user avatar
3 votes
1 answer
308 views

Upgrading out of support Microsoft SQL instance multiple questions?

I just got a new job as an analyst but I’m being tasked with an administrator task and just looking for insight. We have a Windows server 2003 (32bit) that has Microsoft SQL Server 2005. I have been ...
omsaj's user avatar
  • 31
0 votes
0 answers
49 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 ...
Vimal Solanki's user avatar
0 votes
1 answer
223 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 ...
Avery1's user avatar
  • 3
0 votes
1 answer
497 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. ...
Aquamarine's user avatar
0 votes
1 answer
518 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 ...
MrVimes's user avatar
  • 629
0 votes
3 answers
902 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. ...
Daniel Wiltshire's user avatar
0 votes
0 answers
184 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 ...
Kulstad's user avatar
  • 55
2 votes
1 answer
609 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 ...
pde's user avatar
  • 21
0 votes
2 answers
8k 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 ...
Andrea Moro's user avatar
0 votes
1 answer
222 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):
Kristina Kristina's user avatar
1 vote
1 answer
104 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 ...
Thara Unnithan's user avatar
1 vote
1 answer
87 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 ...
Guillermo's user avatar
1 vote
0 answers
3k 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, ...
jasoncrider's user avatar
1 vote
1 answer
3k 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 ----------...
MrVimes's user avatar
  • 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 ...
magneticprawn's user avatar
1 vote
2 answers
291 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 ...
l.lijith's user avatar
  • 898
-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 ...
Mike's user avatar
  • 1
1 vote
0 answers
375 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 ...
Anil Reddy's user avatar
0 votes
1 answer
2k 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!
Vishal's user avatar
  • 15
1 vote
1 answer
172 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 ...
Jack Casas's user avatar
1 vote
0 answers
138 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, ...
Kramii's user avatar
  • 171
2 votes
1 answer
6k 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?
Nilabh Verma's user avatar
0 votes
2 answers
142 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 ...
AnonWonderer's user avatar
1 vote
0 answers
52 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 ...
Kurisinkal's user avatar
1 vote
1 answer
60 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 ...
flavo's user avatar
  • 11
0 votes
0 answers
43 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 ...
Jarrod Christman's user avatar
1 vote
1 answer
6k 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 ...
Kevin H's user avatar
  • 13
0 votes
1 answer
308 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 ...
tkeen's user avatar
  • 121
1 vote
1 answer
166 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: ...
Irfan's user avatar
  • 189
4 votes
2 answers
7k 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 ...
user165269's user avatar
-2 votes
1 answer
121 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 @...
user165130's user avatar
3 votes
2 answers
4k 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 ...
MrVimes's user avatar
  • 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 ...
Guidjome's user avatar
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 ...
Henrik Erlandsson's user avatar
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 ...
Lee Hill's user avatar
4 votes
1 answer
689 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....
Jon's user avatar
  • 165
3 votes
2 answers
1k 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 ...
cloudsafe's user avatar
  • 305
0 votes
1 answer
374 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) ...
ContractDeebz's user avatar
3 votes
1 answer
700 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 ...
JFlorida's user avatar
-2 votes
1 answer
4k 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** | |[email protected]| ABC | 9.99 |05/07/19 12:30:21 | |[email protected]| efg | 12.99 ...
Rick's user avatar
  • 1
2 votes
2 answers
3k 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 ...
WickedNet's user avatar
0 votes
1 answer
821 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 ...
Rahul's user avatar
  • 101
1 vote
1 answer
132 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 + ',' , '') + ...
Giri Bkm's user avatar
2 votes
1 answer
82 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 ...
MAK's user avatar
  • 21
2 votes
2 answers
3k 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 / ...
Syntax Error's user avatar
3 votes
1 answer
9k 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 ...
McNets's user avatar
  • 23.7k
0 votes
1 answer
393 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 ...
IgorM's user avatar
  • 103
0 votes
1 answer
61 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 ...
James's user avatar
  • 2,612

1
2 3 4 5
27