Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
3,878
questions
0
votes
1
answer
50
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 ...
- 27
0
votes
1
answer
48
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 ...
- 27
-2
votes
1
answer
80
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?
- 1
0
votes
0
answers
47
views
log_reuse_time_desc is ACTIVE_BACKUP_OR_RESTORE
After dropping database replication and subscriber, the database's option
log_resue_wait_desc
turned from replication to ACTIVE_BACKUP_OR_RESTORE.
I should I do to return it into NOTHING value
0
votes
1
answer
450
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 ...
- 101
0
votes
1
answer
173
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 ...
- 1
0
votes
1
answer
63
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 ...
- 103
0
votes
1
answer
161
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 (...
- 4,073
-3
votes
1
answer
43
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
92
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 ...
- 103
0
votes
1
answer
112
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 ...
- 217
0
votes
1
answer
68
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
...
2
votes
2
answers
236
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 ...
4
votes
1
answer
911
views
SQL equivalent to return value from WHERE EXISTS when unable to JOIN
Trying to figure out how to write the following pseudo-code in valid SQL (MS SQL Server):
SELECT
T1.Item,
T1.Set,
Has.SN
FROM T1
WHERE EXISTS
(SELECT SN FROM T2 WHERE Condition = 'X') AS Has
...
- 143
0
votes
0
answers
183
views
Trying to increase disk with GPT for SQL Server data, do we need to configure anything to SQL Server Application
I am not a DBA, but SQL Developer.
Our company has a Azure VM that has a very active SQL Server 2008.
Currently, a disk drive (H:\ drive) that holds SQL data is getting full (up to 2 TB, possibly due ...
- 233