The sql-server-2008 tag has no wiki summary.
0
votes
0answers
19 views
Trial of SQL Server 2008 R2 Web Edition
Has anyone downloaded and installed trial version of SQL Server 2008 R2 Web Edition?
I am trying to evaluate whether the web app I wrote would install and work correctly for this version as the ...
1
vote
2answers
82 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
20 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
12 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
40 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
41 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
50 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
44 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
112 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 ...
3
votes
1answer
127 views
SQL Server 2008 R2 (x86) and the Access Engine
All,
I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
1
vote
1answer
34 views
Visual j# asks for SQL 2005, but I already have SQL Server 2008 installed
I recently installed Visual Studio 2010 full pack (including SQL Server 2008).
After that, I installed Visual j# Express 2005 in order to work on a project.
The problem is: When I try to open a new ...
0
votes
2answers
83 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
0answers
24 views
The SQL Server 2008 license [closed]
can anyone knows what means Sngl OPEN 1 License No Level in the product: Microsoft SQL Server Standard Edition 2008 R2 Sngl OPEN 1 License No Level
0
votes
0answers
16 views
Scripting the creation of Partitions on Measure Groups in BIDS
We have an Analysis Services project, on SQL Server 2008 R2, and need to add a number of Partitions to the cubes, to improve the performance.
While it is possible to create the partitions against the ...
0
votes
0answers
41 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 ...
0
votes
1answer
18 views
Opening a database made in SQL Server 2008 Developer Edition in SQL Server 2008 Standard Edition
I have a database built in SQL Server 2008 Developer Edition but am unable to open it in SQL Server 2008 Standard Edition. It says the version of my SQL Server is too old.
How can I solve this ...
0
votes
1answer
58 views
SQL Server 2008 Management Studio - Edit Rows with Where clause
There is an option to edit rows in a grid - first 200 by default.
In Tools -> Options -> Sql Server Object Explorer, you can set the value for "Edit Top N rows".
I have a table with 200000 ...
0
votes
0answers
45 views
Entity Framework, ASP.NET MVC and performance
I have problem with performance and don't understand behaviour of EF. I use ASP.NET MVC application and have the following code in model:
public List<Portal> PortalListWithCategories()
...
0
votes
1answer
80 views
Installing SQL Server 2008 R2 Management Studio
My dev box is a Windows 7 machine and I am trying to install SQL Server 2008 R2 Management Studio.
When I run the installation SQLManagementStudio_x64_ENU.exe (downloaded from Microsoft site), it ...
5
votes
2answers
199 views
Encrypting my laptop hard drive
I've considered encrypting my laptop hard drive for a while now, but the only thing holding m back is my Microsoft SQL Server 2008 installation. I use my laptop for development and also have some ...
4
votes
3answers
112 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 ...
2
votes
3answers
608 views
How to execute a stored SQL procedure in Microsoft Excel?
How can I execute a stored procedure in Microsoft Excel and get all the data it returns?
0
votes
1answer
185 views
How to change SQL Server 2008 authentication mode?
I have an SQL Server 2008 and I want to check/change its authentication mode. Now I've seen several ways to do so in the web using SQL Server Management but I don't have that..
Is there any way to do ...
1
vote
2answers
107 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 ...
1
vote
2answers
179 views
Change font in MS SQL Management Studio Database Diagram
My eyes must be getting old as viewing database diagrams is getting more difficult every year. Is there a way to change font type and/or increase the font size of text in database diagrams? I've ...
0
votes
1answer
48 views
Which SQL Server package is to be used for Mac?
I want to install the SQL Server 2008 in my Mac machine. I have used the one appropriate for my Windows machine. Now I want to install into the Mac, so please suggest the appropriate software package ...
0
votes
0answers
42 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 ...
2
votes
0answers
155 views
Database 28 cannot be autostarted during server shutdown or startup
I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error.
TITLE: ...
1
vote
0answers
30 views
How to configure Munin to montior Microsoft SQL Server 2008
Is it possible to configure Munin to montior Microsoft SQL Server 2008?
On Windows 2003 Server.
4
votes
3answers
117 views
Can I install Microsoft SQL Management Studio by itself?
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't ...
0
votes
1answer
69 views
SQL Server 2008 Enterprise Install - Missing Rockall.dll
I'm trying to install SQL Server 2008 Enterprise on Windows 7 Enterprise.
When I run setup.exe from the English/SQL2008/Enterprise folder, I get an error box titled pcaui.exe - System Error ...
0
votes
1answer
185 views
Viewing table relationships in SQL Server Management Studio
In SQL Server Management Studio, I have relationships set up between tables.
Is there a way to display a view of all the tables with the adjoining lines like in Microsoft Access? Do I need to open a ...
0
votes
1answer
112 views
Installing SQL Server Management Studio on Visual Studio 2010 Ultimate edition
FYI, I have BOTH Visual Studio 2010 Ultimate version AND express edition(Visual web developer) installed on my computer.
I open up Web Platform Installer and select "SQL Server 2008 R2 Management ...
0
votes
1answer
53 views
Windows update and SQL Server 2008 Service Pack 1
My o/s (vista ultimate 64) has been offering this up since it was published on 6/14. Three times I downloaded and installed it, along with the attendant restart!
Info from the SQL Server Mgt Studio ...
0
votes
1answer
429 views
IIS 7: How do I install Bugzilla?
I have Bugzilla 4 and I need to get it to run on a Windows Server 2008 running IIS 7. I've looked at various tutorials with no luck. Please direct me on how to setup Bugzilla!
3
votes
2answers
284 views
Change SQLEXPRESS instance name
I installed VS2010 and it automatically installed SQL Server 2008 Express.
Now, the installed instance is called SQLEXPRESS, therefore to connect to it I have to use 'localhost\SQLEXPRESS' or ...
1
vote
2answers
516 views
SQL Server Express Failed to Install
I am attempting to install SQL Server Express (as part of the Visual Studio 2010 Professional installation), but it is failing. I am receiving this error log.
[06/22/11,16:31:39] Microsoft Visual ...
0
votes
2answers
89 views
How to connect SQL Server across the Work Network?
SQL 2008:
I am trying to access SQL Database which is running on Server / Test Computer which has Windows XP OS.
My Computer and Test Computer both are connected in our Local Network.
Still I am ...
3
votes
2answers
190 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
96 views
Do we need to install SQL Server 2008 SP2 after installing SQL Server 2008 R2 RTM?
I have installed SQL Server 2008 R2 RTM (Express) with Management Studio. But I am confused, do I need to install SQL Server 2008 (Express) Service Pack 2?
Is there SQL Server 2008 R2 Service Pack 2?
...
-1
votes
3answers
67 views
Where can i download SQL server express 2008 from?
I have windows xp (sp3, i think). I tried to download the sql express version, but it says that it is invalid win32 application.
...
0
votes
1answer
250 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.
2
votes
3answers
342 views
Does SQL Server 2008 R2 Express have Intellisense?
I don't have any Intellisense in SQL Server 2008 R2 Express Management Studio - is this supposed to work?
I am connecting to a SQL Server 2008 R2 Express database on the same machine (no other ...
1
vote
4answers
155 views
MS-Access database-upsizing error
I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one...
The table that doesn't get ...
0
votes
0answers
216 views
Can't install SQL Server Management Studio 2008
For some reason, when I attempt to install Management Studio 2008 via SQL Server 2008 setup, the tool is not displayed in the at all under the "Shared Features" category where other tools such as ...
2
votes
0answers
265 views
Free Alternatives for SQL Prompt
Is there any free/open source alternative of SQL Prompt? SSMS 2008 R2 intellisense is good but I need it for code optimization. For example it should notify me when there is an unused variable ...
0
votes
0answers
469 views
Can't start SQL Server 2008
I just installed SQL Server 2008 R2 and I can't get it started. I opened the configuration manager, but the SQL Server, Agent and Browser options can't be started (the start option is greyed out, as ...
0
votes
3answers
857 views
Is SQL Express 2008 subject to the same 5 connection limitation as file sharing on Windows XP?
File sharing on Windows XP has a 5 client limitation. Our solution uses both file sharing and SQL Express.
The way I see it, we have 2 options here:
-Reload the machine that they want to use as a ...
1
vote
0answers
95 views
What is the command line that Visual Studio uses to install SQL Express?
I'm writing an application that will download and install all the prerequisites for a larger application. One of those prerequisites is SQL Express 2008. I need my application to be able to install ...
1
vote
2answers
1k views
Can I install Microsoft Visual Web Developer w/o a SQL Server Express installation?
When I attempt to install Microsoft Visual Web Developer 2010 Express, it forces an installation of SQL Server 2008 Express, which is okay. However, it forces it to have the instance name SQLEXPRESS ...
