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

0
votes
3answers
4k 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 ...
0
votes
1answer
1k 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: ...
2
votes
0answers
34 views

Data access tracing but no events are logged

I am trying to trace data access. The configuration I have is based on this excellent article. http://msdn.microsoft.com/en-us/library/aa964124%28SQL.90%29.aspx#data_access_tracing_topic2 The ...
0
votes
2answers
529 views

DHCP address leases to SQL Server database?

Is it possible to store the DHCP address leases in Windows 2003 to SQL Server database??
0
votes
1answer
49 views

i am getting the following error MSSQL$SQLEXPRESS Application log on my server

TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. ...
0
votes
2answers
2k views

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection

Sql server is in Mixed Mode and I changed the user Password through Windows Authentication Mode from Security. After that when I try to connect the server it throw the error TITLE: Connect to Server -...
6
votes
3answers
11k views

How to monitor activity on a single table using SQL Server profiler

I have a table which uses and identity seed for its unique identity column. We have noticed some massive jumps in the identity value which we are not able to explain. The table has 20,000 odd rows, ...
7
votes
1answer
10k views

How can a Perfmon “% Processor Time” counter be over 100%?

The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
-3
votes
3answers
60 views

Notify User When DB Autogrows [closed]

I am having some issues with my DB autogrowing because of transaction log sizes. I have implemented a DB maintenance procedure where the transaction logs will be truncated regularly so this should ...
3
votes
2answers
2k views

SQL server 2005 attach without transaction log - urgent !

We had a crash in the sql server and the database remained in inconsistent mode. We lost the transaction log file and the last generated backup is too old. I googled this issue but mostly relevant ...
2
votes
1answer
725 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
0
votes
1answer
645 views

SQL Server 2005 Express: upgrading to SP3 in mixed-mode installations

I'm having trouble upgrading SQL Server 2005 Express SP1 to SP3. The SP1 install uses mixed mode authentication (so there is an sa password). This is the message I get: TITLE: Microsoft SQL Server ...
1
vote
2answers
259 views

SQL Server Error: Failed Assertion = ‘m_iteratorInSafeState’

We have a client running our .NET application which connects to SQL Server 2005 on the backend. A few weeks ago the database crashed and the whole server had to be rebooted. This happened again today ...
1
vote
0answers
98 views

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

After moving a package to another server, I am unable to run it from a stored procedure using xp_cmdshell or from a job. The package exists in the file system, and I added it to the SSIS Package Store....
2
votes
4answers
493 views

Sql Management Studio 2014 wont connect to clustered instance

I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-...
1
vote
4answers
1k views

How do I delete a differential backup?

I often like to create backups when testing the software I work on, and will sometimes create a differential backup if I want to be able to get back to multiple previous states. However, sometimes I ...
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 ...
1
vote
1answer
29 views

Export data from Microsoft SQL Server

I have an application that uses a database Microsoft SQL Server running on PC1. I set up that application on another PC (PC2): I installed the application on PC2 The application creates the ...
0
votes
0answers
9 views

sqlserver is always mapped to nobody on samba when doing backup to UNC path

I have an issue in the configuration, I guess. Due to the fact that the user is always mapped to nobody, I have to set the chmod for the backup folder to 0666 which is the number of the beast and ...
2
votes
4answers
5k views

What is causing a vm to exhibit packet loss?

We have a pretty nice piece of hardware set up to run multiple virtual machines in vmware and one of the vm's is an instance of Windows Server 2003 running SQL Server 2005. For some reason we ...
1
vote
2answers
315 views

SQL Server read-only user can connect local but not remotely

I have a SQL Server where admin users can connect locally and remotely, but read only users can only connect locally and get a "Login failed" error when connecting remotely. It's using SQL Server ...
0
votes
1answer
3k 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. ...
1
vote
1answer
29 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
5
votes
2answers
5k views

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them ...
0
votes
0answers
21 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
0
votes
1answer
10 views

How to obtain all (or last few) messages for a failed job in SQL Server 2005?

In the SQL Server Agent for SQL Server 2005, I have a job that only has one step, which runs a stored procedure. When the stored procedure runs to completion, it produces about 500 messages (not ...
3
votes
5answers
10k views

Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was. SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: ...
3
votes
3answers
9k views

Can't see all catalogs on a MSSQL Linked Server

On SqlServer 2000 I have created a Linked Server to a SqlServer 2005 machine, with "Server type" set to "SQL Server" (first radio button), and the linked server name set to the remote machine's ...
0
votes
5answers
6k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
0
votes
0answers
66 views

SQL Server 2005 setup unexpected failure during setup

I'm trying to install SQL Server 2005 Enterprise on Windows 2003 R2 SP2 (ESXi 5.0.0 guest). After installation of backward compatibility files and prior to MSXML6, I receive this error: There was an ...
1
vote
2answers
411 views

SQL user not associated with a trusted connection

I just set up a new server with SQL Server Express 2005, and I want to connect remotely. I set both Windows and SQL logins. I modified so both local and remote connections are allowed. I restarted ...
13
votes
6answers
38k views

How do I change the collation of a SQL Server Database?

I'm trying to standardise all databases on a single collation - Latin1_General_CI_AS (the standard collation). I have some databases that are in SQL_Latin1_General_CP1_CI_AS. I know I can use ALTER ...
2
votes
2answers
9k 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
0answers
148 views

Reducing the initial size of the transaction log

We have a database (in production) where the initial size of the database was set inappropriately large (28GB). If I right click on the database in SQL Server management studio and attempt to shrink ...
4
votes
3answers
2k views

Log perfmon data to SQL Server

I am trying to log perfmon log (Windows Server 2008) to SQL Server 2005 (Windows Server 2003) using dsn (SQL Server authentication). On start perfmon counter i am getting error: "Call to ...
1
vote
5answers
7k 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 ...
2
votes
0answers
23k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
2
votes
1answer
503 views

Is ODBC on Windows 2003 slower than on Windows 7?

I am seeing some MSSQL 2005 performance issues, and I am trying to diagnose the cause. I am using SQL Profiler to gather query execution times. Both the client app (using ODBC), and the SQL server are ...
1
vote
5answers
4k views
5
votes
6answers
11k views

How to find when the stored procedure was deleted and who deleted it?

Actually, one of the critical jobs failed while executing. In the error message it was found that the failure is because it was missing a stored procedure. Now how do I find out when was the stored ...
0
votes
1answer
38 views

Database log file corruption in SQL Server 2005

I've been going through data corruption from last 2 days in row that .ldf getting corrupted and I've to fix it. I did my research that I need new server and management studio because whatever we used ...
1
vote
1answer
2k views

What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?

We plan to change the default server options of an SQL2k5 server instance by enabling data access. The reason is that we want to run "SELECT * FROM OPENQUERY(LOCALSERVER, '...')" -like statements on ...
9
votes
7answers
27k views

How much RAM does a server actually need?

I have a quite a few servers deployed around the world. They are running Windows 2003 x64 with SQL Server 2005 x64 with 6 GB of RAM. The boxes do not have the best (or even an acceptable) ...
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 ...
3
votes
3answers
14k views

SQL Server Linked Server RPC Options?

When setting up a linked server in SQL Server (we're on 2005), you can set two server options: Rpc Rpc Out Looking at the MSDN article, all it states is: RPC - Enables RPC from the specified ...
-1
votes
1answer
196 views

Why are server authentication mode options are greyed out in Sql server 2005

I tried to search for the solution but couldn't find any. Please help me understand why the server authentication mode options are greyed out in Sql server 2005. I want to allow SQL Server login mode
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 ...
1
vote
5answers
2k views

User not functioning after backup and restore of database to another server in SQL Server 2005

We have a database called 'foo' on the first sql server instance called 'SQL01' that is backed up nightly via a snapshot with Snap Manager for SQL Server and then flex cloned and restored to a second ...
20
votes
3answers
28k views

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and ...
0
votes
1answer
268 views

T-SQL Code to backup database with multiple files failed

I'm trying to write an automated script that will allow me to backup the database to a NAS with multiple files. I just started to use T-SQL. My objective is to automatically calculate the size of the ...