The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

4
votes
1answer
97 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
2
votes
1answer
38 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
2
votes
1answer
247 views

NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?

I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
2
votes
0answers
255 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
1
vote
0answers
251 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
1
vote
0answers
46 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
0answers
155 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
1
vote
0answers
30 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
1
vote
0answers
141 views

How to set up Openfire XMPP server?

I have installed Openfire and Microsoft Sql Server Management Studio 2102 on my PC. I have made a database called openfire, conected to it, and have executed the script called openfire_sqlserver.sql ...
1
vote
0answers
82 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
1
vote
0answers
234 views

Change language of error messages in Windows 7 x64

My Windows 7 installation had Russian localization. When I encountered errors, I thought to translate the errors to Google into English. I decided to change the display language to English. In ...
1
vote
0answers
161 views

View numeric columns in hex - SQL Server Management Studio

In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
1
vote
0answers
264 views

Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8

I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
1
vote
0answers
47 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
1
vote
0answers
155 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
0answers
3 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
0answers
32 views

SQL Server Data Input

I am new to SQL databases. Due to the huge data that I am dealing with I decided to create a SQL server. My data is mostly in the format of index_1(text) index_2(text) index_3(text) ...
0
votes
0answers
27 views

Unable to uninstall SQL Server 2008 R2 on Windows 7

I'm trying to uninstall SQL Server 2008 R2 on a Windows 7 machine. I keep getting this error message: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\sqlcab.dll ...
0
votes
0answers
17 views

Unable to Create Linked Servers using SSMS on SQL server 2008 R2

I am unable to create or view properties of the Linked Servers from SSMS on SQL server 2008 R2 and the error appears "cannot find table 0. (System.Data)" also the providers are not being displayed ...
0
votes
0answers
51 views

SQL Server 2008 (64-bit)

I have transaction log backup failures randomly. SQL Server Log says: Memory constraints resulted reduced backup/restore buffer sizes. Proceding with 6 buffers of size 64KB.', and the SQL Server ...
0
votes
0answers
31 views

Duplicate SQL Server Database with Access Front End on Remote Machine

I used the SQL Server Migration Assistant to move an Access back end to SQL Server 2008. I tested it on my SQL Express, but actually did the migration via terminal server on my client's machine. The ...
0
votes
0answers
117 views

Windows server 2012 becomes slow

I have a server with following configurations. This is new IBM X3630 M4 server established before one month. Processor : Quad core Xeon E5-2620v2 single processor RAM : 8 GB NIC : 2x 1GbE HDD : ...
0
votes
0answers
17 views

How do I nest sp_msforeachtable in sp_msforeachdb?

Essentially I'm trying to select the top 100 rows for each table in each db on the server I could accomplish that using a cursor and metadata tables I guess, but can this be accomplished using the ...
0
votes
0answers
14 views

SQL Server User-based CPU Limit

30 clients connecting to server through rdp. They are using an Accounting Software. This causes SQL Server uses too much memory. Is there any way to limit the CPU in the user-base, rather than ...
0
votes
0answers
71 views

How to do a cross apply in MS Access?

I have a cross apply query that I wrote in the SQL Server Mangement Studio where I can't seem to figure out how to write the same query in MS Access. I know how to do a GROUP By in MS Access the ...
0
votes
0answers
15 views

SharePoint 2007

MSSQL management studio 10.50.1617.0 Microsoft Data Access Components 6.1.7601.17514 Farm Information Version : 12.0.0.6421 Sharepoint 3.0 Central administration. Exception from HRESULT: ...
0
votes
0answers
28 views

Fix/Reinstall SQL Native Client?

Don't know what happened but on my Windows 7 64bit the connection to SQL2005 using SQL Native client is not working anymore. More in detail, if I try to connect to the SQL server using oledb it works ...
0
votes
0answers
18 views

Monitoring SQL Server Log Shipping with multiple secondaries

I've seen the Transaction Log Shipping Status Report on SSMS, and i'm wondering if there's anything to monitor Log Shipping with multiple secondaries.
0
votes
0answers
47 views

Shift+Tab Loses Alignment in SQL Server Managment Studio 2012

Issue #1: I'm using the following for demonstration purposes: SELECT A.Field1, B.Field2 FROM TableA as A JOIN TableB as B ON B.ID = A.ID WHERE A.FieldA = 'A' AND B.FieldB = 'B' GROUP BY ...
0
votes
0answers
29 views

Free Source Control for .sql files to run alongside SSMS

Does anyone use source control for there .sql files? My job revolves around a suite of approx 75 stored procedures in sql-server. I'm now sharing the development of these files with a colleague. ...
0
votes
0answers
58 views

SQL Server 2005 Express connection

On my computer I had installed Windows XP Service Pack 2. Then I installed Visual Studio 2008 SP1 and then SQL Server 2008 r2 and SQL Server 2005 Express. Up to that I had no problem using SQL Server ...
0
votes
0answers
95 views

BDE Administrator closes unexpectedly when open database

I don't know what happened on my Windows XP Home system for doing this, always worked perfectly but now when i try open a database the DBE Administrator closes unexpectedly without showing any error. ...
0
votes
0answers
153 views

Invoke-Sqlcmd not working after PowerShell 4 install

I installed PowerShell 4 yesterday and ever since then, I get the error "The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function". This has been working just fine for months ...
0
votes
0answers
20 views

Trying to install SQLExpress tools goes nuts, attempts to install Ati Radeon driver

This applies to all of the downloads with tools, the database itself isn't the problem. Attempting to follow what's going on I find it unpacking itself into a directory on the drive with the most ...
0
votes
0answers
281 views

How to install Mahout on Windows 8.1?

My goal is to build up a recommendation system and after going through many articles, I came across Mahout as a simple, yet effective way to go on. I already have XAMPP installed on my system. How ...
0
votes
0answers
182 views

How can I access my home MS SQL Server DB from a remotely hosted web service?

As can probably be seen (if not already see below) I am fairly networking illiterate. Here is what I would like to do: Setup a SQL Server DB hosted on a computer I have in my home. I want to be able ...
0
votes
0answers
475 views

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

I'm working with a virtual machine on Windows 8. There is a SQL Server 2008 on the virtual machine. And in the services, when I try to start the SQL Server service I am getting an error like this:
0
votes
0answers
71 views

OTRS and MS SQL Server

I'm installing OTRS Help Desk for our organization. We're installing the application on a CentOS server but would like to connect to a Microsft SQL Server database. However, I was not able to install ...
0
votes
0answers
20 views

SQL Server and Windows 2008 Firewall rules

I have SQL Server Express 2008 installed on a Windows 2008 R2 box. There is a 3rd party application which needs to access SQL Server over the network. For some reason, the app is unable to do this, ...
0
votes
0answers
114 views

TFS 2012 Backup configuration fails. “TF400998: The current user failed to retrieve the SQL Server service account information”

I'm at a loss with trying to find a solution to this issue. When I am trying to create a backup plan in TFS 2012 I get "TF400998: The current user failed to retrieve the SQL Server service account ...
0
votes
0answers
16 views

Why must I add SSMS to Firewall to be able to connect as CLIENT

This issue is confusing me very much. I am connecting to a remote SQL Server (through VPN) and was unable to connect to it at all until I disabled the windows 7 firewall. I didn't want to ...
0
votes
0answers
26 views

How to setup a unix-based MySQL database to be accessible remotely?

Please forgive my likely noob question, but I am new to SQL in general, and am having trouble configuring my server. Background -- I have a mysql server running on unix. I formatted a database using ...
0
votes
0answers
40 views

How to cancel all sql server jobs without starting ms sql server process

I am using ms sql server 2012, at the midlle of huge query execution, my system crash so i decided to end task ms sql server process. Now, each time i want to start ms sql service my system crash ...
0
votes
0answers
69 views

SQL Server Data Tools Explore Data error

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header ...
0
votes
0answers
199 views

VS2010 Program won't connect to MYSQL from local SQL Server Computer

my problem here is very weird compared to other that I found on this forum. The VB program is created with VS2010 from computer "A". It work perfectly. Connection to SQL Server and MYSQL DB. But when ...
0
votes
0answers
238 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
0
votes
0answers
34 views

Pause VM when SQL server idle

In OSX Mountain Lion, I run a Windows Server 2003 VM solely to run SQL Sever 2008. It chews up a lot of battery life. Is there some way to automatically pause the VM when the SQL Server is idle and ...
0
votes
0answers
1k views

Cannot connect to SQL Server from another PC

I am using windows XP SP2 and SQL Server 2000. I can successfully connect to a database from the host computer via 127.0.0.1 and also with the local IP (which is 192.168.1.6). But when when I try to ...
0
votes
0answers
702 views

SQL Server 2008 forgets my login and password

For some reason SQL Server 2008 (Management Studio) refuses to remember my username and password for a specific server instance even though I've checked "remember password" probably hundreds of times ...
-2
votes
0answers
6 views

Please can anyone tell me how to install senaya library system in online server?

Please can anyone tell me how to install Senaya 7 Library System in online server? I want to grant a certain rural school a certain help by providing them senaya library management system but i failed ...