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
65 views

Finding duplicate data

I have noticed dup’s generated in my mail system. some service was causing duplicate calls to my insert proc and generated multiple duplicate messages with about a 4 mili-second difference in a date ...
0
votes
0answers
86 views

Is there better way to design SQL tables

I need to design a quick application for small warehouse. I just want to check if there is a better design approach. I am using polymorphic associations for comments tables. Business Rules If ...
0
votes
0answers
92 views

Are heterogeneous joins between MS Access and SQL Server tables really so bad?

I'm developing a multi-user Access 2013 application with an Access backend on a fileserver. At first I'm going to finish my stable Access application which works fine for the moment. However, I plan ...
0
votes
0answers
192 views

Why doesn't this transactional replication post script work? (Works in SSMS and SQLCmd.exe)

I have created a script that creates any missing indexes on replicated indexed views. It gets the index definitions from the publisher (Linkedserver) and applies them to the subscriber. The script ...
0
votes
0answers
274 views

Suppressing the removal of trailing zeros in numeric data type in sql server

I initially declared the data type of the columns for some of the tables i am working on as "NUMERIC". cause of that, trailing zeros are being removed. Is there anyway to suppress this behavior? i ...
0
votes
0answers
27 views

Intermittent Connection Speeds SQL Server 2008

We are having issues with a PHP-based application connecting to an SQL Server database on a separate server. It uses a single PHP page to establish the connection using mssql_connect, and this page ...
0
votes
0answers
510 views

Installing SQL Server 2012 failed setup administrator

Can anyone tell me why this keeps failing? I am logged in as "Administrator" on Windows Server 2008 r2 I added Administrator to the "Backup ... " Group And I checked to make sure everything is as it ...
0
votes
0answers
21 views

SQL Server 2008 database is not coming online after restore.. Pleae need help asap

I have restored a 1TB database and now it shows the restore completed 100% but the database is not accessible. sp_who2 has a SPID 50 performing this restore but current command its showing is ...
0
votes
0answers
104 views

SQL Server 2008R2 Developer's Edition Error while Installing

I had Sql Server 2008R2 Developer's Edition Installed on my machine, Two Named instances, Default Instance was Sql Server Express. and there was another named Instance Evaluation Enterprise Edition. ...
0
votes
0answers
76 views

Set max memory lower than minimal

I dont know the best way to fix that, but for lucky now I am using one Transactional Replication Repository server, please someone can save me? The main server is down beacuse I set the max memory to ...
0
votes
0answers
236 views

SQL Server: mirroring several tables in different databases

I want to keep several tables in two different databases mirrored. Both databases are within the same server, and both are SQL Server dbs. This mirroring only affects the data they contain, not the ...
0
votes
0answers
70 views

Enterprise Policy Management Framework Issue

I am attempting to setup and configure EPM to work in our environment. I have all the components in place and when I run the powershell it completes without reporting any errors. However, the only ...
0
votes
0answers
70 views

SQL Server 2008 R2 installation device error

I am trying to install SQL Server 2008 R2 to use along with Visual Studio for a website I am creating. However when I am installing SQL Server I am constantly getting the following error: The ...
0
votes
0answers
994 views

OUTER APPLY vs LEFT JOIN

I'm working on the query bellow. Its structure is based on someone else's similar query... SELECT tptype.Code AS ThirdpartyTypeCode, ptf.Ticker AS TextId, finIn.InternalCode AS ...
0
votes
0answers
102 views

A rollback on a production server that's been running too long

I have a problem with a production server that is causing considerable locking and performance degradation. It all started the night of Tuesday into Wednesday with a procedure that inserts data into ...
0
votes
0answers
47 views

Adding a new partition to the partitioned table is skipping the last filegroup

I have created one partitioned table and trying to add a new partition to that. I ran the following scripts to create a new filegroup and add a new partition to the table. But when I run the alter ...
0
votes
0answers
70 views

sql server 2000: no longer able to expand jobs in sql server agent

In SSMS on a Windows 7 machine, while connecting to a server running SQL Server 2000, I am no longer able to click on the Jobs to see the Object Explorer Details. Previously, this was not an issue, ...
0
votes
0answers
41 views

SQL Server DTC: is it possible to automatically replicate data that is created on Oracle DB?

I have a SQL server with a table that is spec'd exactly like a table in an Oracle database. What I would like to do is automatically copy the data from the Oracle table to the SQL server table... Is ...
0
votes
0answers
97 views

MS Access: ODBC Err 3146 - Timeout related?

I have an AccessDB that queries that appears to function as expected under light loading (i.e., 1-2 users), no errors, SQL Server returns the desired results. We tried to test using 8 concurrent ...
0
votes
0answers
32 views

What is the best way to backup and restore a subset of data within a subset of tables in a sql server database?

I need to be able to periodically backup & restore a subset of data in a sql server database. I only want to backup data in the tables which contain a specific column name - column1 (for example) ...
0
votes
0answers
498 views

SQL query to return a column per date in date range with sum of contract utilisations (value/duration)

My question is similar but more elaborate than another already in stackexchange.com "SQL query to return a column per date in date range?" I have the following data: Customer Start_date ...
0
votes
0answers
327 views

SQL Server Replication Monitor Throwing “Specified cast is not valid. (ReplicationMonitor)” Error

The publisher is running SQL Server 2008 R2 on a Server 2008 R2 box. The subscriber is running SQL Server 2012 on a Server 2012 box. I have tried launching the replication monitor from both servers ...
0
votes
0answers
176 views

When is transaction removed from sys.dm_tran_active_transactions?

We are having some issues with clients getting Transaction Timeout when connecting to our clustered SQL Server 2008 R2. To investigate the problems I have been digging into ...
0
votes
0answers
426 views

LocalDB in Management studio, login failed for Windows Administrator account

When I try to log in to (localdb)\v11.0 from Sql Management Studio (2012).. I get this error TITLE: Connect to Server Cannot connect to (localdb)\v11.0. ADDITIONAL INFORMATION: ...
0
votes
0answers
53 views

Replication failure after old domain controller shut down

We changed domains on our SQL Server 2008 R2 about 6 months ago with no issues while the old domain controller was still up. The old controller was taken down today and our replications started ...
0
votes
0answers
786 views

Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010

I am trying to install SQL Server 2012 Enterprise with SQL Server Data Tools included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL ...
0
votes
0answers
599 views

ssis ado.net destination has failed to acquire the connection

I am Transferring data from sql server source db to sql server destination db (cross db). but some times getting error "ssis ado.net destination has failed to acquire the connection.The connection may ...
0
votes
0answers
36 views

Migrating a SQL NetName Between Clusters

Instance A is a default SQL Server 2005 instance on a two-node Windows 2003 cluster. Instance B is a default SQL Server 2012 instance on a two-node Windows 2008 R2 cluster. The application team is ...
0
votes
0answers
228 views

Powershell Error Handling W/ SQL Restore Jobs

I would like to rebuild many of our SQL scripts into Powershell to further integrate my department with the Windows Operations team and to open up a lot of other options. Questions: 1-preference ...
0
votes
0answers
141 views

SQL Server query result: missing zero before decimal point for -1 < float < 1

I have SQL Server 2008 Express with linked Oracle db. When querying Oracle from SQL Server, I receive for example ,96 instead of 0,96 for float type columns. Any idea how to configure this on ...
0
votes
0answers
134 views

Comparing CLR Functions in Visual Studio SSDT

I'm comparing the CLR functions from a pair of SSDT projects to a database. The only difference shown in the comparison is on two properties: IsDeterministic and DataAccess The compare shows that the ...
0
votes
0answers
53 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
939 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
70 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
57 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
138 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
268 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
209 views

How to convert Excel into Star-schema Model?

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 Microsoft SQL ...
0
votes
0answers
68 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
824 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
170 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
85 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
43 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
130 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
42 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
818 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
76 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
263 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
53 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
330 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 ...