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
99
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 ...
- 3
0
votes
1
answer
76
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
118
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
300
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
340
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
92
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
489
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
691
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
771
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
2k
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
237
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 ...
- 95
2
votes
1
answer
698
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
00127700
...
- 21
0
votes
2
answers
11k
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 ...
- 255
0
votes
1
answer
304
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
149
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 ...
