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
240 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
136 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
401 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
67 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
7 views
How do I deal with FK constraints when importing data using DTS Import/Export Wizard?
I am trying to use the SQL Server Import and Export Wizard to copy data from my production db to my dev db but when I do it fails with the error "The INSERT statment conflicted with the FOREIGN KEY ...
0
votes
0answers
18 views
XML data source with XSD validation importing the same data despite different files
Please bear with me, I've never used XML as a data source, nor am I familiar with XML itself, so I'm not entirely familiar with the nomenclature.
I have a series of XML files with data to be imported ...
0
votes
0answers
43 views
Copy tables from a stand-by database
I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
0
votes
0answers
79 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
32 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 ...
0
votes
0answers
80 views
DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS'
I have inherited a few scripts that are pumped through a c#.NET custom app to update a SQL2005 SP3 database. One of these scripts does a deletion on a user table called msw_timer_task, based on a ...
0
votes
0answers
56 views
Table Constraint causing deadlock
I have a table. When two transactions are inserting a large no of rows into table grid I am getting a deadlock due to INSERT/SELECT. So INSERT query has X lock on clustered index but since i am doing ...
0
votes
0answers
26 views
Displaying Hexadecimal Characters in Reporting Services Report
How do I properly display hexadecimal characters in an SSRS report?
These characters: http://www.htmlhelp.com/reference/html40/entities/special.html
E.g., “ should display as left double ...
0
votes
0answers
35 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
0
votes
0answers
105 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
0
votes
0answers
30 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
0answers
31 views
How to bind contract to service?
I have a service broker setup where server A is updating server C with no problem. I now need to add another service broker setup where server B also updates the same database on server C.
When I ...
0
votes
0answers
14 views
Monitor For Disabled Queue On RDS SQL Server
I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue is occasional resource contention. Until we solve it, monitoring would help us be aware.) In my ...
0
votes
0answers
58 views
Converting data from MSSQL Server to MySQL using MySQL Workbench and preserving special characters
I am trying to convert a MSSQL Server database with collation SQL_Latin1_General_CP1_CI_AS into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being ...
0
votes
0answers
50 views
SSIS Data Flow Task Slows Down
I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
0
votes
0answers
28 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
0answers
38 views
sql server 2008 error in working
I have Windows 7 professional and SQL Server 2008 Standard
In management studio when press connect it shows this error
( A network-related or instance-specific error occurred while
...
0
votes
0answers
77 views
best way to copy data from MSSQL db to MYSQL DB(remote)
I currently copy data between my local SQL Server to a remote MySQL database linking in SQL and doing a data transformation task but now I'm sending lots of data it is getting very slow.
Just after ...
0
votes
0answers
44 views
Linked server performace issue?
I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
0
votes
0answers
68 views
SSRS email subscription fails intermittently with “The e-mail address of one or more recipients is not valid”
I have an SSRS server sending mail via smtp to a list of users.
These are all internal users with email addresses of the form user.name@example.com
An email subscription run at 18:05 used to work, ...
0
votes
0answers
52 views
Insert performance deterioration over network
i have a strange issue with a windows application (in delphi) running on a win7 client.
The application has a loops and inserts rows on a SQL Server table.
It's simply an insert statement, repeated on ...
0
votes
0answers
58 views
SQL Server Internal Memory Pressure
I am trying to identify the cause of internal memory pressure. From what I have learned, Resource Monitor Ring Buffer returns an indicator for internal pressure. For example by using this query,
...
0
votes
0answers
37 views
Huge sizes Replication Tables in Sql Server db, how to deal with?
I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.
the DB size dramatically increases.
When i ...
0
votes
0answers
43 views
Invalid Object SQL Server 2005 Express
I have 2 SQL Servers, let's call them A and B. I have a ColdFusion app that runs on server A. It connects to my database, MyDb. I needed to update the db content so I backed up the same db on server B ...
0
votes
0answers
54 views
Cannot start SQL Server service on SQL Server cluster
I have a SQL Server 2008 cluster with 2 nodes. I rebooted both machines and now I CANNOT start the SQL Server service from:
Node1 or
Node2 or
ClusterSQL (the cluster SQL Server)
I am getting an ...
0
votes
0answers
29 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
45 views
Deadlocks in Small Table
Our application is seeing deadlocks while inserting records into a table shortly after installation, while the table is small. These deadlocks eventually go away as the table fills up.
The ...
0
votes
0answers
44 views
RESTORE DATABASE is terminating abnormally
I want to restore the database
My current query is
Use master
DECLARE @ErrorMessage NVARCHAR(4000)
ALTER DATABASE [dummydata] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
BEGIN TRY
...
0
votes
0answers
23 views
Ghost replication jobs in replication monitor
Has anyone ever seen and know the cause of this issue? We have transactional replication with pull subscriptions. At 2am this morning it appeared that the job (that runs every 15 minutes) stalled out. ...
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
0answers
72 views
How to represent class table inheritance (current DBMS-specific way please)?
I want to implement class either-or table inheritance (Account, CatAccountDetails, DogAccountDetails) in SQL Server.
I found a recommendation for MySQL here (How do I map an IS-A relationship into a ...
0
votes
0answers
31 views
Full-text search index size
Is there any analysis about this topic? For example what is the estimated index file size of 1 GB .txt files?
0
votes
0answers
57 views
Are there any good open source tools for DB objects end user manipulation?
I've been recently tasked to provide some object adjustment features for our end users, simple thing like changing the value of two or three fields in some specific business know tables without the ...
0
votes
0answers
87 views
SQL Server link to linked server
My client has a Visual FoxPro database that needs to co-mingle with SQL Server data (SELECT only, no updates or deletes).
After quite a bit of searching I found the VFP OLEDB provider doesn't work ...
0
votes
0answers
67 views
What are my options for building a SQL Server lab in cloud?
There is an excellent post by Jonathan on SQLSkills detailing setup of a completely free SQL Server playground locally using VirtualBox and Windows/SQL Server evaluation editions. I am planning on ...
0
votes
0answers
41 views
Risk of xp_cmdshell
What are the risks associated with enabling xp_cmdshell?
Is it true if a person can execute xp_cmdshell, then he can perform any task on that machine regardless of administrator privilege? Can a sys ...
0
votes
0answers
107 views
FOR UPDATEor INSTEAD OF UPDATE Trigger?
I am working on my project at university - database in MS SQL Server for some sort of travel agency.
I would like to create a trigger to check if I can add another reservation for specific Holiday ...
0
votes
0answers
80 views
SQL Server connection failed for domain user from Mac OS machine
I have SQL Server 2008 R2 SP1. I am using connection string to connect to SQL Server.
In connection string I am passing the driver path, server name, TCP port number, user name with which I want to ...
0
votes
0answers
287 views
SQL Server 2012 SSIS\SharePoint Kerberos auth
I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =)
GOAL:
Use Kerberos to avoid double-hop issue.
USAGE:
User logs onto ...
0
votes
0answers
28 views
tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER
i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
0
votes
0answers
57 views
Migrate PostGIS geometry data to SQL Server spatial data
I am trying to migrate PostGIS geometry to SQL Server Spatial data. Which ETL I have to use?
It's the first time I'll work with SQL Server spatial features.
Thanks for any help
0
votes
0answers
59 views
How to model Week Commencing / Week Ending scenario
I’m reasonably new to data warehousing and I’m struggling to get a feature of my time dimension working. I’d like to model a Week Commencing and Week Ending type of scenario.
I’ve created a DimTime ...
0
votes
0answers
45 views
RedGate Data Compare without reregistering tables
I am using the RedGate Data Compare tool and set up all my tables with the settings I want to use. This took about 4 hours. I want to be able to use these settings for different DBs but when I select ...
0
votes
0answers
536 views
0x84BB0001 Error when installing SQL Server 2012. Could not create a handshake
I have hopelessly attempted to install SQL server 2012 onto my 64 bit Windows 8 machine.
The database engine always fails to install with error 0x84BB0001. Native reporting also fails, I reckon from ...
0
votes
0answers
46 views
bad to assign specific processors to SQL Server 2008 R2 cluster instances?
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
