Super User Stack Exchange
Super User Stack Exchange

Questions tagged [sql-server]

Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-server-2008]...

768 questions
37
votes
12 answers

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
Alex Gordon
  • 723
11
votes
2 answers

preserving \n from SQL Server Management Studio

I have a column called EventLog varchar(max) and can be pretty big because essentially it stores the event log of an entire batch process. The problem is that when I go into the query window and do a select like this SELECT EventLog from…
RoboShop
  • 3,576
6
votes
2 answers

Unable to install SQL 2014

When I'm trying to install SQLEXPRADV_x64_ENU i got following error. SQL Server Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001 What is the reason for this? EDIT: I tried to…
DevT
  • 235
5
votes
4 answers

Cannot connect with Sql Server Studio: error 18456, state 8 -- but password is correct

Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to Link, this should be password mismatch. Yet, when I use the…
jlarson
  • 511
5
votes
1 answer

Adding Full Text Search to my existing Sql Server 2014 installation

I have currently SQL Server 2014 installed on my computer (for testing purpose). I need to add Full Text Search functionalities. Then I re-executed the setup but I don't have any Full Text Search Checkbox option on the Feature Selection page (see…
Bronzato
  • 219
  • 1
  • 5
  • 10
3
votes
0 answers

Sql Server does not start after server reboot

I have a SQL server 2012 installed on Windows 2012. The last five times the server rebooted, the SQL server did not start at system startup. When I then log in as administrator, opened services.msc and try to start the "SQL Server (MSSQLSERVER)"…
Alexander
  • 765
2
votes
3 answers

WIndows XP file path in Windows Vista?

I am looking for a SQL Server file I am supposed to delete, only the instructions I found for this are for Windows XP and my OS is Windows Vista. And as ridiculous as this is, I cannot find this file path in Vista: C:\Documents and…
Justin
  • 131
2
votes
2 answers

SQL query suddenly takes a long time to run

I have an application that is processing lots of items from an SQL database. It runs along fine and then after about 4 million items processed it starts hanging up. Using SQL Server Profiler, I traced the problem to a query that jumps from a…
Kevin
  • 139
2
votes
2 answers

how to synchronize local and remote database?

I have a database in SQL server on local computer, we have the same database on remote p.c , i want to sync it with remote server, is there any script for SQL server or any plugin? Thank you. OS: XP-PROFESSIONAL SP3 DATABASE : SQLSERVER 2008…
Great Majestics
  • 129
2
votes
2 answers

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the red circle with the X inside, indicating something…
ingvarius
  • 29
2
votes
0 answers

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). How do I do that? I found many answers on how to…
Jonathan
  • 3,537
2
votes
1 answer

Add data to a database, without physical access to the server machine

I have two computers in a client / server architecture. The server runs SQL Server. The client has to provide an interface to insert data to this database. I know that this can be achieved with Microsoft Access forms but I lack the time to do it. Is…
py_script
  • 336
2
votes
1 answer

Can I achieve DBMS_Application, DBMS_Session, DBMS_Output in SQL Server 2017

I'm looking for alternatives in SQL Server for the below three functions which are currently performed using Oracle. These are the Oracle features we need to use in SQL Server basically: DBMS_Application (Tracing option in Oracle). DBMS_Session…
PAWANMANTHA
  • 23
2
votes
2 answers

Lost or Forgotten SA Password - SQL Server 2016

I installed MSSQL Server 2016 on Windows 10 Home, and created some databases. I then upgraded to Windows 10 Pro, and now since I am logging in to SQL as a different user (old user was local, new user is domain), it won't allow me to access my…
Ben
  • 1,236
1
vote
2 answers

SQL Server CTP installer - The application cannot find one of its required files

I have downloaded the exe file to install SQL Server 2016 CTP4. When I run the exe, it gives me the following message: The application cannot find one of its required files, possibly because it was unable to create it in the folder. Please make…
Neil P
  • 288
1
2 3 4