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-...

learn more… | top users | synonyms

1
vote
1answer
331 views

SQLManagementStudio - Available databases combo box in menu - can't find it in Tools/Customize

GUI customisation question: In MS SQLServer Management studio there is a combo box with the databases available at the server. I want to copy it to the menu row; but I can't find the control in the ...
1
vote
0answers
354 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
1answer
154 views

Cannot install SQL Server CE 4

I'm trying to install SQL Server CE 4 on a WinXP Pro SP3 machine. I double-click on the file and absolutely nothing happens. There is nothing in the event viewer and the only effect I can see is the ...
1
vote
0answers
49 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. I'...
1
vote
1answer
10k views

How do I automate the exporting of a result set from an SQL Server database?

I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed: The SQL script to ...
1
vote
1answer
74 views

How to find my network and database access [closed]

Our company gets audited pretty regularly and I was wondering if there's an easy way to find out which accounts have access to what on our network? We're an all windows development shop, so all our ...
1
vote
1answer
2k views

SQL Server 2012 installation - Service 'SQLBrowser' start request failed

I am having trouble installing SQL Server 2012 Express on Windows 7. Whenever I try the installation, I get the error Service 'SQLBrowser' start request failed. If I click Retry, it happens ...
1
vote
1answer
1k views

sqlservr.exe's virtual size is big – should I worry?

Is this normal? Does the large virtual size matter on sqlservr.exe for the performance of other apps? It seems to happen any time I use Firefox and iTunes. ( Also running is League of Legends) Can ...
1
vote
1answer
427 views

connecting to sql server from access for multiple users

I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize ...
1
vote
3answers
357 views

Could not find file 'SqlAccess.dll'

When running CREATE ASSEMBLY MyAssembly FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll' an error is returned: Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL ...
1
vote
0answers
162 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 ...
1
vote
1answer
1k views

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual Studio

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, ...
1
vote
1answer
344 views

Opening offline version of Microsoft Books Online in browser

I often use the MSDN website for language reference. In order to make navigation faster, I downloaded the offline version of SQL Server 2005 Books Online from here: http://www.microsoft.com/downloads/...
1
vote
1answer
641 views

What do these Microsoft Updates do, and why can't they configure correctly?

MB: Biostar M7NCG 400 CPU: AMD Athlon XP 2200+ 1.8GHz RAM: 2.5GB (I don't know the speed, but does it really matter?) Display: NVidia GeForce 4 TI 4200, with hardware support for ...
1
vote
3answers
560 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it read-...
1
vote
3answers
49 views

Windows 10 - MSTSC UI has very bad performance

About a month ago I reinstalled my PC at work and put Windows 10 on it after I received my new SSD. While the system itself runs very smooth, the MSTSC UI (the connection dialog) is pretty much ...
1
vote
1answer
383 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
2answers
453 views

SQL Server Licence in MSDN

I had bought a VS2010 Professional version licence through our corporate licence. I was recently browsing through the MSDN product download page and found that SQL server download were available for ...
0
votes
4answers
797 views

Sharing Excel sheet over network?

Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
0
votes
2answers
3k views

How to turn off IIS forever?

I have just installed Sql Server and it needed IIS. Now when I go to http://localhost/ I get -2147467259 (0x80004005) I bet its IIS. How to turn it off and remove it from autostart?
0
votes
4answers
1k views

How can I model a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
0
votes
1answer
2k views

Reducing system disk space usage on computer with SQL Server

The disk usage on my computer continues to rising with time. How can reduce his size without damaging programs and windows. The disk is SSD with 180 GB, because of that this is sensitive to me ! ...
0
votes
2answers
5k views

Files left after uninstallation of MS SQL Server

I just uninstalled MS SQL Server 2008 from my machine (using the "Uninstall or change a program" feature in Windows Control Panel). Now I notice that there's still a lot of files left. Around 1 GB ...
0
votes
3answers
5k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
0
votes
4answers
20k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
0
votes
2answers
3k 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
179 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
4answers
513 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
0
votes
2answers
3k views

Error code 0x80070001 on Windows Server 2008

I've been struggling to get Windows Server 2008 running on a virtual machine. I use VMplayer and want to install Windows Server 2008 Database and Enterprise from MSDN AA. The server is running now but ...
0
votes
1answer
74 views

How to speed up off-site access to Access application

I built a calendar-type application on MS Access 2013 with SQL Server as the back-end (each day on the calendar is a subform). About 20 tables are connected using the line Call AttachDSNLessTable([...
0
votes
1answer
30 views

Clustered SQL database requires full recovery mode?

The application we provide customers with requires an SQL database. Due to the nature of the application, we recommend the recovery mode to be set to Simple as it is not critical data that is stored. ...
0
votes
2answers
44 views

Steps Needed to Install .Net and SQL Express on Windows Server 2012

Please forgive the simplicity of this question, but I work mostly with Linux servers and older versions of Windows Server. My exact question is how are packages installed on Windows Server 20212, ...
0
votes
1answer
181 views

Do i need all of those MS SQL server and MS C++ Redistributable?

Steam has off sale games and i have planned on getting 8 games. With that, i'm starting to prepare my computer to receive those games by cleaning up some useless stuff. Though when i was on "Programs ...
0
votes
1answer
306 views

Port 80 used by Microsoft-HTTPAPI/2.0

The port 80 is used by Microsoft-HTTPAPI/2.0 and cannot be stopped. I have tried many solutions, but no one worked. Here is what I have done. Also, here is what is on the page : Not Found HTTP Error ...
0
votes
1answer
1k views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
1answer
406 views

Compatibility between Windows 7 and Windows 10. [closed]

I receive the free update from Microsoft for Windows 10. At the moment I'm using Windows 7 Ultimate. I have several question, for which I can't find anything in google or at least my search words was ...
0
votes
1answer
79 views

Silent, power saving mini-server for home [closed]

I am looking for hardware to make a small, silent, power saving mini-server for use at home. My specifications are: Small Fanless / Small fan Able to run Windows server OS Has 2GB of RAM, ideally ...
0
votes
1answer
404 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
1answer
58 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 ...
0
votes
2answers
4k 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
3answers
7k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
0
votes
2answers
552 views

How can Windows performance counter data be saved directly to SQL Server tables?

I would like to log data from a given set of Windows performance counters directly to tables SQL Server. Does Windows provide a way to do this without writing a custom application to do so? If so, ...
0
votes
3answers
11k views

SQL Server Express while attaching a database getting error 5120

I have SQL Server Express installed on my local machine. When I try to attach a database file, it's giving me the following error Unable to open physical file "C:\Adventures2012_data.mdf. ...
0
votes
2answers
2k views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
0
votes
1answer
86 views

Edit sql code instead of clicking buttons

Does SQL Management Studio 2012 allow editing the SQL DDL (data definition language) code directly? If not, how can I view only the SQL code generated by the application?
0
votes
1answer
96 views

When will Microsoft stop supporting SQL Server 2005? [closed]

We are purchasing proprietary software that requires it run on a SQL Server 2005. My concern is we will not be able to change/modify/enhance at all. SQL Server 2005 is pretty old and want to know if ...
0
votes
2answers
2k views

How to setup Vagrant Windows Server machine with SQL Server on it

Can anyone explain (or give a link) how to setup MS Windows Server VM using Vagrant on Linux (Arch Linux)? I was searching in Google but only think that I found are instructions how to setup Vagrant ...
0
votes
1answer
5k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...
0
votes
2answers
4k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
0
votes
3answers
2k views

Networking in VMware

I am required to imitate a remote database server environment for my project. So I am thinking of installing SQL Server 2008 on a virtual machine (VMware workstation) and then access it from my ...