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
1k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
0
votes
1answer
2k views

How to backup Windows 7 Live Photo Gallery?

How do I backup Windows Live Photo Gallery? I've been running on Windows 7 RC and I want to upgrade to the full Windows 7 release. I've been managing my photos with Live Photo Gallery. I want to ...
0
votes
4answers
17k views

Run as administrator needed for IE8 workaround but user is in Administrators group

I'm running IE8 on Windows 7 and logging in under a company domain account (not the machine domain). The domain account is assigned to the machine's administrators group. As a workaround for the issue ...
0
votes
0answers
12 views

SQL database recovery from corrupt database file. What to do next?

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental ...
0
votes
0answers
11 views

How to repair backup of .mdf file database? [migrated]

One of our clients gets the following error when trying to backup a database: System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum ...
0
votes
1answer
105 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
32 views

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

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
0answers
5 views

When is a default value initialized? [migrated]

create table tab3(a integer,d1 datetime default getdate()) insert into tab3(a) values(1) insert into tab3 (a) select a from tab3 GO 20 insert into tab3 (a) select a from tab3 select d1,count(*) from ...
0
votes
1answer
27 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
27 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
24 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
15 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
47 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
43 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
27 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
102 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
1answer
30 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
16 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
13 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
33 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?
0
votes
1answer
357 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
32 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
0answers
50 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
1answer
8 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> ...
0
votes
2answers
118 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 ...
0
votes
1answer
32 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
32 views

How to repair .mdf file?

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
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
25 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
16 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
1answer
16 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 ...
0
votes
0answers
41 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
27 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
48 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
1answer
246 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
91 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
139 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
1answer
69 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?
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
271 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
174 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
452 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
1answer
32 views

MS Access Autonumber dilemma

I am using a sql query that will copy the data from one table to another. The problem though is the counter which I put in the Second table of my Insert into Select Statement. It all started from ...
0
votes
0answers
67 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
1answer
89 views

Unable to run dtsx package

Error is thrown "To run a SSIS package outside of SQL Server Data Tools you must install SSIS log provider for SQL Server of Integration Services or higher." When I am trying to run package from ...
0
votes
1answer
50 views

SQL : swap 2 values in a column without using an intermediate value

Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement Ex: A B A B to B A B A It is a trivial process if we use a bit ...
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
111 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
1answer
85 views

Can't open SSMS - stating I don't have permissions

Whenever I try and run SSMS I get the following error. 'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. ' The dialog box ...
0
votes
1answer
54 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, ...