Questions tagged [sql-server-2005]
SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.
1,327
questions
0
votes
1
answer
51
views
SQL SELECT: restrict rows from Table1 to those having only specific rows in Table2
(A simplified example).
I have Table1 with items:
+----+-------+
| id | name |
+----+-------+
| 1 | car |
| 2 | apple |
| 3 | grass |
| 4 | alien |
+----+-------+
and Table2 with colors that ...
- 1
0
votes
1
answer
55
views
Locked out of SQL Server 2005 .... User number set to "1" in Enterprise manager? [duplicate]
Whilst trying to restore a "master" backup file (on my Windows Server 2003 / SQL Server 2005) machine I've dropped a clanger and re set the number of users from "0" (unlimited) to &...
Richard Welch
-1
votes
1
answer
80
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 ...
1
vote
2
answers
206
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 ...
3
votes
1
answer
316
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 ...
- 31
0
votes
0
answers
58
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
312
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
593
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
615
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
1k
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
203
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 ...
- 55
2
votes
1
answer
625
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
9k
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 ...
- 245
0
votes
1
answer
247
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
113
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
88
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
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, ...
- 41
1
vote
1
answer
4k
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
24
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
311
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 ...
- 908
-3
votes
2
answers
33
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
412
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
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!
- 15
1
vote
1
answer
188
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
143
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
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?
- 31
0
votes
2
answers
167
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
54
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
66
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
45
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
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 ...
- 13
0
votes
1
answer
347
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
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:
...
- 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 ...
- 41
-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 @...
3
votes
2
answers
5k
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
36
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
749
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
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 ...
- 305
0
votes
1
answer
384
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
702
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
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 ...
- 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 ...
- 23
0
votes
1
answer
865
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
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 + ',' , '') +
...
- 13
2
votes
1
answer
87
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
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 / ...
- 123
3
votes
1
answer
10k
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.8k