Questions tagged [sql-server-2008-r2]

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

Filter by
Sorted by
Tagged with
-2 votes
0 answers
38 views

SQL Server 2008 R2 stuck sometimes [closed]

I am using SQL Server 2008 R2 Enterprise Edition, but due to some reason SQL Server does not respond/connect. Checking the hosted Windows Server - all is ok. After restarting the SQL Service, it ...
user avatar
3 votes
1 answer
64 views

Users time out (or it's very slow) authenticating to SQL Server, but RDP authenticates immediately

The authentication timeouts and slowness happen for both local SQL logins and Windows authentication using AD. Rebooting "masks" the problem for a while, but after 6-8 hours, we see them ...
user avatar
  • 455
1 vote
1 answer
27 views

Safely delete on-disk backups and change behavior

I have inherited a server running SQL Server 2008 R2 and it keeps running out of space. After doing some digging with WinDirStat, I found that it is almost entirely due to the SQL Server backups ...
user avatar
  • 11
0 votes
2 answers
46 views

Recovering space on a restored and pruned SQL Server database for testing purposes

I have a requirement to regularly take a backup of a set of tenant databases (all same schema), and restore them in our UAT environment, then clear down most of the client data, leaving only a few ...
user avatar
  • 319
1 vote
0 answers
16 views

SQL Server 2008R2 - Cannot View DB Properties in SSMS or Query Database Files

I am trying to view the properties of a database but it fails in SSMS with below error in screenshot. I searched online for solutions but none have worked. These include change db owner to sa. The ...
user avatar
  • 1,344
2 votes
0 answers
46 views

SSIS: How to export more than 4000 characters to Excel

I have the following basic setup in SQL 2008 R2. This does not work however as I always get the errors Error 1 Validation error. SQL to XLS: SQL to XLS: Columns "Original" and "...
user avatar
  • 194
0 votes
1 answer
44 views

How do I fix this SQL server query 2008r2

I'm trying to update type from table Titem column type and set it to new id, while having it to check if user id owns those 2 items(oldid which we are updating, 2nd id which is just for checking if ...
user avatar
-5 votes
1 answer
135 views

Select INTs from start of string separated by a character (pipe). Update other columns using these INTs

In the above screen shot, the Description column has many special characters. We want before | number update in T1 column and | after number in T2 column. Please suggest the proper syntax. If there ...
user avatar
7 votes
3 answers
134 views

ALTER TABLE ADD COLUMN in batches but with NEWSEQUENTIALID()

I have a large table, but not huge (less than 2 million rows on aging hardware), and when adding a non-nullable column to an existing table, I usually follow the structure set out here to avoid ...
user avatar
  • 319
0 votes
1 answer
42 views

Missing rows in table after restore database from MDF and LDF with SQL Server 2008

I have got two files, test.mdf and test.ldf, with sizes around 200 Mb and 200 MB. I restore the database using "Attach Databases" options, all is ok, but I found that there are a lot of ...
user avatar
0 votes
1 answer
46 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 ...
user avatar
0 votes
0 answers
88 views

If I rename a table with dependencies, and then create an synonym of the old name pointing to the new table name will the dependencies still work?

In an attempt to remove some downtime to my users, I want to redirect them to a back up table while I'm repopulating the production table. The tables in question have been in place for years so my ...
user avatar
  • 9
-1 votes
2 answers
32 views

get sum rows based on column values

I have the data like this I want below result.
user avatar
1 vote
2 answers
89 views

Replication alternative

We are using SQL express that does not support DB replication to other servers. 1- is there any way/free tool that enable us to perform any type of replication? 2- do you have any idea to share the ...
user avatar
0 votes
0 answers
55 views

SQL 2008r2 : The database is not accessible

Is there something that I am missing? Newly created database with 2 users. Both have the same permissions. SQL01 gets error "The database DB01 is not accessible" on browsing through SSMS. ...
user avatar
2 votes
2 answers
45 views

Watch and log query from a user on SQL server?

I need to find a way to log all scripts and queries (SELECT, INSERT, UPDATE, DELETE and EXEC) from a user. Context: I want to check what kind of queries my support are doing on the database. At this ...
user avatar
0 votes
1 answer
214 views

How do I produce the relationship diagram in Microsoft Sql Server?

How do I produce the relationship diagram in Microsoft Sql Server? Here is a visual of what I am talking about here:
user avatar
  • 131
0 votes
1 answer
76 views

Log backup Job disable and enable during FULL backup -Sql Server 2008R2

I am planning to test the Sql server migration of Production databases but i am thinking to stop TLog Backup job during Backup and Restore as I don't need TLog backup and my Backup and Restore process ...
user avatar
  • 11
0 votes
1 answer
48 views

SQL server: Any user can access database instance without any grants [closed]

User created from Active directory can access all instances of databases in SQL Server without any grants. Was shocked to see this behaviour on our environment. Example. We have a database named MyDB ...
user avatar
0 votes
0 answers
194 views

SQL Server Performance of a user defined table type

I have a stored procedure that is being passed a User Defined Table Type to retrieve 1 to many records back from a table that is filtered down by a join instead of building out dynamic sql to generate ...
user avatar
  • 1,731
3 votes
2 answers
76 views

Question Regarding ISDATE Function and DATENAME Functions

We have had an issue this morning with a report failing due to the following error: "Conversion failed when converting date and/or time from character string" The issue is that in the ...
user avatar
0 votes
0 answers
39 views

Cannot modify a job in SQL 2008 R2. The Modify window simply doesn't come up

I created a maintenance plan to perform daily backups with transaction log backups to be scheduled on four hour increments, however, I did not enable the job immediately, nor did I enter add the ...
user avatar
  • 21
2 votes
2 answers
41 views

In a mirror, how can I keep the SQL Server Agent offline, but have it start automatically in the event of a failover on the Principal?

In this scenario there are three MS SQL servers. ServerA has a series of jobs that write data to databases on ServerB. I want to set up ServerC as a mirror of ServerA, with all the same jobs available....
user avatar
  • 21
0 votes
1 answer
29 views

Is possible to restore BD SQL Server without key encryption from 2008 R2?

I have a database that has an encryption. The encryption key was lost. This database is on a SQL Server 2008 R2 server, and my mandate is to migrate this database on a more recent server. Is there a ...
user avatar
2 votes
1 answer
32 views

Identifying elements in SSIS package built in MS Visual Studio 2008

I recognize that these are variables, but I am not sure how to add these elements to the package (or how they are added to begin with), what effect that have or even how to manipulate them. No right ...
user avatar
  • 75
0 votes
2 answers
599 views

What is Fastest way to shrink a datafile?

I have a 4 Tb SQL Server 2008 R2 database. I'm going to move this DB to a new server with a new release of SQL Server 2012. (the application does not support SQL Server > 2012, but that is not the ...
user avatar
5 votes
2 answers
122 views

Does SQL Server 2008 R2 always fail with a severity level 20 error with certain large text manipulation?

When we run this on our SQL Server 2008 R2 instances, it causes a severity 20 error every time. It does not have that issue on our SQL Server 2016 instances. Query: DECLARE @v varchar(MAX) = REPLICATE(...
user avatar
  • 1,771
1 vote
2 answers
67 views

SQL SERVER ERRORLOG FILE UTILIZING THE FREE SPACE

I'm stuck up in one of the issue. I'm Using SQL SERVER 2008 R2. The SQL SERVER Log file is utilizing the disk space. When ever I clear the space in the DRIVE, the SQL SERVER Error log file starts to ...
user avatar
0 votes
0 answers
216 views

SSIS - DMA doesn't support migration assessment to SSIS in local SQL Server 2019

we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (...
user avatar
2 votes
1 answer
55 views

Why do SQL Server auto-created statistics sometimes include the primary key?

I had always understood that SQL Server auto-created statistics only include one column. In other words, they are not multi-column statistics. However, today I came across some auto-created ...
user avatar
  • 133
0 votes
3 answers
299 views

Auditing of database connections in SQL Server 2008 R2

We are finally planning to close down our last SQL Server 2008 R2 server. Before we can proceed with this we need to track what users are connecting to which databases. We have tried different options ...
user avatar
  • 345
-1 votes
1 answer
179 views

Increment date by 1 day based on another column's date from previous record

I am using SQL server 2008 R2 and I don´t have LAG and LEAD functions. I have this inicial table and I need that StartDate is equal to EndDate from previous record plus 1 day. See Result Table. ...
user avatar
0 votes
1 answer
134 views

MSSQL - Insert Into adding data into the middle of the table? [duplicate]

A bit of a random one here... I've got a basic table that I'm using for temporary data inserts - and for that reason, I don't need or want a unique ID - however, I'm seeing odd behaviour! (or it feels ...
user avatar
  • 1
1 vote
1 answer
167 views

SQL Native Client Upgrade

Application server for CRM has SQL native client 2008 version installed. I have installed SQL native client 2012 side by side as need to connect to an sql availability group listener. How do I get the ...
user avatar
0 votes
1 answer
49 views

Reasons For Slowness in SQL Server 2008 R2 Express Edition [closed]

We are observing intermittent slowness in our SQL Server. We ran sp_who2, sp_who3 stored procedures for checking CPU/IO usage but did not see any spikes/abnormal values. What else could be the ...
user avatar
0 votes
1 answer
155 views

Install PFX certificate on SQL 2008 R2

We have a MS SQL 2008 R2 service running on a Windows 7 computer. I've developed a webapplication that runs on a Digital Ocean droplet. This droplet makes a connection with this computer through a ...
user avatar
2 votes
3 answers
82 views

Sort Records in Original Order After UNION ALL

My question seems to have been worded poorly the first time around, so this is my attempt to explain it more clearly + provide table structure and data below. Please consider table dt: Create Table dt ...
user avatar
  • 23
2 votes
1 answer
183 views

Job management: How to get the next running date by querying MSDB

Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job. ...
user avatar
-2 votes
1 answer
38 views

Index size is 598GB and database size is 609GB. whether the index contains data?

The SQL server database size is 609GB and one of the index (clustered)size is 598 GB and the particular table size is 604GB. whether the index contains data? why the index is this much big?
user avatar
  • 151
1 vote
1 answer
422 views

Select Query slow for Non-clustered index

I am using SQL Server 2008 R2. Select query is slow when non cluster index is used in the table compared to table without index. Query Used: select * from table order by customer_name It is too ...
user avatar
1 vote
1 answer
250 views

Will Blocking cause timeout issue

When I check in sys.sysprocesses in SQL 2008R2, a number of blocking sessions are there. Most of them are insert, update, and delete statements, with lock-related wait types. Will this cause time out ...
user avatar
  • 151
0 votes
1 answer
60 views

Another question about finding the last time a value changed

I know there is a simple answer to this question but just can't get my head round it. I have a table with datetime and int columns. | TimeStartTz | RowNumber | RateID | |--------------...
user avatar
  • 1,127
1 vote
0 answers
1k views

Ok to remove SQL Server Compact 3.5 from a SQL 2008 R2 Server?

We still have one production SQL 2008 R2 Server. Yes, there are plans to upgrade soon, just not immediately. In the meantime, our Vulnerability reports are flagging the server as vulnerable because ...
user avatar
  • 111
0 votes
0 answers
58 views

SQL Server Differential Backup Size

The setup is SQL Server 2008 R2: Full Backup - Weekly ~1.1TB Differential - Every 4 hours ~66GB Transactional - Every hour What I want to know is why is the very first differential backup about 60GB,...
user avatar
  • 113
-2 votes
1 answer
50 views

SQL Services are off but can access and query from other server on the same domain. Why? [closed]

Using configuration manager, I disabled the SQL Server Services for a SQL Server 2008 R2 instance. Yet, I can still connect to the instance from its replacement server, a SQL 2019 box, and query the ...
user avatar
1 vote
2 answers
53 views

in-place upgrade native SSRS without the SQL Server portion

We have a single server (2012R2) running SQL 2008R2 + reporting services native mode 2008R2 Can the reporting services portion be upgraded alone without the database engine? Or can the SSRS db be ...
user avatar
1 vote
0 answers
2k views

"The client and server cannot communicate, because they do not possess a common algorithm" error

The full error message is: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
user avatar
  • 397
2 votes
2 answers
538 views

Assign number incrementally, reset when value changes

declare @t table (scanCode varchar(6), dates datetime, flag varchar(1)) insert @t ( scanCode, dates, flag) select '182086','01 Jul 2020','P' union all select'182086','02 Jul 2020','P' union all ...
user avatar
  • 21
0 votes
1 answer
151 views

SQl server 2008R2 Performance issue after SP3 update

We have recently applied SP3 KB2979597 and Security Update Patch KB4057113 on Sql server 2008R2 but after that our couple stored procedures runs slow, it's taking almost 4 to 5 hours, but normally it ...
user avatar
  • 11
2 votes
1 answer
172 views

Can't understand difference in fulltext results - contains, contains with wildcard, freetext

I have a table with an fulltext index on the column named Filecontent. The table has a row where content contains "W 917". For context, the content column on this rows contains much more ...
user avatar

1
2 3 4 5
76