| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 19:59:32 GMT
content-type: text/html; charset=utf-8
cf-ray: 963dc241c9afc7d4-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=9207211f-c698-4b9b-b116-586fbb7024af; expires=Thu, 23 Jul 2026 19:59:32 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: b23fc80b-3ac0-43cd-8cdd-f608750a601a
x-worker-origin-response-time: 578000000
x-dns-prefetch-control: off
set-cookie: prov=9207211f-c698-4b9b-b116-586fbb7024af; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=52b2tg3MEbNcf9o0k5QgcNe4eYppTqhqlKvd6ZkHFy4-1753300772-1.0.1.1-93lvknJEJehECbKEsx9ZN3deqygjQhSyGNUnjbuYNTDZqzdzjMGI2d6t0QNyDKs.QZxGixMNfse1IMoHoyh3jlS13iJCsU3Y8vgR2PgufSg; path=/; expires=Wed, 23-Jul-25 20:29:32 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=_AEp25VgAupzS0DEc4FQbIXn1OYcnVERdh6phIXYcRk-1753300772726-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
272
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
- Differential amplifier layout: closer to MCU or Load?
- Why is my gooseberry jam so stiff?
- Praesul meorum tattoo
- Define command valid only for a specific environment in expl3
- How to Select and Isolate Only the Fillet Parts of a Curve in Geometry Nodes?
- Story about a room on Mars that contains God
- How to show the Desktop and not the Activities Overview upon logging into Ubuntu 24.04?
- rEAAlly good for you
- A word that describes some people
- How much time should I take for "self transfer" without checked-in baggage?
- Was the double prehung exterior door on my shed installed backwards?
- Must hospitals care for unidentifiable individuals indefinitely?
- Console-based Casino Game in C++
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- A soviet sci-fi novel (novelette?) with frogs?
- Australian TV show about two dimensions separated by a deteriorating purple energy wall
- Sum of ranks of blocks
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- Expected Sum of Remaining Dice After Removing Complete Sets
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Why does my door knob bolt catch in the retracted position?
- Does Philosophy Need Quotes?
- What fiction genres do literary agents recognize?