Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
292
questions with no upvoted or accepted answers
6
votes
0answers
378 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 ...
5
votes
1answer
398 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"...
5
votes
1answer
175 views
Code required to make column not nullable
I have a table where I mistakenly allowed NULL values in a column:
CREATE TABLE EXAMPLE (
EXAMPLE_ID INT IDENTITY(1, 1) NOT NULL,
FOO_ID INT,
CREATED_ON DATETIME DEFAULT CURRENT_TIMESTAMP,...
4
votes
0answers
291 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 ...
4
votes
1answer
72 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 ...
4
votes
0answers
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 (...
4
votes
0answers
548 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
266 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
107 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
1answer
79 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 ...
3
votes
0answers
487 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
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 ...
3
votes
0answers
284 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
282 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
4k 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....
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
733 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
946 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 ...
3
votes
1answer
952 views
Determine Which Parameters Passed Into Stored Procedure
Is there a way to determine (from within a stored procedure) which parameters were passed into a stored procedure (vs. those which just took the default value)?
2
votes
1answer
43 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
...
2
votes
1answer
56 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 ...
2
votes
1answer
127 views
SQL 2008/R2 Extended Events - Row Count
I need to setup a sql audit to capture all queries running on a server from any unauthorized locations, and one of the columns that is required is Row Count.
In sql trace, this is possible. But I can'...
2
votes
0answers
518 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
85 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
8k 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 ...
2
votes
0answers
245 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
396 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
129 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
34 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
1answer
64 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 ...
2
votes
1answer
232 views
Error when trying to start Microsoft SQL Server 2008 instance from SQL Server Configuration Manager
I get the following error when I try to start Microsoft SQL Server 2008 instance from the SQL Server Configuration Manager.
SQL Server configuration manager : The request failed or the service did ...
2
votes
0answers
198 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
669 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
714 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
562 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
84 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
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
...
2
votes
0answers
138 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
70 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
532 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
591 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
527 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
289 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
165 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
307 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
816 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
510 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 ...
