This tag is for SQL Server 2008, major build version 10.00.xxxx.

learn more… | top users | synonyms (1)

4
votes
0answers
531 views

Receiving error Error: 18059, Severity: 20, State: 1 in the SQL Logs

I'm using SQL Server 2008 Sp3 Lately I'm having errors in the SQL Logs: Error: 18059, Severity: 20, State: 1. The connection has been dropped because the principal that opened it ...
3
votes
0answers
60 views

Restoring differential backup creates DEFUNCT log file?

Here is my problem. I'm trying to move a database to a new server via a full restore, then cutover with a quick differential backup/restore. I can do a full restore without a problem, but when ...
3
votes
0answers
92 views

SQL Server 2012 Resource Governor and memory used by CLR

In SQL 2012 memory used by CLR is now part of what is controlled by "MAX Server Memory" a) Does Resource Governor in SQL 2012 Enterprise (MAX_MEMORY_PERCENT for resource pool) governs CLR memory? ...
3
votes
0answers
229 views

SQL Server: deadlocked on lock communication buffer resources

what could be possible reason for this deadlock type? (not deadlock in general) lock communication buffer resources is this indicated system is low in memory and buffers count ran out of limit? ...
3
votes
0answers
109 views

SUSPECT in mdf files

when i run ALTER DATABASE EMS102013 SET SINGLE_USER; DBCC CHECKDB (EMS102013) WITH NO_INFOMSGS, ALL_ERRORMSGS show message Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was ...
3
votes
0answers
508 views

Severity 016 Backup virtual device fail

My backup on one of my servers is failing once a week. This is the alert I'm getting: DESCRIPTION: BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device ...
3
votes
0answers
173 views

SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows

So I've got a Stored Procedure that's copying data from one table to another. It calls this other SP to get the column names. I didn't write this darn thing, but here's that part: ALTER PROCEDURE ...
3
votes
0answers
260 views

SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?

I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in. My small development team needs to have local ...
3
votes
0answers
196 views

How unsafe is it to change the data source of repl_distributor on a publisher

I have a long story that I will condense to a few bullet points that leads up to my question Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication ...
3
votes
0answers
78 views

How Much Overhead Does Web Sync Add?

I am running merge replication in SQL2012 using web sync. Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection? ...
3
votes
0answers
104 views

Tools for maintaining many dev/test environments on the cloud

The company I'm currently working with is "moving to the cloud" (isn't everyone these days?) In this case, they are moving to AWS, and they want a simple and effective way of managing multiple (SQL) ...
3
votes
0answers
318 views

SQL Server 2008 replication scenario

First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;) Until now, the scenario that I have is as follows: In a server under our LAN, we have a database ...
3
votes
0answers
87 views

best way to consolidate data

I have three select statements which have the bulk of their columns which are the same except a few. So here is an example select *orgid='0' ,'P' as OrgType* , Lang ,*cast(Null as varchar) as ...
3
votes
0answers
1k views

Event 4104, MSDTC Client 2

I have an Active/Active Sql 2008 R2 cluster that I monitor with Idera Sql Diagnostic Manager. It just started reporting that one of the instances does not have DTC or Sql Server Agent installed. I've ...
2
votes
0answers
39 views

Cross-talk with temp tables with SSRS over a shared data source?

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in ...
2
votes
0answers
69 views

send custom email when SQL Server job fails

I have setup a profile and account for sending mail using DatabaseMail. I have a SQL JOB. If the job fails, I receive an Email Till this point, everything works fine. This is what the email looks ...
2
votes
0answers
53 views

Maintaining Referential Integrity with a Filestream enabled database

We have a production database which is filestream enabled and has grown, within a year, to about 20Gb as it stores documents. On many occasions we need to bring the live data back to UAT or Dev ...
2
votes
0answers
105 views

SSRS slow opening a Datasource

While optimizing a report, I discovered that the time reported by TimeDataRetrieval in ExecutionLog2 was a couple of seconds longer than the query times shown in SQL Server Profiler for that report ...
2
votes
0answers
67 views

Collect information about currently running queries only when client timeout occurs

We would like to be able to collect information about all currently running queries when (and only when) a client timeout occurs in SQL Server 2008. I know I can collect information about the client ...
2
votes
0answers
252 views

Passing NULL xml value to a certain CLR stored function crashes it when called in a certain way

Consider a CLR stored procedure that accepts an XML parameter and calls another stored procedure in the same schema: [SqlFunction(DataAccess = DataAccessKind.Read, IsDeterministic = false, ...
2
votes
0answers
262 views

How to set up users in SQL Server 2008 Express over workgroup? (no domain)

The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
2
votes
0answers
216 views

Audit Queries in SQL Server 2008 Including Start Stop Times

I have SQL Server 2008 Enterprise. I know how to set up auditing on the SQL Server, but it looks like the audit logs don't include query start/stop times. We currently use a product called Splunk to ...
2
votes
0answers
140 views

SSMS causing Event ID 4674: SeTakeOwnershipPrivilege

Somewhat of a strange one. Recently my user id's been showing up in a number of Audit Success records in the Security event log of one of our production database servers with the below content (or ...
2
votes
0answers
177 views

Cannot Delete FileStream Group from Sql Server 2008

We have migrated all our varbinary(max) column data to Azure Blob Storage and so we want to remove the old filestream columns that remain in our Sql 2008 database and the filestream filegroup but when ...
2
votes
0answers
55 views

How can I copy a user while preserving all privs?

We're changing domains. I'd like to create a new account for myself, NewDomain\Bob which has the same su-level privileges as OldDomain\Bob, to minimize the chance of disruption when IT flips the ...
2
votes
0answers
98 views

Can't get users default schema to change - SQL Server 2008

We are migrating from a SQL Server 2008 instance on a shared host to our own box. Our issue is we have a bunch of tables, procs and views that are prefaced with a schema (let's call the schema 'me') ...
2
votes
0answers
297 views

Cannot connect to SQL Server 2008 after updating the service pack

After updating, whenever I start the service of the server in configuration manager, it always stops then. And I found the error in the log 2013-04-13 19:08:19.63 spid7s Error: 15174, ...
2
votes
0answers
56 views

Stored Procedure Performance Issue

I have a stored procedure that is stalling the database. If the stored procedure is run as a query, the results arrive nearly instantly. If the stored procedure is run as a stored procedure, with it's ...
2
votes
0answers
183 views

Last Known Successful DBCC CHECKDB

I understand that looking at DBCC PAGE is supposed to show me the last known good DBCC CHECKDB but I am not seeing this work correctly. I have a database that I know is corrupted. If I run DBCC ...
2
votes
0answers
124 views

Configuring SQL Server Job agent

I am trying to configure the SQL Server Job Agent using the following scripts USE [msdb] GO CREATE USER [mydbuser] FOR LOGIN [mydbuser] GO EXEC sp_addrolemember N'db_datareader', N'mydbuser' GO EXEC ...
2
votes
0answers
293 views

SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It

I really need help on understanding this deadlock, i've already replaced the values, mind if anyone helps me interpreting where my deadlocks are coming from? What does e_waitpipegetrow mean? btw, i'm ...
2
votes
0answers
268 views

Transactional Replication Error adding new subscription (null) article

When attempting to add a new subscription to an existing Transactional publication on 2008. It is all configured on 1 server as it is for Pre-Production testing. I get the following error when ...
2
votes
0answers
85 views

Identifying connection and publisher vs subscriber in merge replication scheme

We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
2
votes
0answers
433 views

Why is SSMS 2008 prompting me “if you are certain that you have added all the necessary full-text catalogs, click OK”

When I try to attach a database in SQL Server Management Studio 2008 (SSMS), I get prompted by this message: If you are certain that you have added all the necessary full-text catalogs, click OK. ...
2
votes
0answers
210 views

Auditing - parameter values not being written to log

I am using auditing to track usage of some procs in the database. In the log I can see a record for the Procedure being run and, immediately afterwards,the SQL statement that is being run. The ...
2
votes
0answers
281 views

Grant User Permission To Restore Database And Access that database in sql server?

I want to create a user having dbcreate, db restore server roles and will be db owner of that database. But there is only 1 server roles available that is dbcreator, which can create database is also ...
2
votes
0answers
665 views

Create SSIS package to copy data between SQL Server 2008 installs on different machines?

I'm new to the whole SSIS world. I'm trying to create a process to copy data between SQL Server 2008 environments. I want to be able to run a job to export data from my prod database and then use that ...
2
votes
0answers
404 views

SQL Server 2008: NULL SID for WINDOWS_USER in sys.database_principals

Has anyone ever seen anything like this before? I have a WINDOWS_LOGIN AD user that has a record in sys.server_principals with a SID and can login fine. But in a few databases, they have a record in ...
2
votes
0answers
195 views

need help finding the details of a deadlock

We are having issues with deadlocks and I am trying to isolate what database object is causing the problem. I found Deadlock error isn't returning the deadlock SQL to be very helpful and I read ...
2
votes
0answers
230 views

SQL Server SSIS issue retrieve data when i enter into login of server side?

can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side here is the error message TITLE: Microsoft SQL Server Management Studio ...
2
votes
0answers
294 views

SSIS - Derive column values based on join/subselect from a non-table source

I have a flat file source that contains a lot of duplicate records, which have the same key fields but differ by their "changed date". I need to split this up into two outputs, one for the "latest" ...
2
votes
0answers
234 views

going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?

Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like <allData> <product1> ...
2
votes
0answers
151 views

Change tracking on, but columns not tracking

In SQL 2008, I have change tracking turned on both on the database and table levels, with column tracking turned on at the table level. The CHANGETABLE(CHANGES...) function returns the expected ...
2
votes
0answers
323 views

Is it normal for the SQL Server Profiler SP:StmtCompleted event to give 0 duration?

I'm trying to diagnose a slow running stored procedure in SQL Server. The procedure is quite long and complicated. I have been trying to figure out which statement is causing the issue. I have run a ...
2
votes
0answers
971 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
0answers
49 views

Side effects of using updlock lock hint?

I was just exploring UPDLOCK hint in SQL-Server 2008 and I found it is very useful in avoiding certain deadlock scenarios. There are always some side effects when using these types of lock hints but I ...
1
vote
0answers
49 views

SQL command in stored procedure continue on error

To perform Checkdb on all database of server i am using a stored procedure which loops over a view which contains list of databases in server and the stored procedure performs checkdb on all databases ...
1
vote
0answers
30 views

SQL Server Full-Text Index with Stoplist

I've searched this site and the internet in general and can't find any information which answers my question, so I thought I'd post it here. I have Full Text search operating on a database in SQL ...
1
vote
0answers
72 views

The memory usage of SQL Server keeps growing

We have a production SQL Server 2008r2 x64. 16GB RAM and this server is used by the application (hosted) and SQL Server. The max memory setting = 6GB The min memory setting = 128MB. There are ~25k ...
1
vote
0answers
96 views

SQL Server 2012 Publisher SQL Server 2008 Subscriber version issue

So I have a setup where one virtual machine is a SQL Server 2012 publisher and I need to setup merge replication on a SQL Server 2008 subscriber on a different vm. When setting up the subscription ...