Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

learn more… | top users | synonyms

1
vote
1answer
680 views

How to filter columns in SQL Server replication?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
1
vote
3answers
3k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
2
votes
5answers
5k views

SQL Server 2008 - 2005 Compatibility

I want to use SQL Server 2008, but I'd also like to maintain a fall back position of switching back to SQL Server 2005. I know I cannot backup 2008 to restore 2005 and detach/attach won't work - what ...
0
votes
2answers
295 views

SQL Agent started with local user account can't run job with domain user account

I have SQL Agent running under a local user account. Jobs runs well if I used Local account credentials for the cmdExec step. If I try to use a domain user account (created previously in proxies ...
3
votes
2answers
657 views

How do I recover a dropped table from SQL Server Express 2005?

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a ...
5
votes
5answers
14k views

Calling sp_start_job from a stored procedure

Our developers need to be able to start a SQL Server Agent job from their .Net code. I know I can call msdb..sp_start_job to do just that, but I don't want to give general user accounts direct access ...
1
vote
2answers
4k views

Can I view my MSSQL connection string from within SQL Server Management Studio?

I'm using SQL 2005, and was helping someone debug a connection issue today. I thought that I could view my current connection string from inside SQL Management Studio, but can't seem to figure out ...
6
votes
0answers
411 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 ...
0
votes
3answers
3k views

Access to the remote server is denied because no login-mapping exists

I've got a Linked Server in my SQL Express install that is using SQL Server Authentication. I've created a SQL Server login-mapping and it's using Impersonate. I've confirmed that the account exists ...
3
votes
4answers
13k views

How can I detach a database that is in use?

Even though nothing is using it I am unable to detach a database because it is use. Cannot detach the database 'DEMO' because it is currently in use. I have tried rebooting and get the same ...
4
votes
1answer
132 views

List of things to check before turning on SQL Server CLR?

I am trying to deploy a CLR function (which computes a hash of a text or a file, not available from SQL Server) for the first time on a production server. I was able to test the function on a ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
4
votes
2answers
979 views

How to create aliases without installing SQL Server 2005 Client Tools

I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so ...
0
votes
3answers
861 views

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The ...
1
vote
1answer
326 views

MSSQL 2005 Snapshot Agent Uses 100% CPU

When setting up a new subscription to a publication (transactional replication) from 64-bit SQL Server 2005 to 64-bit SQL Server 2005 the Snapshot Agent on the publisher consumes 100% of the CPU. I am ...
-1
votes
1answer
49 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
0
votes
4answers
2k views

Backup single table MS SQL SERVER

How to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to ...
2
votes
3answers
7k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
2
votes
2answers
4k views

Change Windows Authentication user for Sql Server Management Studio

We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this ...
0
votes
0answers
361 views

Microsoft ODBC SQL Server Driver [DBNETLIB] error from client desktops connecting to SQL Server 2005 databases

Problem We have a program installed on numerous client computers making database connections to SQL Server 2005 databases running on a Windows 2003 Server. Client computers are Windows 7. Recently ...
0
votes
0answers
36 views

Can't connect our ERP Database to MSSQL Server 2005

We have a Windows Server 2003 R2 using SQL Server 2005 Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33) Neither IP has a problem connecting to the Server, their ping is ...
1
vote
5answers
2k views

DBCC: The database could not be exclusively locked to perform the operation

I run DBCC CHECKDB ([MyDb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, PHYSICAL_ONLY And after 20 seconds it fails with an error: Msg 5030, Sev 16, State 12, Line 1 : The database could not be ...
0
votes
0answers
16 views

SharePoint Services 3.0 stops same time and day weekly

We have SS3 running on a Windows Essential Business server and weekly at the same time & day, SharePoint will go down with a trail of error messages. At first glance it appears to be an issue ...
1
vote
0answers
47 views

Why does ADFS have too many SQL connections open?

I'm running ADFS 2.0 in Windows 2008r2, connected to a SQL Server 2005 database server. Right now the ADFS server has 5623 TCP connections open to the SQL server (checked via netstat - counted with ...
1
vote
3answers
148 views

Window Server 2008 R2 dropping 2GB of hard disk space per day

I have a Windows Server 2008 R2 virtual machine running MS SQL 2005 on top of a VMWare ESXi 5.5 host on a SAN datastore. Consistently it has been "losing" 2GB of hard disk space per day and I can't ...
0
votes
1answer
310 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
3
votes
1answer
29 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
1
vote
3answers
4k views

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB ...
0
votes
2answers
1k views

Added a custom SQL Server login to Microsoft Dynamics CRM 4.0, getting empty resultsets

At work we have Microsoft Dynamics CRM 4.0 installed and employees use their LAN login to log into CRM's web interface. We've added a SQL Server-based custom login (to the server and db *_MSCRM) with ...
1
vote
1answer
193 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
5
votes
5answers
1k views

SQL2005 Stuck in Single Mode User

Hey currently have a database stuck in single mode after setting it to single mode to attempt to try take if offline which I wish I never did.... I tried ALTER DATABASE DB SET MULTI_USER but get ...
0
votes
1answer
1k views

Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8

I'm getting the below error while insert record into a SQL 2005 SP3 DB. Msg 845, Level 17, State 1, Line 1 Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8. ...
3
votes
3answers
98 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
2
votes
1answer
2k views

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server. The log ...
6
votes
1answer
81 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
2
votes
4answers
423 views

SQL Server Monitoring Packages [closed]

I'm looking into purchasing a SQL Server monitoring system. It should work with 2005/2008. We would like to monitor performance, availability, backups, jobs and various database issues (space) What ...
0
votes
5answers
3k views

How can I disable the windows authentication mode of SQL Server

How can I disable the windows authentication mode of SQL Server and restrict it to ask for username and password every time, with no windows authentication?
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

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 time and there are ...
1
vote
2answers
2k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...
3
votes
4answers
8k views

MSSQL error: consistency-based I/O error - can it be caused by an MSSQL or OS problem?

This is what I saw in the windows error log: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x19fedd20; actual: 0x19fed5e3). It occurred during a ...
0
votes
0answers
40 views

Cannot login as sysadmin (SQL Server 2005)

I am having a problem to access the SQL server with my domain account 1) I used sa account to login to a SQL 2005 server in SSMS. 2) I added my domain account (as domain\user) using integrated ...
0
votes
0answers
532 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
1
vote
2answers
5k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
0
votes
1answer
183 views

SQL Server 2005 Linked Server using SSMS from laptop vs RDP

I connect to work network via Cisco VPN from my work laptop, which is on AD. Edit I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect. I can even connect from ...
3
votes
1answer
252 views

How to hide a connection string in the DMZ

We are setting up an IIS Server on Windows Server 2012 in a DMZ, running off-domain. This server requires access to SQL Server 2005 on the other side of the firewall, inside our domain. We plan to ...
1
vote
1answer
22 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
1
vote
0answers
24 views

How much memory / processors will cause SQLCLR to fail to load?

I'm considering enabling SQLCLR on our SQL2005 production server, however technet states: Computers configured with large amounts of memory and a large number of processors may fail to load the ...
2
votes
0answers
225 views

MSSQL Database Mail Log is flooded with errors (20-30 per second) when mail server goes down

We're using SQL Server 2005. Every so often our mail server goes down, and when this happens, as soon as our SQL code tries to send dbmail, the Database Mail Log has an item which looks like this: ...
-1
votes
1answer
1k views

How to configure a trusted connection between IIS 7 and SQL Server 2005?

How do configure a trusted connection between IIS 7 and SQL Server 2005? My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a ...