Tagged Questions

This Tag is for SQL Server 2008 R2, major build version 10.50.xxxx

learn more… | top users | synonyms

2
votes
2answers
1k views

SQL Server 2008R2 SP1 instance not available for adding features

I need to add fulltext capabilities to an existing SQL Server 2008R2 instance but the one I need to upgrade is not actually available. The combobox shows only the one selected, as in the picture. It ...
8
votes
2answers
3k views

SQL Server Frozen Ghost Cleanup workaround needed

I have several tables with amount of rows between 5M and 1.5G Each table has its BLOB field, which size varies from 100 bytes to 30 MBytes and which is stored as 'large value types out of row' = ON ...
4
votes
2answers
3k views

Microsoft SQL Server 2008 Memory

I am running MSSQL 2008 Enterprise and in the configuration of the server the Max memory amount is set to 2147483647 MB. My Question is, the server has 192 GB of ram,the number in the config can't be ...
6
votes
4answers
786 views

Four db servers all identical, one is much slower than the others

The setup We have an application loading a lot of transaction data for later querying. It's sharded on 4 SQL Server 2008R2 Enterprise Edition on Windows Server 2008 64 bits. All servers are ...
1
vote
3answers
4k views

Select Which Database Mail Profile is used in SQL Server 2008 R2

I am confused about Database mail profiles in SQL Server 2008 R2. When setting up severity notifications as well as "notify operator tasks" in maintenance plans, what determines what mail profile is ...
2
votes
2answers
2k views

Reconnect mirroring server SQL2008 R2

The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected). What is the process to reconnect these servers?
1
vote
3answers
491 views

Upgrading to SQL Server 2008 R2 but downgrading the edition - will this cause problems?

I am looking at upgrading our SQL Servers from 2005 Enterprise edition to SQL Server 2008 R2 Standard edition. Obviously, the upgrade to 2008 R2 gives us more features even in Standard edition, but I ...
1
vote
1answer
66 views

How do I determine if a database restore file should be restored to the database based on backupset?

I have a production database that is fully backed up nightly and incrementally backed up hourly. On our backup machine, we have the differential backups and full backups restored ion a regular basis ...
3
votes
2answers
494 views

Performance gain by moving a large table from a database and referencing with a synonym

We have SQL Server 2008 R2 database which is currently about 80Gb. About 10Gb of this is down to one table, and I wondered if there would be a performance gain if I moved this table into it's own ...
1
vote
1answer
885 views

Partial Backup / Restore Sql Server Simple Recovery

I have a scenario where we are using SQL Server 2008 R2 with FileStream. I have partitioned the table where our files live into multiple filegroups. What I want to be able to do is backup our ...
2
votes
2answers
294 views

How do I set a geography point to be the North Pole?

I tried to execute this query on my SQL Server 2008 R2 instance: UPDATE ITEMS SET GEOG=geography::STPointFromText('POINT(0 90)', 4326); SQL Server returned the following error: ...
2
votes
2answers
365 views

X5687 vs X5690 CPUs for a SQL 2008 R2 Server

I have the choice between: 2 x X5687 (Intel® Xeon® Processor X5687 - QuadCore (12M Cache, 3.60 GHz, 6.40 GT/s Intel® QPI) or 2 x X5690 (Intel® Xeon® Processor X5690 - SixCore (12M Cache, 3.46 GHz, ...
0
votes
1answer
1k views

unique key violation occuring on a unique value combination

SQL SERVER 2008 I have a mapping table that contains a deleted date column. Since the table uses a surrogate key as its unique identifier there is a uniqueness constraint on the table. This ...
3
votes
2answers
9k views

How to install SQL Server Management Console in 2008 Express Version?

I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server. What i use: Windows Vista 2007 SP 2 What i did: a) I downloaded the install file ...
2
votes
0answers
1k views

Could not open File Control Bank (FCB) for invalid file ID X when restoring from snapshot

We have a scenario in which we, during integration tests, make a backup of an existing database and restore it under a new name. We then create a snapshot of our "new" database. After each test we ...
1
vote
2answers
174 views

In SQL Server 2008R2 Will currently deployed applications still work if I turn on Mirroring without changing connection strings?

I've googled a great deal, and can't come up with an answer to this. In SQL Server 2008R2 will currently deployed applications (Asp.Net, .Net Smart Client) still work (with a connection string ...
2
votes
1answer
269 views

Creation of spatial index locks the table for hours

I used this code to create a spatial index in SQL Server 2008 R2: BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ...
8
votes
4answers
6k views

How to revive SQL Server 2008R2 performance counters?

I'm running SQL Server 2008R2 Developer on W7 x64, as the default instance. For some reason, SQL Server's performance counters seem to have disappeared. SELECT * FROM sys.dm_os_performance_counters ...
1
vote
1answer
4k views

Changed database context to 'MyDbName'

I am catching all errors on my Sql Server, I got errors: Changed database context to 'MyDbName'. Changed language setting to us_english. I haven't found any clear explanation of problem and ...
1
vote
1answer
538 views

Can't run Alter Table command due to locks

I'm unable to drop, delete or alter a database in my Local SQL Server instance. I have run sp_Who2 and there don't appear to be any processes using the database apart from a process which gets ...
6
votes
1answer
8k views

Database 'MyDb' is being recovered. Waiting until recovery is finished

I got so error: Database 'MyDb' is being recovered. Waiting until recovery is finished. I have had a critical operation at that time. What is the cause of this situation? And how can it be ...
-3
votes
1answer
6k views

T-SQL to list all the user mappings with database roles/permissions for a User

I am looking for a t-sql script which can list the databases and and the respective roles/privileges mapped for a particular user. Using SQL Server 2008 R2. Regards Mohammed
3
votes
1answer
153 views

SQL Server - Using spatial data

I'm using SQL Server 2008 R2 for real-time location aware service. The service mostly receives location data (lat/lon) from a user and returns locations around the user. The data is being sent from ...
3
votes
1answer
709 views

SQL Server Alert Based On Severity Level Not Working

I am new to SQL Server alerts, and I am trying to setup an alert That will run a job and send a notification, based on severity level. In order to test if the alert works correctly I have downloaded ...
0
votes
2answers
1k views

DBCC CHECKDB errors migrating from SQL Server 2000 to SQL Server 2008R2

I'm getting integrity issues after I migrate a DB from SQL Server 2000 to SQL Server 2008 R2. I ran a DBCC CHECKDB on the old db, and it returned no issues. Then I FTP-ed the backup file to the new ...
4
votes
2answers
972 views

How do you use MAXDOP in a View?

I have several views that are used to export data from SQL-Server into .csv files. They are all executed via SSIS packages. Our DBA has decided to set the "Max Degree of Parallelism" to 1 and told me ...
1
vote
2answers
4k views

Connect to SQL Server Management Studio over VPN (Hamachi)

I just got my Hamachi VPN set up. For anyone familiar with Hamachi, I have it set up as a gateway so I'm part of the network when I'm away. Almost everything seems to be working perfectly. I can ...
1
vote
1answer
463 views

SQL Server Database Keeps Semi-Detaching Itself

Forgive me if I am not using all the proper terms but I have databases that will detach themselves from SQL Server. In SQL Server Management Studio the plus sign will be missing next to the database, ...
2
votes
1answer
179 views

Dropping then adding a table to a subscription with Identity option Not for Replication causes errors

We have a Transactional Replication environment that was initialised from a backup that replicates the data for several hundred tables. When a table is altered, say a new column added, I have created ...
0
votes
1answer
500 views

Make SQL Server Agent retry failed script with Try/Catch

I have a script that has a try catch in it so that if it fails I can roll back the transaction. It runs on a job scheduled through SQL Server Agent. But when it fails SQL Server Agent does not see ...
4
votes
2answers
8k views

SQL 2008 R2 creates user/schema when Windows user creates tables

We added a server login and database user that map a Windows Group to a SQL 2008 R2 instance using the following script, with the names changed for anonymity: USE master go CREATE LOGIN ...
0
votes
2answers
3k views

why user with db_owner & db_BackupOperator database role is unable to restore database?

I'm in sysadmin server role on the server . All Programmers are in dbCreator Server role , So they can create databases for themselves and they have in db_owner & db_Backupoperator database role ...
1
vote
2answers
1k views

Allow db_owner to add/view existing logins to database

On our development server (SQL 2008 R2) we want local dbo's to be able to add existing logins on the server to the database. The problem is they can't view them, they can only see themselves in the ...
6
votes
3answers
231 views

What would I look for in SQL Server to determine if a user connected with Microsoft Access?

Is there a way I can check SQL Server to see who is accessing it using Microsoft Access (as opposed to a website)? I'm using SQL Server 2008R2 with the default logging settings.
2
votes
1answer
290 views

Sql profiler replay table

I have captured a trace in profiler and stored the trace to both a table and an xml for replay. I open the xml and replay the trace on the same server/database with modified stored procedures (I want ...
4
votes
3answers
1k views

How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server ...
10
votes
5answers
3k views

SQL Server 2008 Full Text Index Never Seems to Complete

Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
2
votes
3answers
936 views

SQL Reporting Services - T2Embed.dll missing

When generating a report in SSRS, I receive the following error: There was an error generating your report. Please refer to item 673778174106859 for additional diagnostic information. There was an ...
2
votes
1answer
2k views

Meaning of SSMS database icon preceded by scroll with red x

SSMS 2008 R2, connecting to a 2008 instance shows the above glyph in SSMS Object Explorer. None of our other instances show that icon. I've moused over it in the vain hopes that I'd get a useful ...
1
vote
4answers
3k views

Attaching database to the SQL server

I have the following error The database 'Test' cannot be opened because it is version 661. This server supports versions 655 and earlier. A downgrade path is not supported. Usually this kind ...
0
votes
1answer
2k views

Upgrade older SQL 2008 to 2008 R2 on active/passive cluster

I have an active/Passive SQL Server 2008 cluster in production that I need to upgrade to SQL Server 2008 R2. I just want to make sure I understand all the steps before starting this in production. ...
6
votes
1answer
971 views

Visual Studio 2010 deployment script creates objects in wrong order - trigger after stored procedure

I created a view that selects from multiple tables in a complex query. Due to the complexity, I created insert/update/delete INSTEAD OF triggers to handle these operations on the view. I also ...
4
votes
2answers
2k views

Best Way to Grant Read All Permission in SQL Server 2008 R2?

What is the best method to grant read access to all current and future databases to a user (AD Group in this case)? Currently I have a flaky scheduled job that does this using (going to start ...
5
votes
3answers
704 views

Save Connections in SSMS?

Can I save some sort of session or profile in SSMS (2008 r2) that will open up connections to a saved list of database servers when I open SSMS? So for example I frequently will open up SSMS and ...
5
votes
2answers
7k views

Unable to delete SQL Server 2008 R2 login

I had created a SQL Server login some days back. Now I need to delete the same. So I went into SQL Server Management Studio => Security => Logins and selected the login that I want to delete. It ...
0
votes
2answers
931 views

Cannot Attach Database to SQL Server Management Studio 2008 R2

I installed SQL Server 2008 R2 just now and wanted to attach my previous databases. Attaching a Database gives an error. Attached is the image of the error. Any Suggestions and help will be ...
2
votes
2answers
422 views

Rebuilding Index - sort in temp db

What is the significance of SORT_IN_TEMPDB when working with indexes on a table of significant size (20GB plus)? Where else does sorting take place?
11
votes
2answers
400 views

To maximize DB performance, which commands should be run after loading large amounts of data into SQL Server 2008 via SSIS

I have written an SSIS package to load test data into an empty database. Some of the tables are very large (~700 million rows). Once the SSIS package has completed are there any commands I should run ...
3
votes
1answer
257 views

What load does SQL Server Reporting Services (SSRS) have on the server?

Does SQL Server Reporting Services use a lot of server resources? Is it okay to install SSRS on the same server as the SQL Server instance? What should I take into consideration? Is the SQL Server ...
10
votes
2answers
827 views

Optimization: Moving variable declarations to the top of your procedure

While working on optimizing some stored procedures, I sat down with the DBA and went through some sprocs with high blocking and/or high read/write activity. One thing the DBA mentioned was I should ...