Questions tagged [sql-server-2008]

SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

Filter by
Sorted by
Tagged with
-2 votes
1 answer
57 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?
dbajayy's user avatar
0 votes
0 answers
30 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
Abdelrahman Mamdouh 's user avatar
-1 votes
0 answers
60 views

sp_OAMethod is causing blocking with other normal Queries

I have been facing something new issue. SP_OAMethod is causing blocking with other normal queries. I have a procedure which includes select queries, and insert, update queries with begin transaction ...
dbajayy's user avatar
0 votes
1 answer
95 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 ...
Jamie's user avatar
  • 101
0 votes
1 answer
82 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 ...
dbajayy's user avatar
0 votes
1 answer
58 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 ...
Dorian's user avatar
  • 103
0 votes
1 answer
94 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 (...
AA.SC's user avatar
  • 4,053
-3 votes
1 answer
42 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 ...
Moulshree Suhas's user avatar
0 votes
0 answers
77 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 ...
Dorian's user avatar
  • 103
0 votes
1 answer
90 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 ...
Leonardo's user avatar
  • 217
0 votes
1 answer
62 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 ...
Ichigo Kurosaki's user avatar
0 votes
0 answers
49 views

DBCC error with sys.syscolpars DB upgrade failing

Consistency error in DB. 1 page from sys.syscolpars table is missing. There is no any impact but the thing is can't able to upgrade the DB from 2008 to higher version. Backup restore fails. Old good ...
KGB's user avatar
  • 51
2 votes
2 answers
201 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 ...
jubey simanjuntak's user avatar
4 votes
1 answer
749 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 ...
Ben in CA's user avatar
  • 143
0 votes
0 answers
150 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 ...
Java's user avatar
  • 223
-1 votes
1 answer
1k views

conversion failed when converting date and/or time from character string only on one of the server

I have a sql query as follows: select * from Txn_Master where Txn_Type = 'TPD' and Txn_Date = Getdate() order by Txn_ID DESC But in this sql-server query when i enter date manually like '01/06/2023'...
Prince Arya's user avatar
0 votes
2 answers
541 views

SQL Server 2000 to 2008 security logins transfer

I'm currently upgrading SQL Server from 2000 to 2008, the database was successfully transferred, the issue remains with the security logins, I have found the stored procedures that extracts the logins ...
Mohanad Belal's user avatar
-1 votes
3 answers
804 views

How to increment value in Master table column with number of records in Details table in performant and accurate way?

I am using SQL Server 2008 and above. I have following two tables: MasterTable MId DetailsCount DEFAULT 0 DetailsTable DId MId In MasterTable.DetailsCount, I store number of records in DetailsTable ...
Amit Joshi's user avatar
-1 votes
1 answer
265 views

Is there any way to find out if SQL Server is using all of CPU cores?

I'm using SQL Server Web Edition. I have SQL Server licensed to 16 cores only. I have 48 cores of CPU. Is there any way to know that SQL is reaching or utilizing its peak 16 cores limit all time? I am ...
Farhan's user avatar
  • 121
0 votes
2 answers
1k views

Is there any way to find out if SQL Server is using all of CPU cores? [duplicate]

I have SQL server licensed to 16 cores only i have 48 core CPU. Is there any way to know that SQL is reaching or utilizing its peak 16 cores limit all time? any way to find it out? as i am having ...
Farhan's user avatar
  • 121
1 vote
1 answer
240 views

SQL Server: DBCC UPDATEUSAGE does not return

I am an experienced programmer (not a DBA) and would appreciate troubleshooting guidance if no immediate answer is possible. The database itself is relatively small - a couple of million rows spread ...
AlanK's user avatar
  • 111
0 votes
0 answers
100 views

How is there an apparent duplicate Primary Key in an identity PK column?

This is a labtrac database (dental software), hosted on-prem. The Order_Stage_Procedures table has a duplicate primary key, but there are some nuances. How is this possible, and what am I missing? I ...
Arice's user avatar
  • 1
0 votes
1 answer
78 views

How to encrypt database in SQL Server 2008 Express edition

There are times when I need to move a SQL Server 2008 Express database (I'm aware it is EOL) from one machine to another. In order to do that I need to implement a mechanism using C# to encrypt the ...
samthesorcerer's user avatar
2 votes
0 answers
570 views

How do I fix the Failed to retrieve data for attaching mdf file is which not primary database file

I'm using SQL Server 2019 in Windows 10 Enterprise and Administrator user I have an MDF file and I want to attach it, and it has full access in the form of Everyone Full Control , when I try to attach ...
Mojtabah's user avatar
1 vote
0 answers
84 views

MSSQL Server Database Trigger Permissions - issue after migrating from 2008 to 2017 Server

I have some triggers set up on a database (Dynamics NAV) across various tables for Insert, Update, Delete. The triggers write to a separate database to log the DB, Table, RowId and date/time. The ...
David Mapes's user avatar
3 votes
1 answer
1k views

Always on high availability groups option is grayed out

I'm trying to enable the Always on HA groups using SQL 2016 STD, but the option is grayed out as shown below any hints on how to enable it would be appreciated. Regards, Hussein
Hussein ALSHAMIRI's user avatar
2 votes
0 answers
79 views

Query to Extract all Values below Certain Amount ignores 0-values [closed]

Trying to write a query in SqlServer Dev 2017 with SSMS with Object Explorer. I'm trying to extract all members ( PK) with totals ( Sum(ColumnValues)), below a certain amount. My code extracts all ...
MSIS's user avatar
  • 875
0 votes
0 answers
1k views

What can cause cyclical CPU spikes on a SQL Server precisely every 5min

Setup Microsoft SQL Server 2008 on Windows Server 2008 (Yes I know I need to upgrade). The server is accessed by a single Linux/Apache web server. Problem Starting about a week ago and slowly getting ...
danielson317's user avatar
0 votes
1 answer
1k views

Cannot Insert it into in my table for Special characters when ANSI_WARNINGS is Off even with nvarchar

I want to insert a data row into my table as name: DSKWOR00 , but I get this error : String or binary data would be truncated. so I turned ANSI_WARNINGS OFF and it inserted the row but the result ...
مجتبی حکیمیان's user avatar
2 votes
1 answer
1k views

Why SERIALIZABLE level does not lock the table for other session in SQL Server

I want to Prevent concurrency in my table for Delete, Insert, Update, and Select so I tried to use SERIALIZABLE for the table before transation, but that didn't lock the table for other processes! how ...
مجتبی حکیمیان's user avatar
0 votes
1 answer
489 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 ...
MrVimes's user avatar
  • 629
1 vote
2 answers
3k views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGIN'

I'm facing a very specific issue on my SQL Server instance. Recently, I had to create a Linked Server (referencing server B) in my server A, to connect to a database in B through A. Everything worked ...
Pedro Fernandes's user avatar
0 votes
0 answers
84 views

Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings

I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the ...
MrVimes's user avatar
  • 629
0 votes
1 answer
341 views

schema ownership/permissions in MS-SQL vs Oracle

Hopefully I'm using the write terms here. I'm pretty good with concepts usually but don't always know the technical terms to describe it correctly. Here goes... I'm used to working in MS SQL Server ...
jessieloo's user avatar
  • 173
0 votes
1 answer
637 views

Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?

I am trying to do some work with SQL Server 2008 (not 2008 r2, just 2008) that is installed on a Windows 7 Pro 32-bit PC. It's just Windows 7 with no Service Pack 1 applied. I have no option to update ...
FlexMcMurphy's user avatar
-5 votes
2 answers
11k views

Select rows with a duplicate ID but different value in another column

I have a table like this I would like to select the Itemid that occurs more than once with a different Rate with group by Masterid The output should be something like:
jaymin's user avatar
  • 5
2 votes
2 answers
2k views

Is there any way to get current transaction id in SQL SERVER 2008?

I want to get current transaction id to log something in another process. The code is actually run in .net, but in SQL Server it will be similar to the following pseudo code: BEGIN TRAN <GET ...
Sawyer's user avatar
  • 21
1 vote
0 answers
264 views

Create Calendar with Pivot or function in SQL SERVER

Is it possible to get a calendar with this structure from my AUT_CALENDAR table? I am applying PIVOT to obtain a calendar with the following query. DEMO SELECT IDCALENDARIO,NombreDia, [Lunes], [...
kenny's user avatar
  • 131
1 vote
0 answers
239 views

Migrate MSSQL 2008 database to MySQL 5.7 or 8.0

I am trying to migrate an old database runing in SQL Server 2008, to MySql 5.7 or 8.0 using MySql Workbench (Migration wizard). It gave me this errors Traceback (most recent call last): File "...
Valentin Gjorgoski's user avatar
0 votes
2 answers
2k views

How To trim last two digit of the varchar in SQL SSMS? [closed]

I have a column [CALMONTH] which is a varchar in SQL Table. Data is like "202003" where 2020 is the year and 03 is the respective month. I need to trim the month'03' alone to use it in the ...
sureshkumar c's user avatar
0 votes
0 answers
211 views

Microsoft SQL Server - Recovery MASTER Database

I have backuped "master" database from 1 server and need to recovery it to another server. In "master" database or in another database - not matter. Just i need access data. When i ...
user avatar
0 votes
1 answer
166 views

SQL Server Access Database in Filesystem

We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server. This server used to host an SQL ...
TheOrdinaryGeek's user avatar
-2 votes
1 answer
119 views

Sql 2008 export table csv with headers and data

I need to export a table in SQL Server 2008 with headers and data delimited with | ( pipes ), but some information inside of this table have , ( comma ) and CR or LR, it's possible to put it a "&...
Carlos's user avatar
  • 1
1 vote
2 answers
557 views

Replicate one database in one server to 2 other servers SQL2008

In product ion, we have a transactional replication between 2 servers with data from one database going from server A to Server B. We now want to add another server C for the short period of time ...
mail_sady's user avatar
4 votes
1 answer
473 views

Changing SET options within cursor - Different behavior based on compatibility level

I have found a difference in behavior on a piece of code between database compatibility levels and wondered what the cause of this is. Below is a simple example that iterates through a tally table and ...
SE1986's user avatar
  • 1,960
0 votes
1 answer
100 views

I want to pull a report from multiple sql servers, where the Database owner and job owner is not SA

I want to pull a report from multiple sql servers, where the Database owner and job owner is not SA. I need a report from a Central monitoring server, if the database owner and job owner is not SA, I ...
Bharath Kuamr reddy's user avatar
0 votes
0 answers
20 views

3 select and collate the result of the query or organize (order by) by fields of the tables

I have 3 tables and each one with different structure and number of different columns, but the first 4 columns are the same in all tables. For instance Table 1 Type id1 id2 Period FirstName LastName ...
Deivis Luis Paternina Brito's user avatar
0 votes
2 answers
2k views

Finding groups which have two values in another column

Given the following sample rows: MTYPE RNO VAL S 1 V1 S 1 V2 S 1 V3 R 1 V4 S 2 V5 S 2 V6 R 3 V7 R 3 V8 How can I list groups of RNO which has both 'R' ...
Gurpreet's user avatar
-1 votes
1 answer
364 views

Need best practices to maintain TempDB which is growing to 100GB now, is moving Tempdb to 35GB drive have any limitations? [closed]

Can moving TempDB to smaller drive cause failures? How can TempDB be configure to use 35GB drive without any issues? Please suggest if something needs to be taken care for this smooth transition of ...
Humanities World's user avatar
0 votes
1 answer
419 views

How to delete duplicate from 140 GB SQL server table where 30% records are duplicate without causing overheads like transaction logs full? [closed]

How to delete duplicate from 140 GB SQL server table where 30% records are duplicate without causing overheads like transaction logs full? table doesn't have primary key.
Humanities World's user avatar

1
2 3 4 5
78