Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
5
votes
0answers
178 views
SQL Server Profiler: why the RPC Starting event does use an different decimal separator from SP Starting?
Trying to diagnose an problem, I've ran into that inconsistency.
In SQL Server Profiler, the RPC Starting event uses the regional settings to write real numbers (example: in Portuguese(Brazil) 14.5 ...
4
votes
0answers
864 views
Upgrading SQL Server from 2008 to 2012 doesn't respect existing install / instance paths
Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server (...
4
votes
0answers
538 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
83 views
Moving to version 2016 from 2008 and Breaking Change Alert from Upgrade Advisor
DBMS: SQL Server
Upgrading from version 2008 to 2016.
I have this part of the code that is being flagged by the Upgrade adviser as Breaking Change.
Error: uses a constant expression which are ...
3
votes
0answers
85 views
Update in SQL Server leads to very high value in a column
We encountered a very strange behaviour that happened only once in a few years of production of our application: An update happened via "normal" ADO.NET out of a WinForms app on a database table and a ...
3
votes
0answers
211 views
SQL Server Incremental Backups Split
I am trying to recover a database where the incremental (log) backups are split between two methods (Carbonite/Zmanda and SQL .bak files).
When I try to use the restore wizard I get the following ...
3
votes
0answers
45 views
Network Traffic increase with Small Result Set
I am currently executing a stored procedure that is using up a ton of network traffic when it executes. The stored proc executes multiple stored procs within itself as well as functions and ...
3
votes
0answers
106 views
Bad Plan after a couple of days
I have this query that runs fine for a couple of days (from the application) and then slows down to where it can't even finish.
If I rebuild the plan, it flies.
There is a signifigant amount of data ...
3
votes
0answers
396 views
Table queries locked during long insert SQL server
Everyday runs a sql job that loads data from bulk files and load them in auxiliary tables, to adapt and then copy to the destination table where applications read (and only read) the data.
I am ...
3
votes
0answers
1k 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 ...
3
votes
0answers
268 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?
b)...
3
votes
0answers
1k 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 ...
3
votes
0answers
233 views
SUSPECT in mdf files
When I run
ALTER DATABASE EMS102013 SET SINGLE_USER;
DBCC CHECKDB (EMS102013) WITH NO_INFOMSGS, ALL_ERRORMSGS
shows message
Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was
...
3
votes
0answers
3k 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 '{DE47BFA0-E5AD-46DD-868C-...
3
votes
0answers
1k 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
704 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 ...
3
votes
0answers
858 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
307 views
Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)
sp_spaceused, when executed without any parameters, produces 2 result sets
database_name, database_size, unallocated_size
reserved, data, index_space, unused
Usually when you execute some SP, you ...
2
votes
0answers
71 views
Linked servers not ignoring case after reboot
We have a SQL Server 2014 database with collation SQL_Latin1_General_CP1_CI_AS, which is case insensitive. It is linked to another SQL server database with the same collation. The second database ...
2
votes
0answers
239 views
Unexplainable behavior of SQL Server under Windows Authentication
The versions affected are SQL Server 2005, 2008, 2008 R2.
If we grant CONNECT SQL to public server role, any AD account can log in to server.
So we'll have all the AD members on the server without ...
2
votes
0answers
240 views
Export SQL View to CSV flat file. SSIS job stuck
I created a database view with the desired data and format. I used SQL Server Import and Export wizard to create a flat file export procedure and saved it to SSIS package.
The data exports correctly ...
2
votes
0answers
82 views
Sql Server Server 2008 r2 Installation Error
I am installing SQL Server 2008 R2 Enterprise Edition on Windows Server 2012. Unexpectedly I come across the error shown below. Installation successfully completes.
Can someone help me identify the ...
2
votes
0answers
100 views
Database Table Schema Circular Reference issue
Trying to fix a Circular Reference in a schema created by a developer, but having a hard time. This is as far as I have gotten. The black line is the tables that are needed to create a file. The red ...
2
votes
0answers
23 views
Is sp_stoppublication_snapshot considered a undocumented procedure or is my searching just bad?
I am trying to start and stop the replication snapshot via t-sql. I found sp_startpublication_snapshot, and doing a trace while hitting the stop on the snapshot from inside SSMS I see it calls ...
2
votes
0answers
107 views
Is the average row size listed in Management Studio's index properties accurate?
I just inherited some SQL Server 2008 R2 databases and have reason to be reviewing the indexes on some tables. For a table with two columns such as:
CREATE TABLE My_Table ( Obj_Id int NOT NULL,
...
2
votes
0answers
479 views
Database Corruption - object in sys.parameters does not have a matching row in sys.objects
I'm using SQL Server 2008 R2 and I have a strange db corruption.
I ran dbcc check db and the output is:
Attribute (object_id=1096186) of row (object_id=1096186,parameter_id=1) in sys.parameters ...
2
votes
0answers
2k views
SQL Server 2012 Installation Error on Windows 2008 Server
I am facing an error while trying to install SQL Server 2012 EXPRESS ADVANCED EDITION(32bit) on Windows Server 2008 Enterprise(64bit).
After passing Rule Check, at install updates section, error ...
2
votes
0answers
563 views
Are there undocumented Linked Server limitations?
I'm working on a SQL Server 2008 R2 SP1 with a Sage product registered as a linked server. There are a few stored procedures that execute a pass-through against the linked server. Once in a while, a ...
2
votes
0answers
540 views
SQL Server 2008 Expr. SP2 install fails - “failed to retrieve data for this request..”
I tried to install SQL Server 2008 Express SP2 but the installation process fails with the following error message "failed to retrieve data for this request.."
First the window "SQL server ...
2
votes
0answers
75 views
How long does the final phase of an online index creation take?
In reading the whitepaper: Online Indexing Operations in SQL Server 2005 it says:
The online index build process can be roughly divided into three
phases:
Preparation
Build
Final
...
2
votes
0answers
920 views
Case Statements, subqueries, and datediff
First time posting on this website so please let me know if you require any other information. This first section of code worked perfectly and resulted in correct information.
[Field 1] = (CASE
...
2
votes
0answers
116 views
Is there an equivalent to sys.dm_exec_query_memory_grants for non-waiting queries?
Basically I have a proc that executes and requires massive amounts of memory. We can sometimes get into a situation where the proc executes multiple times, in which case the memory grants are visible ...
2
votes
0answers
69 views
Constrain referenced rows to two different tables to belong to the same row in another table
Apologies for the potentially confusing question title. I struggled to make it generic!
I am designing a wildlife recording database. An observer goes to a site and records the occurences of species ...
2
votes
0answers
439 views
Multiple login mappings for linked server
Can we assign two logins for two different databases on target server.
For example, I would like to create a Linked Server between ServerA and ServerB.
ServerB has two databases on it and both using ...
2
votes
0answers
545 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
501 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
266 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
150 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 ...
2
votes
0answers
255 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
292 views
Is it possible to configure Reporting Services to emit browser compatibility headers?
We have a dashboard that hosts some Reporting Services (2008) reports within frames. The dashboard runs in the browser's standards compliance mode, but this is causing some of the reporting services ...
2
votes
0answers
784 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
473 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
82 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
286 views
Transfer data from DynamoDB to SQL server 2008?
I want to transfer data from amazon dynamo DB to SQL server 2008. What are the tools or methods which can be used to do this ?
2
votes
0answers
3k views
SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB
I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query:
SELECT * FROM sys....
2
votes
0answers
129 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
745 views
Transactional Replication Over Domain
I am trying to setup transactional replication in SQL Server 2008 R2 on two servers on separate domains. I am able to create the distributor, create the publication, and create the subscription, ...
2
votes
0answers
302 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
473 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
211 views
Requesting advice on creating a table controlled SQL job scheduler
I have been tasked with cleaning up a series of SQL jobs that send email updates about various data and system conditions in my company. Currently, there are a ton of jobs, each with its own SQL code ...