Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.

The tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
2
votes
4 answers

Why upgrade from SQL 2005 to SQL 2008 R2?

Possible Duplicate: Why upgrade from SQL 2005 to SQL 2008 R2? I have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a…
GordyII
  • 151
  • 3
2
votes
2 answers

SQL Server Agents jobs and turning off the server

I'm really new to SQL Agent jobs, but I am attempting to build up a maintainance regime for a server that will be turned off and on again at unknown intervals. It may run without being shutdown for a month, or it might only be turned on 9-5... we…
Tim Joseph
  • 21
  • 2
2
votes
3 answers

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of tables and stored procedures. I would like the Role…
Lewray
  • 143
  • 1
  • 1
  • 6
2
votes
4 answers

Replicating/Synchronizng multiple tables across different Databases on the same instance

I have few tables that needed to be replicated/synchronized across several databases in our SQL Server 2008 cluster. I know it's possible to replicate between multiple instances, but I'm looking for replication or synchronization in the same…
Idan
  • 309
  • 1
  • 2
  • 7
2
votes
2 answers

Computer specs for a large database

What sort of computer specs (CPU, RAM, disk speed) should I use for running queries on a database of 200+ million records? The queries are for a research project, so there is only one "user" and only one query will be running at a time. I tried it…
SpeksETC
  • 123
  • 1
  • 3
2
votes
4 answers

File store: CouchDB vs SQL Server + file system

I'm exploring different ways of storing user-uploaded files (all are MS Office documents or alikes) on our high load web site. It's currently designed to store documents as files and have a SQL database store all metadata for those files. I'm…
Andrey
  • 354
  • 5
  • 17
2
votes
1 answer

Cannot generate SSPI context from SQL Server Management Studio (2005)

Yesterday I went through some troubles to set up a DB on my local machine. I finally got that working, but now today I am getting an error when I try to connect to a remote machine. Cannot generate SSPI context. (.Net SqlClient Data…
Derek
  • 191
  • 1
  • 7
2
votes
3 answers

How can you schedule a database backup on SQL Server 2005?

Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally: In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio : I navigate to Server->Databases->System Databases->master Right click on…
mozzer
  • 45
  • 7
2
votes
1 answer

Copy the Users from one MS-SQL server to another

I am currently facing the problem that someone working here changed the password of the sa user of the Microsoft SQL Server 2005. The SQL-Server is running on a VM, and the application we run won't let me change the password it uses to login. Also,…
brot
  • 111
  • 5
2
votes
2 answers

Sql Server Limiting Access

I am not sure if what I want is possible but here we go. At work we have a dedicated SQL Server 2008 box that host the various databases that we need to run. We have a remote person (lets' call them Bob) who needs to host a database on it. I have…
modernzombie
  • 173
  • 1
  • 7
2
votes
2 answers

Forgot MSSQL sa Password

Someone else setup my laptop with SQLServer. My windows account is a user but is not a sysadmin. I don't know the sa password and I have no way of finding it. How can I reset the sa password or make my account (which is an admin on the machine) a…
Jason
  • 279
  • 2
  • 10
2
votes
3 answers

SSRS Export to Excel not working through VPN (Juniper SA4000)

We have a SharePoint (MOSS 2007 on Win2003 R2) with SSRS reports (from SQL 2005) embedded in it. When we connect to the SharePoint portal through our VPN (firewall is Juniper SA4000) and using Internet Explorer (6, 7, and 8) and try to export any…
Veynom
  • 206
  • 3
  • 10
2
votes
1 answer

Installing two versions of MSSQL on a production server?

We've just provisioned a second dedicated server so we can use database mirroring for high availability. The existing server uses MSSQL Express 2005. We have MSSQL Web 2008 and want to minimise the downtime to get mirroring set up. Can I install…
user59135
2
votes
4 answers

What is the default location for a DB in SQL Server 2008?

I detached a database in SQL Server 2008 but am unable to find the physical file to move. Where is this located?
kylehayes
  • 367
  • 1
  • 3
  • 8
2
votes
3 answers

SQL 2005 Password Recovery

I am trying to recover the password for one of the logins on a SQL 2005 (SP3) database. There seem to be a large number of tools out there to do this. I'm a little nervous of running a tool against a live database server that I don't know much…
Rob White
  • 463
  • 8
  • 16
1 2 3
…
99 100