| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 14:17:52 GMT
content-type: text/html; charset=utf-8
cf-ray: 96440b22b98ba403-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=8740be8d-f6c6-48b7-8d06-37ebaaa039bf; expires=Fri, 24 Jul 2026 14:17:52 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 6fbc105d-95a4-4be4-a6a7-80768e58dd5a
x-worker-origin-response-time: 624000000
x-dns-prefetch-control: off
set-cookie: prov=8740be8d-f6c6-48b7-8d06-37ebaaa039bf; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=mwnFPa0gUaMksWIaAGRfiklRa.p4cuNgclppP.GFGNw-1753366672-1.0.1.1-mSgfFcyL.IXQJnzbpmOytxf18_Tomzhizz7oEYvtooXQ_txHRZA5KPvF9l_ywWTpn2hXpCAK9HHATZkaD9GRA8iSvJv5LB71uX.rmLIheyM; path=/; expires=Thu, 24-Jul-25 14:47:52 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=Lx3abMsanV9nUtfdDLSSwyKrqXKTf8QDDkBeQcY7RG4-1753366672449-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server-2008' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
3,879 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
76
views
Is it possible to make a batch of “Alter procedure” that are stored in a table?
Currently I have hundreds of sp that are in multiple servers, and that coexist with other sp that are in other servers with linked server.
The origin of this is that when I do a restore of databases ...
-2
votes
2
answers
121
views
Backups twice as large from one day to the next
My SQL Server 2008 R2 production database is running on a dedicated Windows server. It has been running for more than 20 years.
In the last period we have suffered some problems such as freezing ...
2
votes
2
answers
78
views
Export SQL Server Agent Jobs from a drive
I have a bit of a pickle here. Our old server with SQL Server 2008 was malware infected and been shut down. We've restored the databases from backup into a new server. However, Agent Jobs have not ...
0
votes
1
answer
105
views
What happens if the Subscriber goes down - will the t-logs keep accumulating on the publisher in Transactional Replication?
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
0
votes
1
answer
102
views
Setting up Transactional Replication - Can i safely remove transactional replication if it is causing issues on my publisher?
Please excuse me if I am not making very much sense here. I am very new to replication and have been researching for quite some time about transactional replication to implement in our scenario..
I am ...
-2
votes
1
answer
110
views
Is there any way to send SMS without OLE Automation? [closed]
We use OLE Automation methods such as SP_OAmethod, Sp_Oacreate, etc.. to send SMS to users from SQL Server. I wish to stop use OLE Automation. Is there any alternate way to send SMS?
0
votes
1
answer
1k
views
Communicating from a SQL Server 2022 to a SQL Server 2008 over linked server
I'm doing a proof of concept to assess whether we can upgrade some our servers piecemeal to SQL Server 2022.
Unfortunately we still have a SQL Server 2008 which holds an old version of Microsoft ...
0
votes
1
answer
273
views
EVENTDATA() function is giving only null values in sql server
I'm trying to capture logins time with a trigger using EVENTDATA() function.
But It's giving Null values only for all types of events. Can anyone please help me on this?
This is my Trigger
CREATE ...
0
votes
1
answer
76
views
What could create block in that case when 'blocking' procedure/spid not do any select / almost nothing?
I had situation like this today- sorry that this is screenshot but it is easier way to show what i need to understand
As on screen - many processes was blocked by SPID 91
This SPID 91 querry was as ...
0
votes
1
answer
217
views
Text Search on Multiple Columns without enabling FULL TEXT Search
I have a scenario where we need to enable a multi-keyword search within a text field. This search should involve scanning the keywords across several columns (approximately 4-6) in multiple tables (...
-3
votes
1
answer
57
views
Build logic on Reversal record flag for a particular table
I have Reversal flag (RF) values as ' ' , 'R' , 'D' which make the records distinct. I am selecting many columns from this table as it is a primary table and taking sum of few columns as well. There ...
0
votes
0
answers
118
views
two servers have linked to the same server - one connection is encrypted and second not - why?
I have some old SQL Server 2008r2 instances that do not have client certificate set up and force encryption is set to FALSE.
It is on Windows 2008 r2 and really hard to upgrade - for now it must stay ...
0
votes
1
answer
140
views
Database Dependency Chart?
I have several SQL Server (2008 forward) and Oracle (12c forward) legacy databases running on a server... I know for a fact that various stored procedures point to other databases, like select * from ...
0
votes
1
answer
76
views
Insert rows in 3 tables in a single query, SQL SERVER 2008
I need to insert data into 3 tables in a single query
Table SkillData
UserIndex
SkillPoint
TotalSkill
1
5202
99
Table Emblems
UserIndex
CountEmblem
Status
1
1265
1
Table Rewards
UserIndex
Level
Code
1
...
2
votes
2
answers
304
views
Using TRY_PARSE in SQL Server 2008
I have a script in SQL Server 2012 like this:
Declare @ParamSPKDateFrom varchar(50), @SPKDateFrom date,
Select @SPKDateFrom = TRY_PARSE(@ParamSPKDateFrom AS date USING 'id-ID')
Can I convert this ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 2356
sql-server-2008-r2 × 337
t-sql × 209
performance × 207
sql-server-2012 × 184
sql-server-2005 × 148
index × 125
replication × 108
backup × 106
stored-procedures × 96
restore × 92
database-design × 90
ssis × 87
security × 79
query-performance × 76
ssms × 71
permissions × 59
mirroring × 55
linked-server × 53
transaction-log × 50
ssrs × 44
trigger × 39
deadlock × 38
partitioning × 38
migration × 37
more related tags
Hot Network Questions
- Make a Mulenère encryption program
- Using a MCU and PCB to actuate a 24V solenoid
- Expected Value of a Dice Product Game
- Why were two 2x6 boards installed on top of a window rough sill?
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- How much of a really big a ship could a nuke take out?
- 2D Projectile Motion Diagram (Attempt)
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- How to get most recent common ancestor of a set of tips using ape package in R?
- counting number of integer solutions
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Access denied attempting to delete file on Windows Server
- Why is the Schrödinger wave equation totally different from the classical wave equation?
- Does Philosophy Need Quotes?
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Why does contact with the ground make my touch-activated LED brighter?
- When was the last time all alive humans stayed on earth?
- Can you yaw an airplane by only using differential thrust?
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- Have philosophers ever defined a notion of "luck" or "surprise" that is separate from probability?
- Guitar Intonation - Flat On Certain Frets
- How much time should I take for "self transfer" without checked-in baggage?
- Semiclassical electron dynamics and Pauli exclusion principle
- Differential amplifier layout: closer to MCU or Load?