Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
278
questions with no upvoted or accepted answers
8
votes
1
answer
577
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 ...
- 937
7
votes
1
answer
2k
views
Service Broker: Queue Monitor is dropped after poison message
I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer.
When I setup event ...
- 121
5
votes
1
answer
98
views
How to calculate required ressources from a baseline and what should be measured at all?
I have to deal with the following situatiuon:
Currently we have
1 cluster with 5 nodes running 10 instances (SQL Server 2008 Enterprise edition), and
1 cluster with 2 nodes running 5 instances (SQL ...
- 51
5
votes
1
answer
767
views
Server Logon Trigger fails after deleting many records in "Logon-Table" -SQL Error 2801
We have a server logon trigger defined that logs every login with information like windows/sql user name, client and time in a table.
The table doesn't have clustered index, but it does have a "PK_ID"...
- 449
4
votes
1
answer
115
views
reading content of master database at a different server
I have a query for example
select * from sys.databases
select * from sys.configurations
I believe this information is stored at master database.
I would like to have a look at configuration settings ...
- 41
4
votes
0
answers
1k
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 (...
- 41
4
votes
0
answers
559
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 ...
- 41
3
votes
0
answers
12k
views
SQL Server Database Engine cannot obtain a LOCK resource at this time
I've recently started getting this error :
Msg 1204, Level 19, State 4, Line 1
The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement ...
- 943
3
votes
0
answers
51
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 ...
- 1,035
3
votes
0
answers
282
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 ...
- 31
3
votes
0
answers
46
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 ...
- 31
3
votes
0
answers
110
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 ...
- 1,597
3
votes
0
answers
578
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
0
answers
612
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 ...
- 717
3
votes
0
answers
2k
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 ...
- 507
3
votes
0
answers
311
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)...
- 2,961
3
votes
0
answers
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
0
answers
320
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
...
- 31
3
votes
0
answers
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-...
- 2,968
3
votes
0
answers
5k
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....
- 7,353
3
votes
0
answers
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 ...
- 165
3
votes
0
answers
772
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,581
3
votes
0
answers
1k
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 ...
- 943
2
votes
1
answer
96
views
Error while creating Extended Events on 2008 SQL Server
I am trying to create an extended event to capture the login information of my server. While creating an extended event on SQL 2008 using the below query
CREATE EVENT SESSION [SA_Monitor] ON SERVER
...
- 852
2
votes
1
answer
57
views
Trying to replace a cursor with update statement, went wrong somewhere
I have a cursor im trying to rewrite into a single update statement.
When comparing the results, I get 280 records that are being copied over with the cursor but NOT copied over with the update ...
- 261
2
votes
0
answers
713
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 ...
- 4,612
2
votes
0
answers
175
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 ...
- 171
2
votes
0
answers
254
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 ...
- 10.3k
2
votes
0
answers
488
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 ...
- 153
2
votes
0
answers
142
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 ...
- 99
2
votes
1
answer
79
views
Do I need to worry about RESTORE FILELISTONLY types other than L and D?
According to https://msdn.microsoft.com/en-us/library/ms173778.aspx, there are four types, L, D, F and S.
All of the actual database instances I've seen so far (SQL Server 2008 and up) only have ...
- 131
2
votes
0
answers
270
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,
...
- 21
2
votes
0
answers
831
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 ...
- 211
2
votes
0
answers
781
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 ...
- 441
2
votes
0
answers
579
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 ...
- 21
2
votes
0
answers
2k
views
Export using BCP as ASCII text
I have a script that stores data in a temporary table to be exported by running BCP using xp_cmdshell.
The trouble is that BCP insists on exporting the data in Unicode and I need it to be in ASCII.
...
- 121
2
votes
0
answers
93
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
...
- 121
2
votes
0
answers
1k
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
...
- 21
2
votes
0
answers
176
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 ...
- 265
2
votes
0
answers
76
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 ...
- 217
2
votes
0
answers
632
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 ...
- 507
2
votes
0
answers
538
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 ...
- 121
2
votes
0
answers
318
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 ...
- 141
2
votes
0
answers
173
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 ...
- 141
2
votes
0
answers
309
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 ...
- 557
2
votes
0
answers
840
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 ...
- 223
2
votes
0
answers
578
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 ...
- 419
2
votes
0
answers
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 ...
- 5,772
2
votes
0
answers
310
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 ?
- 21
2
votes
0
answers
142
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 ...
- 21