This Tag is for SQL Server 2008 R2, major build version 10.50.xxxx
2
votes
4answers
69 views
What is the best permissions to set for only creating and managing own databases?
I want to create a login for a new user who could only create and manage their own databases. Other databases on the server should be read-only to that user. What would be a good set of ...
1
vote
3answers
108 views
SQL Server BPA 2008R2
I have been using SQL server BPA for getting good information from Microsoft. I was using its 2005 version in which i used to export the results in csv format but recently I got two new servers which ...
0
votes
3answers
122 views
Merge Replication identity field issues
One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
0
votes
2answers
40 views
Dropping and recreating indexes
I most often come in a situation where the users move there database from one server to another and immediately after they move they face performance problems(slowness).
I somehow manage to rebuild ...
0
votes
2answers
110 views
List all permissions for a given role?
I've searched around all over and haven't found a conclusive answer to this question.
I need a script that can give ALL permissions for an associated role.
Any thoughts, or is it even possible?
...
5
votes
1answer
66 views
SA permissions issues with many nested objects
I have a broker application that's relatively complicated.
Today, after I made some changes, I started getting the error:
The server principal 'sa' is not able to access the database 'XYZ' under ...
5
votes
1answer
134 views
Reindexing plan
I have a reindexing plan failing with error message:
Refresh failed for PhysicalPartition '1'
(Details: SQL Server Enterprise edition running in cluster)
Searching through BOl and other online ...
4
votes
1answer
114 views
MI Data Warehouse Advice
I have recently started a new job and part of my remit is to try to rescue the Management Information (MI) Data Warehouse. I use the term Data Warehouse very loosely here!
The server setup is:
...
3
votes
1answer
26 views
Fulltext stoplist replication
In MS SQL Server 2008 R2 there is replication of table with fulltext index on it.
But stoplist that is associated with replicated fulltext index doesn't replicate.
Is there any possibility to ...
3
votes
1answer
170 views
Applying user-defined fields to arbitrary entities
Currently we have an old (rather crude) system that has user-defined fields, which are mapped against rows in arbitrary tables. This was an after-the-fact modification based on a customer request, and ...
2
votes
1answer
47 views
Is this a good strategy for importing a large amount of data and decomposing as an ETL?
I have a set of five tables (a highly decomposed schema for an ETL if I understand the nomenclature) that I'm going to load via bulk import, then run some inserts from those five tables into a SLEW of ...
2
votes
1answer
599 views
How to Convert Horizontal to Vertical Array?
I need to create a query (suitable for Standard Edition) that has data from multiple columns (Columns 1-6 with corresponding Date Started and Date Completed data) displayed vertically, but also has ...
1
vote
1answer
122 views
Upgrade SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard
I understand that this is not a supported path, but does anyone have any insight about how to accomplish this? I can't seem to find any documents on the subject. I need my QA (2005) to match my ...
1
vote
1answer
60 views
dead lock when updating
Update Operation.TrTable
Set RecordId = RecordTABLE.newRecordId
From Operation.TrTable tr
Inner Join (
SELECT r.Id AS newRecordId, r.KeyM AS MappingKey
From ...
1
vote
1answer
314 views
SQL Server Login failed for user Error: 18456, Severity: 14, State: 11
I have an AD group XYZ that I have added to SQL Server security with data_reader permissions.
The XYZ group has around 10 users in there who are successfully able to access the SQL Server database. I ...
1
vote
1answer
294 views
How to remove column output in a for xml path query with a group by expression?
I forgot how to remove a column from being output in a FOR XML PATH query using a group by expression. I used it before but somehow I lost the article. In the below example. I do not wish to have ...
0
votes
1answer
48 views
Disabled trigger still fired
I've just run the following t-sql to disable a trigger (with a deploy script wrapper around osql):
disable trigger dbo.trExampleTableInsert ON dbo.ExampleTable
In SSMS I could see the trigger was ...
-1
votes
1answer
51 views
Object name 'Clean Up History' in use when trying to complete the maintenance plan wizard in SQL Server 2008 R2
I am trying to create a maintenance plan on a instance running SQL Server 2008 R2 SP1 (no CU's installed).
When completing the wizard I get the following error:
The object name cannot be changed ...
0
votes
0answers
12 views
Record versioning and promotion
Let's say we have this hierarchy:
-World
--USA
---WA
----Seattle
-----Downtown
------1st Ave
-------945 1st ave
------3rd Ave
...
0
votes
0answers
43 views
Copy tables from a stand-by database
I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
0
votes
0answers
45 views
Deadlocks in Small Table
Our application is seeing deadlocks while inserting records into a table shortly after installation, while the table is small. These deadlocks eventually go away as the table fills up.
The ...
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
0answers
80 views
SQL Server connection failed for domain user from Mac OS machine
I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server.
In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
0
votes
0answers
46 views
bad to assign specific processors to SQL Server 2008 R2 cluster instances?
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
0
votes
0answers
111 views
SQL Server 2008 R2 Database Diagram Error Code
I have sysadmin privileges on a SQL Server 2008 R2 server. I'm working with the development database and want to save a database diagram I created. When I try to save I get the following error ...
0
votes
0answers
134 views
Consequences of multiple FK's from same column to multiple tables
I know it's possible to create multiple FK's to different tables using the same column, other than the performance hit caused by having a FK, are there any negative consequences of doing so?
...
0
votes
0answers
71 views
Evaluation of end user reporting tools and capabilities
I tried to find a reliable software review that compares the Reporting tools which provide end users to create their own reports. However couldn't find any. The reviews were either too old, or they ...
0
votes
0answers
120 views
Real time replication issue - can't use transactional replication
We have an existing Microsoft SQL Server 2008 R2 database that we need to real time replicate to an identical off-site live web database.
Transactional replication and merge replication will not be ...
0
votes
0answers
175 views
Cannot change the Delete Rule of a self referencing foreign-key-relationship to cascade delete
I have the following table
[dbo].[myObj](
[ID] [int] IDENTITY(1,1) NOT NULL,
[fk_ParentID] [int] NULL
)
and I have a relationship from fk_ParentID to ID.
I want to change the Delete Rule in ...
0
votes
0answers
200 views
Unable to view “Maintenance Plan” folder under Maintenance in SQL Server 2008 R2 Standard Edition
SQL Server version is as follows :
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Copyright (c) Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service ...
0
votes
0answers
102 views
How to design the table and its relationship?
I am having a problem designing a Dim and Fact Table for the following problem.
I want to display my data in PivotGrid as below :
First table shows that if i search a person, anyone related to ...
0
votes
0answers
289 views
Update Statistics Maintenance Plan - Ambiguous column name error
Microsoft SQL Server 2008 R2 Web Edition (RTM) - 10.50.1600.1 (Intel X86)
Windows 2003 R2 SP2
I am in the process of setting up a maintenance plan to update statistics on a daily basis for all user ...
0
votes
0answers
549 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 ...
