This Tag is for SQL Server 2008 R2, major build version 10.50.xxxx
1
vote
1answer
125 views
How can I skip reboot check and remove command line appearing during install of SQL Server?
While i am installing SQL Server 2008 R2 using the configuration file method I sometimes get an error in installation due to system reboot checking.
After restarting my PC, SQL Server installs ...
1
vote
1answer
56 views
Would I lose data if I change a column from varbinary(8000) to varbinary(max)?
Is there any data loss if a table is being altered to change an existing column from varbinary(8000) to varbinary(MAX)?
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
0answers
107 views
Why Am I Getting Deadlock - Please Read Trace
can anyone help me?
i'm getting deadlock on this trace, i'm using symmetricds and i can't understand why i'm getting a deadlock on a certain table.
I'm using sql server 2008 r2, ...
4
votes
2answers
111 views
Generate script to automate renaming of default constraints
Background: Some of our default column constraints were generated without explicit names, so we get fun names that vary from server to server like: DF__User__TimeZoneIn__5C4D869D
I would prefer to ...
1
vote
1answer
81 views
Error creating scalar function “Invalid Object Name dbo.fnMyFunctionName'”
I am using SQL Server 2008 R2. I tried creating a new scalar function. The function gets created and I see it in the list of scalar functions.
When I try to modify function, function name is ...
3
votes
1answer
164 views
SQL Server 2008R2 DBCC CheckDB never finishing
I'm running SQL Server 2008 R2 on Windows server 2008 R2 and up until recently we were having no problems. After windows updates recently (no sql server updates) we cannot run step 1 of our ...
3
votes
1answer
43 views
How can I rename an auto-named constraint when I get this error 15248?
Method:
Open SSMS. Find table. Open constraints. Find constraint name. Right click, rename. Give new name.
EXPLODE. (well, it just fails, at least)
3
votes
1answer
76 views
Item Index for all items in nested XML query
I have a requirement to build an XML package with a parent record, and 1..N related child records.
The child records are to be a nodes under the parent node, and there may be one child record or ...
5
votes
2answers
45 views
Retrieving cached plans fails due to cached objects of database Mirror
I'm trying to retrieve cached execution plans for a specific database object, but this fails because of cached plans which belong to a mirrored database in MIRROR state.
The below query, without any ...
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
0answers
120 views
SQL Server in a state of confusion: Does the database exist or doesn't it? [duplicate]
Got a really weird, annoying problem.. Somehow the instance of SQL Server 2008 R2 running on our server has gotten somewhat corrupted.
First, we noticed that the database we created yesterday was ...
6
votes
1answer
154 views
UNIQUE index key violation
I have a table with a PK and a unique non-clustered index, as follows:
CREATE TABLE Table1
(
Id INT IDENTITY(1,1) NOT NULL,
Field1 VARCHAR(25) NOT NULL,
Field2 VARCHAR(25) NULL,
...
1
vote
1answer
99 views
SQL Server 2008 R2 database mirroring - is it possible to have a slave server for multiple master servers?
Scenario is that I have two servers running SQL Server 2008 R2 (64-bit), let's call them DB1 and DB2. I have set up database mirroring for all the databases on these servers so that DB1 is the ...
1
vote
2answers
147 views
Issue with ROW_NUMBER and DISTINCT
I have following query
SELECT Dept
,ID
FROM (SELECT TOP (@RowTo) ROW_NUMBER() OVER (ORDER BY Dept) AS ROWID,
Dept
,ID
FROM Department
...
2
votes
2answers
106 views
How to restore a filegroup from its backup in SQL Server
I need guidance on how to restore a file group in Database from the File group backup taken from another same DB server. Is it possible to restore the filegroup by running restore DB for File Group.
...
1
vote
0answers
91 views
Collect CPU, reads and writes when replaying SQL Profiler Trace
I'm trying to replay a trace on a test environment with SQL Profiler in order to benchmark a database prior to making some performance tweaks. I intend to replay the same trace at various stages to ...
1
vote
0answers
90 views
Troubleshooting Database Mail issues and Service Account permissions in SQL Server
I am having difficulties troubleshooting a Database Mail issue. When I try to stop and start the service using sysmail_start_sp and sysmail_stop_sp, I see a critical error in the Administrative Logs ...
2
votes
1answer
189 views
SQL Server cluster questions please
We have SQL Server 2008 R2 cluster active/active/active (a, b, c) and three instances run on this environment.
We did a test on one of the instances, and failover test.
Manual failover from node c ...
1
vote
1answer
77 views
Effects of enabling service broker
I would like to use SqlCacheDependency to update a dataset in real-time, but we have not enabled the service broker on our production database. Could enabling the service broker have any adverse ...
3
votes
0answers
111 views
How do I know if my database partitioning is done well?
I have a sneaking suspicion that the guy who wrote the partitioning functions at my place of work did a fairly poor job. For certain queries (maybe 20% of them) we see incredible performance boosts ...
0
votes
4answers
115 views
Update Table A row if Table B row is changed
Is is anyhow possible to tell the database to execute a little script, if a row is changed in a table?
Scenario:
The database constantly monitoring Table B to see if rows are inserted, updated or ...
3
votes
2answers
69 views
Load Testing Crash Course
Can someone point me at a good resource to get a crash course in load testing. I have a sql server machine that I need to load test but I havent been thruogh the process before. Also we do not have ...
0
votes
2answers
111 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?
...
3
votes
0answers
80 views
Key Lookup and Full-text index
I have the following query:
SELECT T2.Title
FROM TitleTable T1
INNER JOIN TitleTable T2 ON T2.FKID1 = T1.FKID1
WHERE T1.FKID2 = @ID_PARAM1
AND T2.FKID2 = @ID_PARAM2
AND ...
4
votes
2answers
372 views
Manually moving SQL instance to another node causes immediate database mirror failover
I have a two-node SQL cluster (2008 R2).
Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
0
votes
1answer
322 views
How to fix “The OLE DB provider ”MSOLAP“ has not been registered”?
Here's the code I'm using to register a linked server to SSAS:
USE [master];
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'ServerAlias',
@srvproduct = N'',
@provider= N'MSOLAP',
...
0
votes
2answers
154 views
SQL Server 2008 R2 not starting after moving model database
SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas?
Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need ...
0
votes
1answer
67 views
SQL Server domain account login and user
What is the difference between
adding a domain account login to an SQL Server (2008 R2) instance then add a corresponding user to a database
adding a domain account user to a database without ...
1
vote
3answers
134 views
SQL Server xml performance
I have a table with 21 columns. The majority are numerical and the rest are nvarchar.
I need to add 4 columns that will contain XML data for each row. The XML data for each row can be anywhere from ...
1
vote
1answer
320 views
Find all the queries executed recently on a database
[I am a beginner level T-SQL Programmer]
[..and hopefully I am on the right stack exchange site]
I would like to get a list of all the queries I executed (in the least, those I executed today since ...
3
votes
3answers
108 views
Password reset for database for VCenter Install
I'm trying to reinstall vCenter SSO and it is prompting me for the "sa" password. I set it up previously, but cannot remember what I used. I uninstalled SSO (as well as the vCenter Server, and ...
2
votes
1answer
54 views
Pervasive linked server provider missing
I am having the same problem as this question.
I installed Pervasive v11 (which does have 64bit ODBC drivers) and I still do not see Pervasive listed as a provider when trying to create a linked ...
2
votes
1answer
58 views
How to tell what's failing at making backups?
I have an instance of SQL server that is regularly getting errors like this:
02/25/2013 23:22:38,spid138,Unknown,BackupVirtualDeviceFile::SendFileInfoBegin:
failure on backup device ...
2
votes
1answer
95 views
Log all than queries taking more than X seconds
I have a database Microsoft SQL Server 2008r2. I have some applications in different programming languages.
I would like to log all the queries that take more than X seconds.
I guess that the I ...
3
votes
2answers
224 views
Subquery in the VALUES clause
Here's a real-world schema:
CREATE TABLE [dbo].[Setting]
(
[ID] [BIGINT] NOT NULL,
[Module] [NVARCHAR](400) NOT NULL,
[Property] [NVARCHAR](400) NOT NULL,
[Value] ...
3
votes
1answer
45 views
How do I create a CLR UDF with external name specifying namespace, class, and subclass?
I am creating a CLR UDF using external name and second level nested class names seem not to be permitted. Is this the case? When using the following syntax and including a first level class name and ...
1
vote
0answers
125 views
SQL Cluster Resources Disappear After Removing Disk Resource
In the process of removing an usused disk resource from cluster, I would follow these steps: 1) remove dependencies on the disks by the SQL Server resource, 2) take the disk resource offline, 3) ...
3
votes
3answers
291 views
Choosing the right algorithm in HashBytes function
We need to create hash value of nvarchar data for comparison purposes.
There are multiple hash algorithms available in T-SQL, but which one the best to choose from in this scenario? We want to ensure ...
2
votes
1answer
73 views
Microsoft Baseline Configuration Analyser on Production
I came across an useful tool that Microsoft has released for configuration analysis. It's called Microsoft Baseline Configuration Analyser 2.0.
I downloaded and ran it on my local instance and got a ...
-1
votes
1answer
150 views
How to set the timeoffset in a Datetimeoffset column without changing the date part
Is there any way to set the timeoffset of a datetimeoffset column directly without having to use SWITCHOFFSET which changes the date as well?
In the post below, we can see the SWITCHOFFSET will ...
3
votes
2answers
128 views
Log all errors in queries
I have a database Microsoft SQL Server 2008r2
I have some applications in different programming languages. Some of them are legacy and I would not like to modify.
Is there a way to log at server level ...
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
2answers
193 views
Stored Procedure as Create Table proxy?
With SQL Server it was my understanding, I thought, that you could elevate a users permissions with specific constraints.
For example, you need a user to create a specific table object in a specific ...
0
votes
1answer
85 views
How to remove symbol from file
I am using ssis to generate some .dat files which are then sent to linux server for automated load. It looks as windows add some symbol character in file which is not easily identifiable first but if ...
3
votes
2answers
156 views
SQL Server replication for off site copy
We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors).
These are mirrored to other backup servers in ...
0
votes
0answers
30 views
SQL Server connection failed for normal domain user [duplicate]
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
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 ...
2
votes
0answers
35 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
1
vote
2answers
104 views
Using SQL Server 2012 for Business Intelligence Features Only, No Database Engine
I would like to implement SQL Server 2012 purely for the Business Intelligence Features: SSIS, SSAS and SSRS on its own server.
I current have SQL Server 2008R2 Database Engine installed on another ...
