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
90 views
Troubleshooting Database Mail issues and Service Account permissions in SQL Server
I am having difficulties troubleshooting a Database Mail issue. When I try to stop and start the service using sysmail_start_sp and sysmail_stop_sp, I see a critical error in the Administrative Logs ...
1
vote
0answers
40 views
INSERT BULK in SQL Profiler without values
I started SQL Profiler to catch actions that are doing on server, and among them I found one row where is stated:
SQL BatchStarting: insert bulk table_name <column_list>
but there is no ...
1
vote
0answers
38 views
Will Startup Procs Run Again After Database Recovery?
We have a number of stored procedures that run on startup via the sp_procoption startup:
exec sp_procoption 'ProcName', 'startup, 'true'
A customer's server started up with a very large database in ...
1
vote
0answers
44 views
Migration advice from SQL server 2000 bak
A small and old Windows 2003 server, just crashed; from the backup only the .bak files are available.
A new server will be built, however, as the database is very small (20MB) and the Windows server ...
1
vote
0answers
165 views
Efficiently retrieve big amount of data based on date range
Table EVENTS
TimeStamp |O.Name |Location |Source |
2008-11-12 |Pretorian|Európe |England |
2009-12-24 |Lex Rosa |Európe |Italy |
2010-01-01 |Nasdaq |USA |Whasington |
...
1
vote
0answers
394 views
The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline
SQL Server service restarted/stopped, which cause the production database down n find this errors in System log.
ERROR5:The Cluster service failed to bring clustered service or
application 'SQL ...
1
vote
0answers
79 views
SSMS produces error if query returns too many rows
We are having an issue with a server that we linked to our sql server 2012 instance.
The server that we linked through an odbc or oledb connection is Pervasive SQL.
Selecting from the linked server ...
1
vote
0answers
206 views
How to return all values from a stored procedure casted as varchar(max) in sql server due to PHP mssql_query() ntext issue?
This is more of a concept/how-to question rather than about actual code. I can do the programming but I just need to know what direction to head... I was going to post this on StackOverflow but it's ...
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
302 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
89 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
172 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
469 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
86 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
160 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
105 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
234 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
69 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
49 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
220 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
96 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
38 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
111 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
58 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
79 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
105 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
40 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
179 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
278 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
257 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
272 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
192 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
833 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
113 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
128 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
98 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
307 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
194 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 ...
