The sql-server-2008 tag has no wiki summary.
0
votes
0answers
14 views
Finding oracle physical database files [migrated]
I'm using oracle 11g and I need to find the database files to copied to another server. The database was created from migrating from SQL Server 2008 to 11g. There doesn't seem to be a counterpart for ...
0
votes
1answer
37 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
44 views
Windows XP, SQL Express, 3rd party application crash — how to check the possible lack of resources?
Summary: I need to log usage of resources on Windows XP machine to find if the lack of resources may be the reason for the application crash. I need your advice how to do that.
Context: There is an ...
0
votes
1answer
56 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 ...
0
votes
2answers
150 views
Can I delete SQL Server from Windows 7 without secondary effects?
I'm trying to delete all unnecesary programs from my computer and SQL makes me doubt. I don't use it directly, but can't recall any program using it. Is it safe uninstalling?
11
votes
3answers
384 views
How to install multiple Microsoft applications without conflicts
For all the IT students, self-teachers, and new professionals
Situation: The days of ...
-1
votes
1answer
24 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
201 views
-3
votes
1answer
214 views
SQL installation in windows 7 home basic(32 bit) [closed]
i have a laptop of following spec..
2GB RAM
500GB HDD
Windows 7 HB(32 bit)
I wish to install SQL server 2008 in my laptop. Heard that VS 2010 is a must for that. This is just for learning purpose. ...
0
votes
0answers
11 views
Change the rename database timeout in SSMS
Before I rename a local database, I'll run sp_who to see which processes have my database and then kill to remove those processes.
Sometimes, I forget to do this and when I attempt to rename, I have ...
2
votes
0answers
40 views
SQL Server 2008 and Visual Studio 2008
I have a database project to do. I can't install SQL Server 2008 on my PC (windows 7 64 bit).
When I start it says Microsoft.NET Application Security. It go further though. But it says Older version ...
0
votes
0answers
45 views
Access database linked to SQL database [closed]
My domain account has access to our MS-SQL server where the database resides, so I never experienced this issue.
When I gave the Access .mdb file to one of our regular users, he was unable to use the ...
0
votes
0answers
156 views
Sql server installation SQLEXPR32_x86_ENU.exe not working
When I double click on SQLEXPR32_x86_ENU.exe, a dialog box opens and it shows it is extracting autorun.inf, but it is not proceeding.
1
vote
1answer
146 views
SQL Server 2008 R2 service pack 1 not showing
I've checked my SQL server version and it says "Microsoft SQL Server Management Studio 10.50.1600.1". I've seen here that there's a SP1 for it. Why doesn't windows update offer me to d/l it?
Should I ...
1
vote
1answer
831 views
Sql Server Management Studio: Change Prefix or Suffix characters
I have an instance of SSMS 2008, for which the option to edit data in a table doesn't work. If I right-click on any table in the Object Explorer and select 'Edit top 200 rows' I get an error dialog ...
0
votes
0answers
40 views
Our application is responding different on client server
I have an application running on our local server and it works perfect.
However when I deploy my application to our client's server there are problems.
If i copy all the sources to another local from ...
0
votes
1answer
65 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 ...
2
votes
4answers
6k 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 ...
0
votes
0answers
49 views
The exported using a batch command SQL table does not contain headings
I have created a batch file with such a command:
bcp Database.dbo.MyTable out C:\Reports\Output_%date:~10,4%_%date:~4,2%_%date:~7,2%.csv -s ServerName -T -c"
to export an SQL View. However the ...
0
votes
0answers
214 views
Database design of a User validation, roles and rights module [closed]
I am trying to model a User Authentication module for a MS SQL Server database that will be the back end to a Delphi UI Application. Basically, I want to have user accounts where the user belongs to ...
1
vote
1answer
211 views
How can I compare two huge tables?
I need to compare if two developers did the job correctly and created identical tables.
The problem is more complex, but I will try to solve it somehow if I solve the problem of comparing two tables ...
0
votes
1answer
107 views
How to use the current date as an argument?
I have a batch script which extract SQL data to CSV file:
"bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c"
I need the name of the output file should contain the current date. ...
0
votes
1answer
55 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
132 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 ...
0
votes
0answers
177 views
Cannot login to sql server 2008 express after the installation
After i have installed VS 2010 in windows 7 64 bit. I tried to install sql server 2008 express 64bit version. but the installation failed. saying some files is missing from the downloaded package.
I ...
1
vote
2answers
107 views
What to enter as “Server Name” in SQL Server Management Studio
When I start SQL Server Managaemnt Studio (SSMS), I'm having a problem in connecting to the database.
What will be the 'server name' if my computer's name is Rakesh?
0
votes
1answer
210 views
Questions about setting up PHP-ODBC driver for remote SQL-Server-2008 connection on CentOS-6
I have CentOS 6 and PHP 5.3.3 VPS at GoDaddy. I have to interact with remote SQL Server 2008. I've seen many tutorials and quite lost here, so:
There is a way to simply yum install it ?
If not, what ...
0
votes
0answers
237 views
ms-sql query running from SQL Server Management Studio 2008 gives right result, but not from sqlcmd [closed]
@echo off
sqlcmd -S it\mssqlserver -i "C:\Documents and Settings\Administrator\Desktop\queryinsqlservermgmt08.sql" -o C:\outfiles\output.csv
This is the command I am using, I tried with different ...
1
vote
1answer
515 views
Renaming server - sql 2008 server instance affected
Will changing the computer name on which SQL Server 2008 is installed on affect SQL Server in anyway? Or will changing the computer name be transparent to SQL Server?
For example:
I plan to install ...
0
votes
0answers
48 views
IIS blocking outgoing requests to SQL Server
Is there a way I can block requests from IIS to SQL servers hosted on a particular domain/ip/ip range? I want to do this to prevent people from running code against Production DBs unknowingly.
if you ...
0
votes
0answers
754 views
SQL server 2008 R2 installation error
I have a windows 7,32 bit laptop. I am the administrator with all permissions.
when I click on the SQL server 2008R2 set up file,it says :
"SQL server set up has encountered the following ...
0
votes
1answer
2k views
SQL Server 2008 Registration with Product Key
A colleague of mine gave me the SQL Server 2008 Standard ISO image and I used that while building a Virtual Machine.
Now, when I installed SQL Server with that above mentioned ISO, I did not give it ...
0
votes
3answers
274 views
Error while installing SQL Server 2008 on Windows 7 Home Edition 64 bit
I am trying to install SQL Server 2008 on my Windows 7 Home Edition,
Setup is giving an error
attempting to perform unauthorized operation
0
votes
0answers
100 views
how to access database in SQL server from ASP website? [closed]
I was trying to connect database from SQL Server 2008.
the error shown is:
Cannot open database "signature" requested by the login. The login failed.
Login failed for user 'IIS ...
1
vote
1answer
5k 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 ...
-1
votes
1answer
84 views
How to access a website created using ASP.NET with database SQL Server 2008 from another machine? [closed]
I've created package of websites, which redirect to each other, using ASP.NET in C# using Visual Studio and have stored the values in a database using SQL SERVER 2008. I want to make one ...
1
vote
0answers
222 views
Excel 2010 not displaying calculated measures as currency
When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting ...
1
vote
1answer
261 views
Microsoft Update - how to make it work properly?
I`m using a wide range of microsoft products - Windows 7 Ultimate x64 with SP1 included, Microsoft Project, SQL Server 2008 R2 and Visual Studio 2010. After doing a full OS reinstall I tried using ...
1
vote
2answers
3k views
Windows 2008 R2 Memory is always full
We have a Windows 2008 R2 on a HP Server with 24GB of RAM. The only important software installed is SQL Server 2008 R2 and almost no feature or role is enabled on this Windows.
But the problem is ...
1
vote
0answers
172 views
Export MS SQL database as *.dbschema
We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
3
votes
2answers
3k 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
49 views
I need more advice on this data addition issue [closed]
I have a test program consisting of a textbox (textbox1), a button (save), and a connection to a database and a table called TestDatabase.mdf and TestTable (respectively). I am trying to save the text ...
1
vote
2answers
625 views
Lagging windows and mouse pointer in Windows 7
I'm using Windows 7 and on top of it I have installed Visual Studio 2010 and SQL server.
For some time now I have been experiencing a laggy behavior. Explorer windows minimize and maximize with a ...
1
vote
1answer
66 views
How do I set up a new database with SQL Server 2008?
In my start menu, I have Microsoft SQL Server Express 2008 R2 > Configuration Tools. In this folder, I have SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server ...
0
votes
1answer
626 views
Trouble enabling remote connections to SQL Server Express 2008 R2
I'm trying to enable remote connections but i'm having some trouble. Here's my setup
SQL Express is installed on Win2k8 R2.
Windows firewall turned off
SQL Browser service started and running
SQL ...
1
vote
0answers
370 views
Creating a New Database Across a Network with SQL Server 2008 R2
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and ...
0
votes
1answer
77 views
Install issue in windows 7 SQL Server 2008
I keep trying to install SQL Server 2008 on windows 7 but after a while and more than half installation i get this error:
0
votes
1answer
83 views
SQL Server Reporting?
I have a SQL Server instance setup, and on one of the databases I have a lot of views defined.
I have to connect to our VPN before I can connect to the database.
I'm wondering if there is a simple ...
1
vote
1answer
447 views
What basic linux command-line utility can I use to test a JDBC connection?
I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a ...
0
votes
1answer
306 views
What's the difference between single processor or dual processor SQL Server 2008? [closed]
I am little bit confused about single core processor based SQL server or dual processor based SQL server.
We are planning to purchase SQL server 2008 Standard R2.
People are asking whether it is for ...
