Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008-r2]

SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

SQL Server 2008 R2 was released to manufacturing on April 21, 2010. SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies.

SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.

The first SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

390 questions
0
votes
2 answers

Is there any way to view history of time-zone settings in Windows Server 2008?

One of our servers has been set with an incorrect time zone for months and it has affected some of our data in SQL Server. Is there any way to see when time zone settings were made on the server?
8kb
  • 183
  • 2
  • 7
0
votes
3 answers

How to get the most out of sharepoint 2010 with sql express database size limit?

We have had a consultant set up a sharepoint 2010 server for us to use for document management. I believe it is just on the basic (free) sharepoint that comes with windows server. From what I understand this uses sql server express 2008r2 which has…
Adam Butler
  • 379
  • 3
  • 10
0
votes
1 answer

I can connect to a server via named pipes with sqlcmd but a vendor tool is getting Named Pipes Provider, error: 40

I have a windows service running on my workstation that is part of a vendor supplied tool that connects to a database. It will not startup the error I get 4 errors in the event log with the following inner exception: Inner…
Justin Dearing
  • 1,037
  • 12
  • 33
0
votes
1 answer

SSRS Data Driven Subscription empty destination folder

I have a SSRS Data Driven Subscription, the reports are save to a folder, I use the Overwrite Write Mode, however there are old reports that aren't generated anymore that lingers on the folder, I would like to clear the destination folder before…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

Question on SQL Server 2008 R2 Web with 1 processor MOLP

My client are considering getting the above mentioned SQL server license but I have no idea of what MOLP is actually. Before I say "OK, go ahead" to them, I want to know something: Is the SQL Server Management same as Standard edition? Does it…
foo0110
  • 35
  • 1
  • 6
0
votes
1 answer

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the databases from the old to the new and highlight any…
Symon
  • 11
  • 1
0
votes
1 answer

SQL Server 2008 R2 Transactions Files

Trying to restore a lost Server 2008 database. Had a backup from 2 weeks ago and were able to get the transaction log files. So I restored the DB in norecovery mode and started restoring the transactions log files since the full backup time. There…
Garfield81
  • 205
  • 4
  • 9
0
votes
3 answers

Does 250 MB SQL Server 2008 R2 space enough?

I'm about ordering a Starter Plan for my website hosting. my website is like a registration system for a small school, and it works only at the start of each term, so I'm wondering if 250 MB is enough or do I need more space? I'm happy to answer any…
Evanescence
  • 103
  • 1
0
votes
2 answers

Can connect to SQL Server remotely by port number but not by instance name

I have SQL Server 2008 R2 Datacenter running on Windows Server 2008. I am unable to connect to a named instance \SQL2008R2 using its instace name over the internet from my development machine (e.g. mydbserver.com\SQL2008R2 from SSMS). The instance…
stephen
  • 111
  • 2
0
votes
1 answer

SQL 2008 R2 Bi directional replication

I'm looking for the right replication for my case: I can't use P2P replication because one of my SQL's is Standard. I have 2 SQL 2008 R2 and want to create a bi-directional replication. What are my options? Is a "always on" Merge replication…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

MS-SQL Server 2008 size limitation on data

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data). I need to store data that occusionally could surpass this limit. Is there a way to do this? The data are character strings. …
user76678
  • 349
  • 3
  • 5
  • 16
0
votes
1 answer

SQL Transaction Replication prevents procedure with distinct on varchar(max)

When I'm adding one procedure article to the Publication the I get this error: The text data type cannot be selected as DISTINCT because it is not comparable the proc is a simple select distinct field1, field2, fieldn from tablex where id =…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
2 answers

SQL Server 2008 update License

How can I change my SQL Server 2008 license? I have the Enterprise Edition installed with a 90-day key and it will expire on 7 days. Two months ago, I purchased the final one but I don't know how to install/change to the new one. Is there a legal…
Leo
0
votes
2 answers

SQL Server 2008 login failed

I have a virtual machine (vmware) with Windows Server 2008 R2 x64 and SQL Server 2008 R2 installed. I see 2 SQL Server services on this vm : sqlexpress, mssqlserver. Both of them are use the default Network Service account to login. And both of them…
yaron
  • 3
  • 1
0
votes
1 answer

Sql server automatically change password

I have sql server 2008 R2. Everytime I create new sql server authorization login, whatever password I write it was changed to unknown me 15 characters password. Same is for sa. So I can't lofin with sql server authorization.I login with windows…
Aram Gevorgyan
  • 119
  • 1
  • 3
1 2 3
…
25 26