The sql-server 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
3answers
37 views
Should I transition from an Excel file to a MS SQL database?
I currently have an Excel spreadsheet acting as a small data base, about 2000 entries. It is fine for our needs but we now need to allow a couple of staff to securely and quickly access subsets of the ...
1
vote
1answer
1k views
How to install SQL Server Express?
While installing Visual Studio 2010, I saw an option to install SQL Express. I checked that option assuming it would install SQL Server Express as well, but apparently it didn't. When I type ssms.exe ...
0
votes
0answers
22 views
Using SQL Server Migration Assistand for Access to fi and import queries to views
Im trying to use SSMA to migrate my Access queries over to views but Im getting TONS of errors, which is racking up an estimated 66 hours of manual conversion time.
The biggest offenders are the ...
1
vote
1answer
24 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 ...
0
votes
0answers
19 views
Development enviroment setup advice needed [closed]
I am looking to build a machine, and this is not about what to get, it is about what to use as a host as I want to virtual the environments.
I will be doing DB development, some prototyping, some ...
1
vote
2answers
110 views
Windows XP PRO SP3. Setup ASP.NET dev. environment
I have Windows XP PRO SP3 And Visual Studio 2010.
By default I have IIS 5.1. And there is no option to upgrade it.
I want to start developing ASP.NET.
Could any one give a good reference how to ...
3
votes
1answer
104 views
SQL Server Management Studio ignores default DB
When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
1
vote
1answer
24 views
Tools to manage SQL Server and Oracle database from the desktop
I am using SQL Server 2008 and Oracle 11G on my system.
Running both database services is making my system very slow. In order to stop the services I have to go to Services and stop them manually.
...
0
votes
2answers
82 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
4answers
58 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
0answers
50 views
How to start with the SQL queries in the QC 10.0?
I understood that for generating reports and troubleshooting in QC we can use SQL queries from backend of the QC 10.0.
Please guide me through any any tutorial websites,cookbook's or workbook's ...
0
votes
0answers
16 views
How to retrieve the size of a database in restoring mode
With pure SQL - how to do it?
I doubt it is possible, since even the SQL Management Studio fails to show the size of such a database in the UI.
Already tried:
exec sp_helpdb 'DbInRecMode'
...
1
vote
1answer
27 views
How do I connect to a database without seeing all the other databases on the host?
I'm using Microsoft SQL Server Management Studio 2008 R2, I followed the instructions from my host and I'm successfully able to connect to my database, but I also happen to see all of the databases on ...
2
votes
1answer
93 views
Is it a virus on my PC?
Somehow sqlservr.exe launches cmd.exe (with very strange command line params) and ftp.exe processes on my PC, please see screenshots. I have already installed antivirus. What it could be, how to treat ...
0
votes
0answers
24 views
Sql server transaction log is very big: how to manage it?
i'm a newbie about Sql Server Administration.
I've some questions regarding it, hope you can help me:
What is the LDF file ? Is it the transaction log ?
How to limit the growth size of the ...
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
0answers
11 views
What folder should I put the sql server 2008 extract files when running setup via this command?
http://blog.tonysneed.com/2010/08/05/setting-up-sql-server-2008-express-with-profiler/
I'm following this tutorial here that shows you how to install sql server express (db engine only) using this ...
0
votes
1answer
35 views
Sql Server Express Installation
I am learning ADO.NET programming. I want to install Sql Server Express for doing the some programs. I am using Microsoft Visual Studio 2010 Ultimate on my windows 7 home basics 64 bit.
I have ...
1
vote
1answer
89 views
How Do I Investigate a CPU Usage Spike Without Being Present?
I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...
0
votes
3answers
91 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 ...
0
votes
0answers
187 views
1
vote
1answer
62 views
Querying big databases with Excel
Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
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 ...
0
votes
2answers
184 views
How to install MS sql server client in 64 bit windows 7 operating system?
I want to install sql server client in my windows 7 64 bit version. But I am unable to do that please provide some help.
i want to install only Client not sql server. is this possible.
0
votes
0answers
39 views
Microsoft SQL Desktop Engine - MSDE 2000 Install failure
A program is attempting to install MSDE 2000 as part of its package as it requires an SQL database backend, it is failing when attempting to load the setup engine with an error saying that it is ...
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
1answer
93 views
Open port for Microsoft SQL database connection from outside the Windows7 computer
My Firewall seems to be blocking the connection from anywhere to my local MS Sql Server on my Windows7 development machine.
On Linux and Mysql I could telnet the database ports and it gives response ...
0
votes
0answers
41 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 ...
0
votes
2answers
101 views
How can I make a usable copy of an SQL Server database on Windows Server 2003?
I need to make a usable copy of an SQL Server database on Windows Server 2003 for testing purposes. There is a backup tool built into Enterprise Manager but I can't seem to make it work.
I've tried ...
0
votes
1answer
376 views
How can i compress when I create SQL backup file in a folder?
I use SQL Server Express and I create backup files for all databases every day using Time Scheduling script. One script Like that;
BACKUP DATABASE [Jira]
TO DISK = N'C:\Backup\Jira.bak'
WITH ...
2
votes
3answers
177 views
SQL Server Ports
The Microsoft website states
The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens to on TCP/IP), and ports 1024 to 65535 outgoing.
Does this ...
1
vote
1answer
76 views
SQLCMD -L option with a smaller timeout
I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...
3
votes
1answer
183 views
Purging Expired SQL Server Backups
I have set up a SQL Server Agent job to execute a backup every night at 3am. The job appends the backup to an existing backup file, and sets the expiry of the backup to expire in 7 days time.
It's ...
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 ...
2
votes
1answer
100 views
How to convert Microsoft sql 7 database to Microsoft sql 2008 database?
Is it possible to convert an Microsoft SQL 7 database into Microsoft SQL 2008?
4
votes
2answers
100 views
preserving \n from SQL Server Management Studio
I have a column called EventLog varchar(max) and can be pretty big because essentially it stores the event log of an entire batch process.
The problem is that when I go into the query window and do ...
4
votes
4answers
1k views
Cannot connect with Sql Server Studio: error 18456, state 8 — but password is correct!
Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to ...
0
votes
0answers
431 views
ODBC link from Access to SQL Server changes to read-only [closed]
Cross Posted: ODBC link from Access to SQL Server changes to read-only
I have an Access 2007 db front-end that interacts with a SQL Server engine. All works OK, but there is a linked table that ...
0
votes
2answers
331 views
How to forward port on a dedicated windows server 2008?
In MSDN to make SQL Server accessible from Internet
http://msdn.microsoft.com/en-us/library/ms175483.aspx
They say to forward port from sql server remote port to usual sql server port 1443.
I have ...
0
votes
1answer
249 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.
0
votes
0answers
33 views
Dump a subset of data from SQL Server to XML file
Looking for a utility to export some data from SQL Server to an XML (or other text based) file...
"Some data" being the current record from a main table plus a bunch of related data from other tables ...
2
votes
1answer
162 views
NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?
I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
0
votes
0answers
241 views
Business Contact Manager 2010 server-side database hosting
A client of ours is starting to use Business Contact Manager 2010. It seems to be working fine on the workstation, but I need to set up a database on the central server (Small Business Server 2011). ...
0
votes
0answers
72 views
SSIS package step - lifetime - memory release
I have a procedure which performs lot of independednt but complex tasks. Obviously because of the complexity (lot many joins) it takes lot of time to complete. I was thinking to create a SSIS package ...
0
votes
0answers
37 views
Find material for improvement of my SQL ability [closed]
I need lots of training in SQL coding in MS SQL server
The following part that is needed to be improved is:
script
T SQL
Procedure
Function
Problem:
Where can I get material to improve my ...
0
votes
0answers
48 views
Access 2003 ADPs are slow to load if another is running
I use Access 2003's ADP capability to make quick edits to data in my SQL Server databases--it's orders of magnitude faster than working ad-hoc with table data in MSSQLEM.
When I initially open an ADP ...
0
votes
1answer
140 views
How to determine sql server name
I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql.
![enter image description here][1]
I get the notice: unable to connect to ...
0
votes
1answer
184 views
Database to a Network drive
What would be the syntax to backup MS SQL Database 2005 to a network drive?
