Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
290
questions with no upvoted or accepted answers
6
votes
0answers
286 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
329 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
160 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
243 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
70 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
1answer
652 views
Converting Monthly Rolling SUM (YTD) back to Monthly numbers
I'm having a problem converting rolling SUM by month (monthly year to date) back to only that month's numbers.
For example, see table below. Periods are (YYMM) and a monthly period per year starts ...
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
541 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
247 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
68 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
421 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
276 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
258 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
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....
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
721 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
910 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
866 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
54 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
89 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
432 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
73 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
1answer
163 views
Ideas how to make this query faster?
I have the following query:
SELECT TabPohybyZbozi.ID,
TabPohybyZbozi.NazevSozNa2,
TabZakazka.Nazev,
TabDokladyZbozi.DatPorizeni,
TabPohybyZbozi.IDDoklad
FROM ...
2
votes
0answers
5k 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
244 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
1answer
189 views
Transactional replication with updates on the subscriber?
Summary
We need a "two-way" (bi-directional) replication topology which should be easy to setup and administer, with minimal downtime when changes are required.
Current solution
We have two SQL ...
2
votes
0answers
304 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
115 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
28 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
56 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
197 views
Error when trying to start Microsoft SQL Server 2008 instance from SQL Server Configuration Manager
I get this error when I try to start Microsoft SQL Server 2008 instance from SQL Server configuration manager.
SQL Server configuration manager : The request failed or the service did not respond ...
2
votes
0answers
153 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
1answer
132 views
Max Degree of Parallelism for SQL Server 2008
Microsoft have recommendations around setting MAXDOP on various versions of SQL Server, but this (old) article raises some issues and recommends setting MAXDOP = 1 generally for SQL Server 2005 and ...
2
votes
0answers
564 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
1answer
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
663 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
550 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
1answer
106 views
Replace/upgrade mirrored server hardware
We are deploying new VMs for a mirrored database that is in high safety mode with automatic failover and also going from SQL Server 2008 to SQL Server 2008R2.
Most of the documentation I've come ...
2
votes
0answers
80 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
120 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
485 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
572 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
524 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 ...
