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.

learn more… | top users | synonyms (3)

6
votes
3answers
55k views

How are SQL Server CALs counted? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? Running a SQL Server, as far as I understand it, you need one CAL for every user who connects to the database server. ...
6
votes
2answers
2k views

SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week

I have a ~45GB database that increases rapidly (~1GB every week). So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now. But I'm noticing that the RAM sql ...
6
votes
8answers
8k views

Can Oracle and SQL Server exist on the same server?

We want to install SQL Server on a legacy machine which is running Oracle. Is there any reason why they cannot coexist on the same machine?
6
votes
4answers
5k views

Why “Begin Transaction” before “Insert Query” locks the entire table?

I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
6
votes
3answers
9k views

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know ...
6
votes
4answers
17k views

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows ...
6
votes
6answers
30k views

cannot add a user to sysadmin role in SQL Server

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008. My issue is, ...
6
votes
2answers
38k views

How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64

As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our ...
6
votes
4answers
15k views

MS SQL server: Single or multiple instances?

How costly (CPU or memory wise) is it to have multiple instances of SQL server 2005 instead of only one instance with prefixed databases? A company have three application providers. They each will ...
6
votes
5answers
384 views

Why attend Tech.Ed?

I'm considering going to Tech.Ed on the Gold Coast (Australia). I was very jealous at many of the teched US SQL Server speakers & presentations. What well-known SQL personalities will be there ...
6
votes
1answer
10k views

Will SQL Server 2012 install + run Windows 2003

I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64? I don't intend to use this for production just for testing and ...
6
votes
3answers
465 views

Need help recovering a corrupt SQL database

I have a very special case that I have been working on for several days. I have a very large SQL Server 2008 database (about 2 TB) that contains 500 filegroups to support very large partitioned tables....
6
votes
5answers
498 views

What proportion of DBA skills are platform-independent?

Problem: we've grown to the point where we need a real DBA. Real DBAs are hard to find. Possible solution: I know someone with extensive experience (currently working on MSSQL) who is looking for a ...
6
votes
6answers
19k views

Auto-start the SQL Server Agent after a computer restart

I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the ...
6
votes
2answers
2k views

Renamed a SQL Server, however maintenance plans still have old name

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'. The text boxes containing the server names for Local ...
6
votes
5answers
3k views

SQL Server suddenly using only a small portion of CPU

We've got a Windows 2008 R2 server running SQL Server 2008. All of a sudden, the SQLServer process is refusing to go above 20% CPU usage. As of last week, when running a heavy query against the db it ...
6
votes
1answer
1k views

How to upgrade MS SQL Server from 32bit to 64bit

I have a production server, that is used for MS SQL Server Databases. The machine specs are: - Intel Xeon E5410 CPU with (EM64T) - 4 GB RAM - SCSI HDDs in RAID mode It currently has: - Windows ...
6
votes
2answers
12k views

Login failed for “IIS AppPool\ASP.NET v4.0” - SQL Server Web

I'm trying to migrate a website from SQL Server 2008 Express to SQL Server Web, and the website is having trouble accessing the database. In truth, Express was only ever used by running the website ...
6
votes
4answers
3k views

Help! The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space

We're running SQL Server 2000. In our database, we have an "Orders" table with approximately 750,000 rows. We can perform simple SELECT statements on this table. However, when we want to run a ...
6
votes
12answers
9k views

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We ...
6
votes
3answers
19k views

Best tool to migrate a PostgreSQL database to MS SQL 2005?

I have a database in PostgreSQL 8.3.1 that I'd like to migrate to MS SQL Server 2005 (or maybe 2008), including both the table schema and the data. The database is about 50GB in size with about 400,...
6
votes
3answers
3k views

Maintenance plan for SQL Server Database Mirroring

We're using SQL Server database mirroring and we're trying to create a db maintenance plan to backup the database. The problem is that when the server is not the primary database the plan fails. I was ...
6
votes
6answers
3k views

How can I backup an SQL server (2000 and 2005) database?

Currently we backup our MSSQL 2000 and 2005 databases using software to copy files to tape nightly. Database sizes are 14-16Gb and 500Mb. As SQL server can backup a database to a file would we be ...
6
votes
4answers
5k views

PhpMyAdmin for Sql Server

Does anyone know of a similar tool as phpmyadmin for sqlserver ? Especially the data dump is very handy. But also updating etc, without needing to remotely logon etc. is nice.
6
votes
1answer
4k views

Does SQL server log shipping require a 2nd SQL license [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm currently working on a high availability solution for SQL Server 2008. I have 2 servers with 1 license of standard ...
6
votes
3answers
18k views

Why is “DbccFilesCompact” status is “Suspended”?

I am running SHRINK file on a 600G data file. Currently, status is reported as "suspended" and sys.dm_exec_requests.percent_complete for DbccFilesCompact command reports that it is running (but very ...
6
votes
3answers
6k views

Scheduled Jobs during hours of autumn time change

I'm wondering how other people deal with this scenario. What if you have a job scheduled to run at 1:30 am. In the autumn, when time changes, the hour of 1:00:00 to 1:59:59 repeats itself and so ...
6
votes
1answer
13k views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
6
votes
2answers
22k views

How to create an alias for a named SQL Server instance

On my developer computer I have an SQL Server instance named *developer_2005*. In the resource setting files of a C# application we are creating, the instance name is set to foobar (not really, but ...
6
votes
1answer
166 views

DL380 Gen9 which processor and what impact on NUMA

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 Gen9 8SFF which has 2 sockets, and 12 ...
6
votes
2answers
607 views

Windows File Cache drops suddently

I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory. SSAS relies to a ...
6
votes
2answers
457 views

sql server maintenance plan

What are the best practices for optimal database maintenance? is updating statistics necessary? (i think statistic update is on by default) how about reorganize indexes or just rebuild them? shrink ...
6
votes
4answers
770 views

SQL Server: How do you check if it's safe to change the SA password?

If I change the SA password for a Microsoft SQL Server, can I see in a log or a trace if some application somewhere is trying to log in with the old password?
6
votes
2answers
1k views

Which type of certificate for encrypting SQL Server?

Does it matter? We buy our certificates from Thawte, and I don't see a special type of certificate for SQL Server as opposed to a certificate you'd buy for a web server. Please be gentle with me if ...
6
votes
2answers
3k views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
6
votes
1answer
6k views

How to upgrade sql server express 2005 to 2008R2

Im using EF 4.1 in visual studio 2010, and I would like my sql server db on the server to be 2008R2 (because I want to use the migration tool from MS for EF in VS). Tool : http://visualstudiogallery....
6
votes
1answer
2k views

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance? Scenario is I have SQL 2008 R2 installed as a named instance MACHINENAME\...
6
votes
5answers
8k views

Double hop problem with sql server 2008

I'm trying to set up the following scenario. I have 3 servers, they are all in same domain. Server A has web application which runs under (domain) service account, dom\web. Server B has instance of ...
6
votes
4answers
5k views

SQL Server 2008 R2 Error 15401 when trying to add a domain user

I am trying to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type ...
6
votes
2answers
116 views

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What ...
6
votes
7answers
34k views

Can I run SQL Server Management Studio in Windows 7?

I've recently upgraded my OS to Windows 7, but this new OS wouldn't let me install SQL Server Management Studio. Is there a way to get around it?
6
votes
2answers
3k views

MediaWiki on MS SQL Server

I've been doing some digging on running mediawiki on sql server instead of MySQL, but haven't come across any concrete information. All of our servers are running SQL Server so I'd like to stick with ...
6
votes
1answer
908 views

What is the most efficient way to backup a directory full of large database backup files?

We use NetBackup here at Stack Exchange, and I'm working on revamping our backup policy to be more efficient. Currently, we use SQL 2008 R2 and have the SQL run maintenance plans to backup the data ...
6
votes
2answers
368 views

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. ...
6
votes
2answers
4k views

SQL Server: Statements vs. Batches vs. Transactions vs. Connections

My question is simple: What are the differences / similarities / cardinalities between Transactions Batches Connections and Statements in SQL Server? As far as I understand a connection is a ...
6
votes
2answers
1k views

Listing pending reboots in windows

I'm trying to install SQL Server 2008 on a Windows Server 2008 x86 system, and I'm getting an error saying "Rule 'Restart computer' failed." I've already found a lot of people saying to clear the ...
6
votes
2answers
331 views

SQL Server Management Studio Connect to Server List Editing

I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no longer in use, without having to set them all up ...
6
votes
2answers
6k views

SQL Server Connection Timeout after load brought onto IIS web server

We have MSSQL 2008 R2 running on windows 2008 r2 it's being hit by 2 server 2008 r2 webservers running asp.net. Both are joined to an active directory domain and use integrated authentication to ...
6
votes
0answers
260 views

SQL server language media doesn't support the language of the OS [duplicate]

While trying to install SQL server 2012, I get the error: "SQL server language media doesn't support the language of the OS" I've downloaded the SQL server 2012 in English language only (2 times to ...
6
votes
1answer
556 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...