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
1
vote
2answers
65 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 ...
-1
votes
0answers
29 views

Who knows how to force delete table in SQL Server 2008 R2? [closed]

As outage, there is a damage table in my SQL Server 2008 R2, and I can not drop it. I try to login via dac to want to delete the row of table of sys.sysschobjs, but it said I can not delete it. How ...
0
votes
0answers
46 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. ...
2
votes
2answers
37 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 ...
0
votes
1answer
56 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:
0
votes
1answer
46 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 ...
0
votes
1answer
45 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 ...
0
votes
0answers
132 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 ...
3
votes
2answers
70 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 ...
0
votes
0answers
38 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 ...
2
votes
2answers
25 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....
0
votes
1answer
24 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 ...
2
votes
1answer
25 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 ...
0
votes
2answers
220 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 ...
0
votes
1answer
26 views

get parenrs and childs based on id

my Data TradeID Commodity GeneratedFrom 32839 CPO NULL 32840 Hard Stearin NULL 32841 PFAD 32839 32842 RBDPO 32839 32843 CPO ...
5
votes
2answers
112 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(...
0
votes
0answers
65 views

TDE Encryption Certificate Verification?

I'm attempting to audit/very TDE encryption of a database; significantly I've inherited a bunch of certificates and passwords and I'm attempting to update documentation to properly indicate the ...
1
vote
2answers
54 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 ...
0
votes
0answers
144 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 (...
0
votes
0answers
18 views

Enable query logging for single user on SQL server 2008 and SQL server 2016

I need to monitor queries executed by a specific set of users on a database. I need to check them on a weekly base. Is that possible on SQL server 2008r2? And 2016?
2
votes
1answer
45 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 ...
0
votes
3answers
186 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 ...
-1
votes
1answer
48 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. ...
0
votes
1answer
97 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 ...
1
vote
1answer
112 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 ...
0
votes
1answer
46 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 ...
0
votes
0answers
36 views

sql publication / subscription 2008r2=>2012 Could not locate text information

I have replitation setup from sql 2008r2 publication to 2012 subscriber it was working fine and after 4h i faced error: Error messages: The process could not execute 'sp_replcmds' on 'PB01\PROD'. (...
0
votes
1answer
96 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 ...
0
votes
0answers
20 views

Path of ssis package

Good morning all I must migrate this ssis package from SQL 2008 to SQL 2019 I'm trying to see how I can find the physical path of these packages thanks
2
votes
3answers
75 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 ...
2
votes
1answer
106 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. ...
-2
votes
1answer
35 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?
1
vote
1answer
284 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 ...
1
vote
1answer
226 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 ...
0
votes
1answer
35 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 | |--------------...
1
vote
0answers
944 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 ...
0
votes
0answers
53 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,...
-2
votes
1answer
47 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 ...
1
vote
2answers
31 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 ...
1
vote
0answers
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: ...
2
votes
2answers
265 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 ...
0
votes
1answer
131 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 ...
2
votes
1answer
154 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 ...
3
votes
1answer
358 views

How can INDEX rebuilds be going parallel when MAXDOP is set to 1

I am periodically running into a THREADPOOL wait issue with a SharePoint data store of hundreds of databases using a SQL Server 2008R2 Standard Edition instance (recently migrated to an Azure VM). It ...
0
votes
1answer
87 views

How to connect to Microsoft Dynamics Rms 2.0 Running sql2008r2?

Would anyone know anything about Microsoft Dynamics Rms 2.0 (2012)? We are having trouble connecting our sql server to the client side cashier (windows 10 pro) this software sunset in 2016 I believe ...
0
votes
3answers
1k views

How to remove database from explorer after deleting .MDF and .ldf files

I wanted to know if I can delete or remove the database shown in the object explorer after someone has manually deleted the MDF and ldf files from the database folders.
1
vote
2answers
173 views

How to remove dbcreator server role?

I was able to add the dbcreator server role to a user of a SQL Server DB, thanks to this nice question/answer: create-database-permission How can I REMOVE that permission? Is there a stored procedure ...
0
votes
1answer
25 views

Change the sql table output - Rows to Columns [duplicate]

I have a result from recursive query that gives me Table1 (SQL Server 2008 R2). I need to convert the Table1 to Table2 and I don't know the best and simplest approach to do it. Any suggestions? Table1 ...
0
votes
1answer
40 views

Rebuild or Reorganize index

I am using SQL server 2008 R2. The DB is normally used from 9 am to 9 pm and the maximum db size is 10 GB. Whether rebuild index offline causes any problem, if it is done during midnight (when no one ...
1
vote
0answers
111 views

Missing tables in AdevntureWorksDB

Recently I found some old questions that involve querying data from AdevntureWorksDB across several operations(DML,DDL). One such question was : Create and execute a query that computes the total ...

1
2 3 4 5
76