CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 22:50:30 GMT
content-type: text/html; charset=utf-8
cf-ray: 9646fa1169596cd6-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=f760040a-3071-4bdb-9cf0-49098c83e554; expires=Fri, 24 Jul 2026 22:50:30 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: d6a5ee77-0744-4a3c-9d2d-20f168adfbbb
x-worker-origin-response-time: 484000000
x-dns-prefetch-control: off
set-cookie: prov=f760040a-3071-4bdb-9cf0-49098c83e554; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=yRECQt7jGzYPGyRxSZMBPPGH6hQ6YDX9X4hqPL591w4-1753397430-1.0.1.1-pSBhLD7WKd4wPv91ty73rptp.UbvOSVYgdcXmdtG4MDNGu_JfMaGw9PqToMelOfdnrdUujAhNtcrypxfyzPkuKVn08JvCz1Vgb6IaBmW_Ho; path=/; expires=Thu, 24-Jul-25 23:20:30 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=CTqjr0b6ck9jASkqt83hxbAoY37kDjh1mHEhcV0EFFg-1753397430475-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 ExchangeTeams
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
- Can one engage with physics (or science) without touching philosophy?
- A complex polynomial inequality
- counting number of integer solutions
- Dispute over reuse of shared research data
- Can authors be blacklisted by academic publishers for multiple rejections without any ethical misconduct?
- Why does my laptop's display turn off when I'm away from the keyboard?
- What *IS* switch bounce REALLY? According to evidence
- Which workflow is more effective: worldbuilding before plotting or the other way around?
- Is it decidable wether a CFL can be recognized by a linear CFG?
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Can you yaw an airplane by only using differential thrust?
- Why is Shunt Voltage Reference (LM4040DBZ-3) Not outputting a stable 3V supply
- How do I implement this desired Excel data transformation?
- How to model This Twisted Torus?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Is the appearance of certain kinds of clouds at altitude of > 30000 feet a recent phenomenon?
- Are birth control pills classified as a carcinogenic at the same level as asbestos and tobacco?
- What does this word "ahn-shdah-heh" mean?
- Processing All Files [0-9]*tex
- Do standing sound waves sound different?
- Is it rude to make someone an academic reference without getting their permission first?
- Do things unknown automatically become unknowable in normal epistemic modal logic
- A question about as ..... as comparison
- Do the constructible lines and circles (not merely their intersections) cover the plane?