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).
1
vote
0answers
31 views
when can AG primary replica be a different host to WFC primary?
To set up an Availability Group with two servers, the servers both participate in a Windows Failover Cluster.
I've seen cases after certain failover modes where the primary IP address in the cluster ...
1
vote
0answers
290 views
Missing 'Microsoft Office 12.0 Access Database Engine' in SSMS
I've got several users that need to import / export ACCDB Access files into out of SQL Server.
Unfortunately, I have been unable to get 'Microsoft Office 12.0 Access Database Engine' to show up as a ...
1
vote
0answers
87 views
Best Practice to update columnstore indexed tables
I have a table with aprox. 22 Bn rows, for each month I have made one partition that and each partition has two data files. I created the columnstore index on this table and the performance ...
1
vote
0answers
38 views
Query Regarding Database Instance not proper
Please sort out one issue regarding SQL Server instances. I have one instance of SQL Server named 'Test\Connect' and other one is 'local' by default.
So the issue is when I connect to local and ...
1
vote
0answers
170 views
Network issues with sql server
There are two servers on co-location. First is Windows Server Standard 2008 R2 SP1. Second is Windows Server 2012 + Sql Server Standard 2012 SP1.
First server has a task with a report against tables ...
1
vote
0answers
465 views
Unable to open BCP host data-file error
Having problem using BCP via xp_cmdshell.
I exported the table data to a file as .dat but when I try to import the file to a new table, I am getting the below error. The SQL Server service and the ...
1
vote
0answers
85 views
SQL Server: Powershell to dump database as SQL Beginner Issues
I want to be able to dump a database to a sql text file using Powershell. I want this because our DBAs want to be able to do a diff on the file that is committed to SVN. They won't execute it if they ...
1
vote
0answers
159 views
Cannot remove .bak file
I have a java application that:
Reads a .bak file from a windows fileshare and restores it in SQL Server on a remote windows server
Does various modifications on the database restored from the .bak ...
1
vote
0answers
68 views
Distribution Agent running but subscription does not exist?
I have an issue where in my replication topology, the distribution agent is running, and says there are no commands to distribute. However, checking the undistributed commands, it shows there are a ...
1
vote
0answers
99 views
SQL Server BCP imports, but table still has 0 records
I ran the following command from the command line on SQLServer 2008 R2
BCP C4L.dbo.districts in C:\TEMP\districts.sdf -f C:\TEMP\districts_import.fmt -T'
No errors were reported and it ran as ...
1
vote
0answers
223 views
How do I configure SQL Server 2012 so that it can restore and see files in my user account?
I have an SQL Server 2012 instance running as a service on my computer, and according to the service page it logs on as account "NT Service\MSSQLSERVER". However I can't see that account name ...
1
vote
0answers
68 views
SQL server Load Balancing
SQL server user access cut down from 8pm - 9am.
During this period our SSIS scripts would run to load data(from Oracle/mainframe/Access) to sql, large database(s) & too much data - mortgage ...
1
vote
0answers
43 views
Input requested on localization setup for DB
I am building an ASP.Net site that will pull dynamic data from SQL server. The site will be built with localization/globalization foundations in anticipation that in a year or so the site will start ...
1
vote
0answers
48 views
More logical Reads Than allocated Pages using Columnstore Index
I took a script from web to demonstrate column store index. It creates a table and inserts test data.
use adventureworks2012;
go
drop table sales2;
create table sales2 (
[id] int not null ...
1
vote
0answers
55 views
How To Use Publication Without Precompiled Partitions
I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work.
The merge agent is slow to do ...
1
vote
0answers
204 views
How to install legacy data transformation services in sql server 2012
I have installed SQL Server 2012 but I'm not able to see data transformation services in Management > Legacy option.
This option is available on SQL Server 2008 R2 on default installation.
Is ...
1
vote
0answers
95 views
MS SQL to MySQL Conversion
Is there a tool available that converts queries written as triggers, stored procedures and functions written in MS SQL 2008 to MySql? We switched databases and now I need to rewrite a bunch of queries ...
1
vote
0answers
37 views
i want to modify Redgate source control Git.xml file to include commit and push
Below is an excerpt for the git.xml file in redgates source control
<element>
<key type="string">Commit</key>
<value version="1" type="GenericHookCommand">
...
1
vote
0answers
110 views
SQL Server merge replication (subscription does not exist)
I have setup a merge replication for almost 21 servers. Everything was OK, but after few days all subscriptions failed.
In the subscription servers, although I have subscription in the subscription ...
1
vote
0answers
56 views
What permissions are required to view the contents of a catalog on a remote server?
I defined a linked server from a SQL Server box to a MySQL box. I went through a very detailed set of instructions and steps, everything works like a charm when I am logged in.
The linked server ...
1
vote
0answers
133 views
Multi-Table Join to Single Destination
I am having a serious performance issue with join together four tables and placing the results (in a certain permutation) into one destination table. I am using MSSQL 2008 and good ole T-SQL.
To ...
1
vote
0answers
78 views
Pull replication stuck on Microsoft SQL Server 2000. What is the safest way to get it running again?
I believe the steps necessary would be:
Generate scripts to "create or enable" (including replication jobs) by right clicking the subscription in question in "local subscriptions" and saving the ...
1
vote
0answers
104 views
SQL Server Browser keeps stopping on the server
I've built and installed a SQL database and client application. It all works well generally, but intermitently (normally first thing each morning), the client application reports an Error 26 - error ...
1
vote
0answers
39 views
Records are discarded if parent dimension refers to a child record that doesn't exist.
I stumbled upon the following issue in SQL Server Analysis Services (SSAS) When processing a Cube database.
I have a dimension that has sub dimensions, however if the parent record refers to a child ...
1
vote
0answers
176 views
SQL Server 2005 Memory Pressure
We keep having a nagging problem with our SQL Server. I don't know what changed, but we started having out of memory errors every 3 weeks or so.
I thought I could locate something strange with DBCC ...
1
vote
0answers
275 views
SQL Server Database Engine Tuning Advisor vs DMV queries
What is the best way to tune the indexes on my production database? I normally use the following query :
SELECT
user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) AS [index_advantage],
...
1
vote
0answers
252 views
SELECT value from database over ODBC wont reach the software
SQL Server 2008 R2 latest updates.
SQL server ODBC driver version 6.01.7601.17514
PS!!! native drivers are incompatible with the software so i cannot use them.
I cannot edit or change the server ...
1
vote
0answers
269 views
SQL Server Database Mirroring : strange client application behavior upon failover
I am putting a HA SQL server environment up based on three SQL Server 2008R2 machines and database mirroring.
I'll name them :
principal.company.intra
mirror.company.intra
witness.company.intra
...
1
vote
0answers
189 views
Pros/Cons of Using Table/Index Partitioning in SQL Server
We have a number of tables that were partitioned primarily to reduce problems when purging data (via sliding-window partitioning / truncate). I have found a number of caveats that come with ...
1
vote
0answers
811 views
Import/export wizard code page error
Using the import/export wizard I end up with an annoying problem:
Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are ...
1
vote
0answers
51 views
How to Remove Articles Based on User
I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks.
I have a filtering scheme that controls which tables end up ...
1
vote
0answers
1k views
Error Authenticating Proxy Account when Executing SSIS job
I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages.
These packages have been running for years and the associated steps run via a Proxy Account ...
1
vote
0answers
110 views
SQL Server Service seems stuck
I'm running a stored procedure and it just doesn't finish. Here are a couple of things I have noticed:
Normally, the procedure takes 20mins but now it's running for over an hour by now.
Normally, ...
1
vote
0answers
120 views
Upgrading Remote Distributor in SQL Server Replication
I'm upgrading my remote distributor from 2005 to 2008r2, it is performing transactional replication only. this is a prerequisite to completing an upgrade of the Publisher to 2008r2.
Script ...
1
vote
0answers
47 views
Replication Fails due to Warning
I'm getting the following warning when executing usp_ReplicationMonitor within a job:
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
A ...
1
vote
0answers
125 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
1
vote
0answers
19 views
How to tell what user has synced
I have set up merge replication web sync to sync a publication from a SQL 2012 database.
I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME().
When I do a sync is it ...
1
vote
0answers
96 views
How do I use MDX scripting in SQL server 2005 Business Intelligence Development Studio to create the following Member?
I am using Microsoft SQL server 2005 Business Intelligence Development Studio to build a cube.
I need to calculate a member called INCREMENTAL OVERTIME. INCREMENTAL OVERTIME is based off of the ...
1
vote
0answers
1k views
SQL Server Rebuild/Reorganize Fragmented Indexes causes CRC error or consistency errors
In our test lab I've been experimenting with different jobs to keep our critical indexes from becoming too fragmented.
I'm currently using the approach described here: sys.dm_db_index_physical_stats ...
1
vote
0answers
306 views
Moving database to another SQL Server instance
I have an old database running on compatibility level 6.5 on a SQL Server 2005 instance.
The support for compatibility level 6.5 has been deprecated as of 2005 and removed on 2008.
The place where I ...
1
vote
0answers
134 views
Sort a non-grouped (SUM) column in descending order
I have a SSRS Report that contains 3 columns: Asset, Project Type and Total Hours. Report is grouped by first level grouping on asset and second level on Project Type. For example, clicking on Asset ...
1
vote
0answers
54 views
Tool to list down resultset from SQL Server for bulk data
I have many records with me for which I need to query the database. How can I write a query that can list down all the resultset at once using my large set of data?
The database that I used in SQL ...
1
vote
0answers
192 views
some SQL Server MSX targets show as Normal, Blocked
I've centralized my farm's jobs in MSX, covering about 70 instances of SQL Server. Seemingly randomly, at least once a week, several instances will stop accepting instructions. Within the MSX window ...
1
vote
0answers
236 views
Keep original column names in SSRS report designer 3.0?
I have queries returns a lot of (over a hundred) columns which names contain important underscores, >, < and Uppercase/lowercase characters. However, when creating the reports, SSRS designer (3.0) ...
1
vote
0answers
135 views
Found errors in table after executing DBCC CHECKTABLE command
I am trying to alter table to add primary key
ALTER TABLE GeoCity
ADD CONSTRAINT PK_GeoCity
PRIMARY KEY(locId)
and got this error message
Msg 1750, Level 16, State 0, Line 1
then I run ...
1
vote
0answers
390 views
Why is the next scheduled run date for my SQL Server job NULL?
I've been dealing with the Microsoft SQL Server Agent with regards to scheduling jobs.
I'm trying to find out what the next scheduled run date for a bunch of jobs that were created where the job ids ...
1
vote
0answers
64 views
Permon counters on SQL 2005 mirroring (user defined counter log file is empty)
I've been attempting to gather performance counters for mirroring using perfmon, over a period of time and saving this to a log file. I am able to do this without problem for general SQL Server ...
1
vote
0answers
85 views
Managing SQL 2008 database
We have a vendor application that creates a new database monthly for only few tables. Vendor doesn't have solution. Is there any other way besides partitioning as partitioning require enterprise ...
0
votes
0answers
68 views
how to find similar word with more similarities
how to Find words with length less than or equal....
declare @inp nvarchar(max),@data nvarchar(max)
set @inp='You can dance, you can jive, having .... jove... jve, ...'
set @data = 'jeve'
...
0
votes
0answers
30 views
SSMS 2012 error message: evaluation period expired despite Edition Upgrade
Problem similar to this one only with SQL Server 2012. None of the suggested registry edits have worked. This problem was supposed to have been fixed back in 2008 SP1.
Here's the sequence of ...
