0
votes
1answer
776 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
0answers
502 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
56 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, ...
2
votes
1answer
877 views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
0
votes
1answer
155 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
662 views

How to un-install sql server 2008 analysis service only?

Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1answer
37 views

SQL Server 2008 Express, just create a few tables and run queries? [closed]

I have installed SQL Server 2008 Express, as I just want to create a few tables and run queries against them. After installing I am a little unstuck. I have an "instance" running, but I am not sure ...
1
vote
2answers
529 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
0
votes
1answer
116 views

Fastest light-weight method of executing and displaying results of SQL query [closed]

Many if not most applications can display the results of SQL queries in some human readable format. However, they typically either must be open with an active window (SSMS or excel for example, both ...
11
votes
5answers
30k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...
1
vote
1answer
106 views

How to create a condition clause using a current computer time

I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1answer
2k 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 ...
3
votes
1answer
13k views

Why don't I have SQL Profiler on SQL Server Management Studio?

I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )) However I cannot find the option to open SQL Profiler. I was ...
3
votes
2answers
7k views

SQL server 2008 and 2012 on the same instance of Windows

Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
0
votes
2answers
3k views

Why Intellisense doesn't work in SQL Server Management Studio 2008 R2? [closed]

I have SQL Server Management Studio 2008 R2. I have tried these: Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked Go to ...
0
votes
1answer
642 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
4
votes
3answers
1k views

How to use Microsoft SQL Server 2008 as a simple database for testing

As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
1
vote
2answers
3k views

Can't access SQL Server from outside the network

I am trying to log in remotely to SQL Server 2008 R2. After reading several posts I was able to log in remotely from a computer on the same network. But I still cannot remotely log in from outside ...
0
votes
1answer
3k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
3
votes
3answers
24k views

How to remove a broken installation of SQL Server 2008?

After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
1
vote
1answer
3k views

install SQL Profiler for SQL Server Express

I am not sure what I did while installing SQL server express 2008 but sql profiler is not on my machine. is there a way to get that separately? my machine is not running on a server OS.
1
vote
2answers
4k views

Convert MySQL backup (dump script) to MS SQL?

I have a mysqldump output of a fairly large (by measure of doing things manually) database saved in a text file. Does anybody know of a (free) way to use this to build a database in MS SQL? I'm ...
0
votes
0answers
716 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 ...
1
vote
1answer
842 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, ...
0
votes
1answer
10k views

SQL Server Express 2008 R2 Installation error at Windows 7

I created an install script that will install SQL Server 2008 R2 on Windows XP SP3, Windows Vista and Windows 7. One of the command that I used in the installation is for silent installation of SQL ...
5
votes
4answers
5k views

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
0
votes
6answers
1k views

sqlserver 2008 or 2005 express cannot install on Windows 7 home?

When installing 2008 it says it requires .NET 3.5 and 2005 fails : what can I do ?
1
vote
2answers
2k views

Start an SQL Server instance without SQL Server Management Studio

I took my SQL Server 2008 offline because I was trying to do something... Now I can't log in to it using SQL Server Management Studio anymore. "The server was not found or was not accessible." I'm not ...
1
vote
4answers
4k views

Copy a SQL Server 2008 database verbatim

I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another. How do I do that?
1
vote
2answers
1k views

Can I install Sql Server 2008 on my windows home server

I would like to do more with my Windows Home server than file sharing and backups. Has anyone tried installing SQL Server 2008 (any version, but I'm using Professional) on a Windows Home Server?