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

0
votes
1answer
335 views

Visual Studio 2013 + Business Intelligence SSDT and missing Reporting Server templates

The other day I have installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: Replacement for BIDS) and started using reporting features in VS2013. However, ...
0
votes
0answers
32 views

Change SQL server back to a trial

I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial. What are the steps to do this? REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
1
vote
1answer
138 views

Migrate SQL Server 2014 Enterprise to new machine

We had Bizspark, which we are now graduates of. As I understand from the Bizspark page: You can keep, at no charge, all the software you downloaded, including a standard configuration of Windows ...
0
votes
0answers
30 views

Microsoft SQL: dealing with invalidated databases

I created a Microsoft SQL Server database that has now changed location. (The details are probably unimportant, but for the curious, I originally created it in a folder on an external drive mapped to ...
0
votes
0answers
37 views

SQL Server Error

I am getting the following error: Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Base Unit of Measure " returned status value ...
0
votes
0answers
73 views

Equivalent to VirtualBox Oracle dev environment available for SQL Server?

Oracle has this wonderful option in VirtualBox where you can download a virtual Linux machine that is setup with SQL tools and a running instance of Oracle. This setup makes it much easier to test or ...
0
votes
0answers
12 views

Business Intelligence for VS2013

I have a small dilemma/issue right here, I've installed this http://www.microsoft.com/en-us/download/confirmation.aspx?id=42313 in order to use Reporting Services with my SQL Server 2014, but when I ...
0
votes
1answer
155 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
0
votes
0answers
14 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
9 views

Programmer's guide to Server Resource Usage Report [closed]

I have ASP.NET MVC 5 Application running on a Windows Server 2012 and a Database Server running SQL Server 2012 on Windows Server 2012. I am trying to get a report on the Resource usages of these ...
-1
votes
1answer
52 views

SQL server not able to stop on windows 8 … please help … using sqlserver 2000 on windows 8 home

I am currently using a software which is dependent on SQL server 2000. However whenever i try to exit the program and try to stop the SQL server i get a message-- An error 5 (access denied) occurred. ...
3
votes
4answers
10k views

Clean reinstall SQL Server Management Studio

I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well. Then, I installed ...
0
votes
2answers
810 views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
1answer
46 views

Sql server 2012 process reaches 2 GB of memory in one hour if open Management Studio

I have strange situation with Sql Server 2012. If I open Management Studio 2012 (11.0.2100.60) and make some query on a table, the process sqlservr.exe reaches 2 GB of RAM memory in one hour. It ...
0
votes
0answers
377 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
80 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 ...
2
votes
1answer
181 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 ...
0
votes
0answers
130 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
1answer
269 views

Logging on to SQL Server from a Windows 8.1 PC over a VPN

I currently work remotely (new position) and am logged into my Windows 8.1 development machine with my Windows Live account. I can connect to our corporate LAN via VPN but can not access SQL Server ...
0
votes
0answers
109 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 ...
3
votes
2answers
2k views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
0
votes
0answers
510 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 : ...
1
vote
4answers
91 views

Will the Microsoft SQL transaction log by default be enabled during install?

I was asked this question in an interview? Does it depend on version of the server or is it always same (enabled or disabled by default)?
0
votes
1answer
343 views

How do I disable automated SQL Server Backups?

SQL Server seems to be doing full backups (.bak) at random intervals then storing them into, C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup Is there an option to ...
0
votes
0answers
48 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
33 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
1answer
62 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...
0
votes
1answer
41 views

How to automatic backup SQL server registered servers?

I have many servers registered. I don't know where this information is saved. After PC rebuild, they are gone. Is there way to schedule task to backup this information?
1
vote
2answers
3k views

Sql query suddenly takes a long time to run

I have an application that is processing lots of items from a sql database. It runs along fine and then after about 4 million items processed it starts hanging up. Using sql server profiler, I ...
0
votes
1answer
2k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
135 views

Installing Sql Server 2012 on Vmware Virtual Server 2008 R2

I have a Virtual Windows Server 2008 R2 set up, I downloaded Sql Server 2012 Evaluation Copy. Now when I try to Install the Sql Server it throws an error, No Error message nothing at all just an error ...
0
votes
1answer
16 views

WEB-INF/web.xml displays mysql credentials?

I found web.xml in /WEB-INF/ on a domain I'm associated with. In said xml file, I see it displays: <database> <jndi-name>jdbc/mysql</jndi-name> <driver> ...
-2
votes
1answer
35 views

How to install MS SQL Management Srudio for SQL Server 2008?

I have downloade SQLManagementStudio_x86_ENU.exe file, but when I run it, it starts global SQL server 2008 installer where I can't find any signs of Management Studio.
0
votes
2answers
1k views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
1
vote
1answer
93 views

Why do I have to manually add Local Activation permission for domain account even if it's a member of the local Administrators group?

A SQL Server 2012 agent job was failing with: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {...} and APPID ...
0
votes
1answer
48 views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
1
vote
2answers
294 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
5
votes
1answer
10k views

Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup

I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode. After the installation, I realized that it had installed SQL Server Express 2008 (10.0.2531.0) ...
0
votes
0answers
172 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
1answer
32 views

Log file viewer not displaying database where error occurred

Something keeps being logged to files located here: C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER\MSSQL\Log Files like these keep getting updated: SQLFT0000700007.LOG 15 errors per ...
1
vote
0answers
536 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. ...
0
votes
0answers
271 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 ...
1
vote
1answer
3k views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
0
votes
2answers
1k views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
0
votes
0answers
154 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. ...
-1
votes
2answers
346 views

SQL Server Database Encryption [closed]

Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...
1
vote
1answer
332 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 ...
4
votes
1answer
206 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 ...
0
votes
1answer
123 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
4
votes
4answers
1k views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...