Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).

learn more… | top users | synonyms (2)

0
votes
0answers
30 views

SQL Server consistency I/O base error

I have received this error while performing queries on a database (SQL Server 2012) msg 824, level 24, state 2, line 1 sql server detected a logical consistency-based i/o error. Incorrect page ID ...
0
votes
0answers
36 views

SSIS and Script Component - WebReference problem

Within my SSIS package-dataflow I have a script component and within this component whenever I add a Web reference and close editor, script component gives me "Validation error. Data Flow Task ...
0
votes
0answers
45 views

Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”

So we have an interesting issue where users are receiving the following error when attempting to query a view in SQL Server 2008 R2: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB ...
0
votes
0answers
21 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
0
votes
0answers
68 views

Why has the backup time significantly increased?

I'm using Sql Server 2012. The problem is that the backup takes about twenty minutes now, whereas only a few days ago it took a matter of seconds. The database has increased by about a sixth since ...
0
votes
0answers
36 views

Sort warning tempDB spill

I am getting a sort warning tempDB spill with one of my queries, I cant for the life of me figure out how to stop it. I have the following indexes on this table (among many others): (title_nm, ...
0
votes
0answers
32 views

How to audit all activity for a Windows Group in SQL Server 2012/2014?

I have a Windows Group called (say) MYDOMAIN\MyDBATeam. This AD group has all the AD accounts for the DBA team. I have auditing set up using server-side traces at the moment and want to move away from ...
0
votes
0answers
24 views

Oracle Database Gateway for SQL Server - Output changes to multibyte view

I have a really strange problem querying a Microsoft SQL Server through a Oracle Database Gateway for SQL Server. Some query outputs look like this SELECT NAME, RawToHex(NAME1) FROM XY; Output: J ...
0
votes
0answers
63 views

SQL Server and Entity Framework

We are currently experiencing a problem with Entity Framework which generates a sp_executesql statement. This statement is below. The statement runs fine in SQL Server however through the front end ...
0
votes
0answers
42 views

Sql Azure: The session limit for the database is 8000 and has been reached

I am getting following exception in SQL Azure, my SQL Server database is a web version, and I am getting this error in SQL Server Management Studio (when connecting). Also this is happening when ...
0
votes
0answers
14 views

sysadmin security error creating Reporting Services cache refresh plan in Report Manager

On SQL Server 2012 (SP1) Reporting Services (native), when creating a cache refresh plan in Report Manager, I receive the error: Only members of sysadmin role are allowed to update or delete jobs ...
0
votes
0answers
27 views

How to convert Excel into Star-schema Moel?

Team, My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not. My data modeler has converted Excel into a single TABLE on MSSQLServer ...
0
votes
0answers
40 views

SQL Server 2008 replication and large data updates

We have an environment setup where we're replicating a single SQL database to 14 subscribers across relatively slow WAN links. The data at the distributor is refreshed once a day - where the tables ...
0
votes
0answers
49 views

SSRS - Report using Stored Procedures, Cascading Parameters and Views

I am looking for a non-trivial Microsoft SQL Server Reporting Services example that shows the efficient use of the following for calculated columns such as: Profit = Revenue - Expense Margin = Profit ...
0
votes
0answers
42 views

incorrect value from SUM Function

Has anyone seen this before? When doing a simple sum on a table: select sum(column) from table where column is not null I'm receiving the data 1558.39999999999 However, investigation of the ...
0
votes
0answers
21 views

DB2 manual asynchrounous real-time replication to NON-DB2 database

I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (=no 3rd party tools allowed) asynchrounous real-time replication in DB2 that replicates all data changes ...
0
votes
0answers
33 views

Table Field to Reference Field in Other Tables

Suppose I want to map a set of input values to database table fields E.g. employeeFirstName --> emp.fName employeeLastName --> emp.lName ... --> ... In theory I can create a ...
0
votes
0answers
41 views

How to configure log shipping in SQL Server 2008 R2 Standard Edition

Could you please guide me on how to configure log shipping in SQL Server 2008 R2 Standard Edition for same hostname with two different IP's. (Primary and Secondary server) example: Primary machine ...
0
votes
0answers
72 views

Check the data latency between two Always On Availability Group servers in ASYNC mode

I have implemented Always on Availability Group in asynchronous mode between two servers primary and secondary. When i tried to check the data latency between the servers in performance monitor ...
0
votes
0answers
29 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...
0
votes
0answers
139 views

SQL Server 2012 Failed to launch local ScenarioEngine.exe

I have been trying install SQL Server 2012 Developer Edition for quite some time now.. I always get "stuck" at Install Setup Files, the install wizard just hides, Now, i reviewed the log file for ...
0
votes
0answers
38 views

SQL Server 2012 Replication Initialisation Fails — Table keeps being dropped

I have two servers - one located in Australia (Distributor / Publisher), and a second in the UK (Subscriber) both on Amazon's cloud. I have attempted to configure replication as both pull and push ...
0
votes
0answers
40 views

Converting char to varchar columns increases database size

I have a database (SQL Server 2005) with thousands of char columns. I want to convert these columns to varchar, then I follow this steps: Shrink Database Check the current stats, general and ...
0
votes
0answers
16 views

WHY Extended Distributed Transactions (XA) NEEDED

I want to know what is Extended Distributed xa Transactions. why it is needed. if we enable this for another database on any existing sql server will it impact my existing databases.
0
votes
0answers
38 views

Master Slave Databases and their architecture

We are currently using Sql Server 2005. We currently have separate databases for different instances of our application. The application is a heavy in terms of data and processing. We now want to ...
0
votes
0answers
48 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
0
votes
0answers
9 views

Do link servers cache remote database connections?

I have set up a link server from a database server (SQL2008) to my local SQLEXPRESS db, using the actual database as its Failover Partner. I then stopped the SQLEXPRESS service and I could still ...
0
votes
0answers
70 views

Map multiple external-id to single internal DB-id

I have been tasked to add a new functionallity to a application and I'm not really sure how the best way to go about this would be... Basically there is a application that receives messages with some ...
0
votes
0answers
50 views

Based on these DBCC SHOWCONTIG stats, should I index this table?

I have a SQL 2008 Standard server on full mirror (safety). I reorganize all indexes weekly. I am looking into rebuilding a few indexes to improve performance. I ran DBCC SHOWCONTIG on my largest, most ...
0
votes
0answers
35 views

Generating dynamic table CREATE and iterative INSERT INTO script in TSQL?

I'm starting to create a dimensional database for BISM development using tables and views from a relational database on the same SQL instance. I've been looking for a way to dynamically generate ...
0
votes
0answers
44 views

Linked Server for MultiSubnet AG Listener

How do I create a linked server for an AG Listener that is in a multi-subnet configuration? I have a couple clusters that need to be able to query the listener at hand but the node that is on the ...
0
votes
0answers
63 views

SQL Server timeout expired in amazon RDS

Recently after i switch my db from amazon EC2 instance to RDS instance, my web application keep receiving timeout error for every 5 - 10 minutes. Timeout expired. The timeout period elapsed prior to ...
0
votes
0answers
53 views

SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?

I've been attempting to learn how to set up Service Broker through Microsoft's "Completing a Conversation in a Single Database" tutorial. However, when I actually try to send a message, it fails until ...
0
votes
0answers
39 views

SQL Server A network-related or instance-specific error

I have a windows service that performs a lot of hits to database. Sometimes the database connection is down and I got exception "A network-related or instance-specific error". I got this behavior on ...
0
votes
0answers
50 views

SQL Server Mirroring send/receive ack time not normal

I have a problem that arises during the performance test by microsoft team in my client. The report that is given to us provide information about whether or not a parameter is good based on the Object ...
0
votes
0answers
8 views

Unknown _TransactionIndex table in Azure SQL Database

Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}" It has 1 column, Id, that contains 8 GUIDs. Couldn't find any information about this ...
0
votes
0answers
38 views

unclear SQL Server Issue

I'm attempting to determine root cause for an issue that caused an outage for my company. Essentially the site connections to our database server were timing out after not receiving a response for ...
0
votes
0answers
43 views

linked server to a network csv file

I am trying to create linked servers from SQL 2000 and 2005 to a network share csv file. I am using Microsoft Jet 4.0 OLE DB Provider with "text" as the provider string. With regards to security, I ...
0
votes
0answers
17 views

dbcc shrinkfile not reducing size of log file in sql server 2008

I am shrinking log file of SQL Server 2008 R2 database, but it is not working. I was using this code: ALTER DATABASE [database] SET RECOVERY SIMPLE DBCC SHRINKFILE(DATABASE_LOG, 20) ALTER DATABASE ...
0
votes
0answers
33 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
0
votes
0answers
24 views

Error in configuration sql server replication

I am configuring replication for a sql server 2005 on win server 2003. I get this error: TITLE: New Publication Wizard SQL Server could not configure 'aaaa' as a Distributor. ...
0
votes
0answers
51 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
0
votes
0answers
18 views

Bring relevant results based on an input search query - full text search?

The database contains information about businesses : title,name, categories, services, description ... to bring the relevant businesses to the user according to his search query I'm thinking about ...
0
votes
0answers
32 views

Schema & Database Role Permissions Issue

I have a Schema and a Database Role. An Active Directory member is added to the Database Role. I grant the Role Select permission on the Schema. Control permission is denied on this Schema. However, ...
0
votes
0answers
110 views

SQL Server backup/restore between systems with different storage sector sizes

We have a system where we create template databases and back them up and distribute them to customers. We recently upgraded our 'build' server to use SSD with a 512 sector size and received an error ...
0
votes
0answers
73 views

How to setup subscription to publication for SQL Server replication to SAP HANA?

I previously posted on stackflow.com and was told to post here. Here is the original post if you're interested: ...
0
votes
0answers
41 views

SQL Server 2012 Profiler - ShowPlan XML Batch ID

I have an application that makes RPC calls for a single procedure, most calls run in a few miliseconds. Occasionally the call takes 5-7 seconds. I'm trying to catch an execution plan for one of the ...
0
votes
0answers
169 views

SQL Server: Principal DB becomes unavailable after problem with mirror DB, even with Set Partner Safety Off?

We've got a very simple mirroring setup here: just a principal DB and mirror DB, no witness, running in high-performance mode with SET PARTNER SAFETY OFF. This problem has happened to us twice now: ...
0
votes
0answers
36 views

Is it possible to auto generate ALTER scripts for differences between existing DB and updated schema?

I built a internal web application for a client that manages applications to programmes for their employees. The system is Classic ASP on a set of clustered and load balanced Windows 2000 Servers ...
0
votes
0answers
129 views

SQL Server 2012: Login failed for user. Reason: Failed to open the database configured in the login object

Every so often, my SQL Server 2012 throws the following errors: Error (likely related to the one below): Source: spid99 The client was unable to reuse a session with SPID 99, which had been ...