1
vote
1answer
72 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 ...
0
votes
1answer
84 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. ...
0
votes
0answers
243 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
1answer
18 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' ...
0
votes
0answers
345 views

Very simple Update query hanged on one database but not on a mirror

A little background I am working with an ASP.NET MVC ERP-like Intranet application. It uses the Entity Framework technology for data access for a MS SQL server. We have 3 versions of the application ...
-1
votes
2answers
438 views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
0
votes
1answer
57 views

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException ...
0
votes
1answer
615 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
1answer
2k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
0
votes
1answer
77 views

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
1
vote
1answer
148 views

Can't connect to SQL Server 2005, even with local Server Management Studio

After setting up a second network adapter in the process of adding some SSL'd sites to ISS, my instance of SQL Server 2005 is no longer accessible - including through SQL Server Management Studio. ...
0
votes
2answers
123 views

SQL services wont start due to incorrect drive letter after windows restore

SQL services wont start due to incorrect drive letter after windows restore Had a server crash, was successfully able to reinstall windows and restore the server SQL and all the necessary services ...
1
vote
1answer
39 views

migrate old MS SQL 4.2 (circa 1992) db dump to MS SQL 2005

I have a cusotmer who sent me their database dump, which I'm supposed to import into MS SQL 2005 and have a look at. Unfortunately, it is (I am told) from MS SQL 4.2 (circa 1992), (which apparently ...
0
votes
2answers
240 views

Best way to upgrade Hard Disks holding SQL Data Files?

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following; Run a backup using Backup Exec on the D:\ Partition (This ...
1
vote
0answers
48 views

My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Databases I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, ...
0
votes
2answers
333 views

How to I limit sql user permissions to read only while still allowing stored procedure execution?

Here is my goal: create a login and associated database user with permissions to select (read only), and excecute stored procs that do no updating. A bit of backstory is that this is SQL 2005, and is ...
1
vote
1answer
63 views

Is my server lacking storage space?

Looking for some help here. I have two ASP.Net web applications using SQL Server 2005 hosted on a dedicated Windows 2003 server. One of the applications only receives around 100 unique hits a day, ...
1
vote
1answer
297 views

What's the importance of restoring SQL Server system databases (model, master, etc.)?

I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have ...
1
vote
1answer
256 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
0
votes
1answer
249 views

Troubleshoot IIS 6 and Intermittent SQL Server Connectivity Loss

I am not a System Administrator, but I am temporarily trying to fill that role. I have 2 Windows 2003 Servers. 1 server has my Microsoft SQL Database (SQL Server 2005) and the other is the web ...
0
votes
1answer
189 views

SQL Server database refuses to back up to USB disk

I have few databases on a SQL Server 2005/WS 2003 platform, and I have a curious situation that has arisen. I have been manually backing up the databases to a USB hard disk until about a week ago ...
1
vote
0answers
31 views

SQL Server Logs: missing date ranges

I need to be able to export SQL Server logs into CSV files, which I can easily do with the export function. However in doing so I've noticed there's a range of dates missing from the SQL Server logs ...
1
vote
0answers
194 views

SQL Server Keeps Logging/Writing to 'Setup Bootstrap' folder

I recently got a message from windows that my system was running out of disk space. After a quick search across the file system, I found out the SQL Server had logged 10GB of info in the folder ...
0
votes
0answers
206 views

Unique index failed?

Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
1
vote
2answers
597 views

Intermittent login issues to SQL Server

My website is an ASP.NET 2.0 website connecting to a SQL Express Database. Every now and then I get the following error message when I load my site. Login Failed for Username 'MyUsername'. Then ...
2
votes
0answers
130 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
0
votes
2answers
551 views

How to move the files of a replicated database (SQL Server 2008 R2) to a different drive

I would appreciate if someone could help me with the following problem: We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
1
vote
1answer
279 views

Remote Performance Monitoring SQL Server

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server ...
4
votes
1answer
851 views

Repair mssqlsystemresource.ldf

I accidently deleted mssqlsystemresource.mdf and mssqlsystemresource.ldf. I undeleted them both, but the .ldf file is corrupted (bad FGID), and because of this I can no longer start up my database ...
0
votes
2answers
275 views

High MSSEARCH Wait Type in SQL Server 2005

This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem. The server had been running with no problem for several weeks until the other ...
1
vote
2answers
396 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
1
vote
1answer
970 views

How to use AWE for Windows Server 2003 (32-bit) and SQL Server 2005 (32-bit)?

The server is Windows Server 2003 SP2 (32-bit), running SQL Server 2005 SP3 (32-bit). I believe the server has 4 GB of physical RAM. The machine has crashed twice in the last week and it is a ...
0
votes
2answers
376 views

Native SQL logins timing out at login validation phase

The default SQL Trace of my instances shows the following issue for native SQL logins (non-domain accounts): Network error code 0xe8 occurred while establishing a connection; the connection has ...
0
votes
1answer
429 views

Connect to SQL Server 2005 In Different Network

I need a help on SQL Server Remote Connection Issue. I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which ...
1
vote
1answer
359 views

Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?

The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
0
votes
1answer
1k views

SQL Server database connections being dropped intermittently

Occasionally in one of our production environments (we have a dozen or so without different clients pointing to each) we get exceptions at different points in the process. The code doesn't do ...
0
votes
2answers
61 views

adding columns to table results in 'low disk' error message

One table of our database has large amount of data. It has about 20 million records. We need to add 2 new columns into this table. We have 15 GB space on the drive. When we start the process to add ...
3
votes
2answers
147 views

Windows Cluster - Can I failover without disturbing SQL?

I have a 3 node cluster. All of the nodes are part of Cluster01 in what should be A/A/P mode. Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows ...
1
vote
1answer
277 views

Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?

Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general? If the database is backup ...
0
votes
1answer
96 views

SQL server 2005 Slow access

I got reports from users that the access speed has dramatically slowed down, when they try to access the database. Perfmon states: Cpu ~20% usage. RAM (3,5gb) 2.1gb in usage, 1.7GB for SQL HDD ...
5
votes
4answers
3k 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 ...
1
vote
1answer
154 views

SQL Server SPID and connection pooling

What is the max value for a SQL Server SPID? How long can a spid be dormant before connection pooling occurs?
0
votes
1answer
68 views

log file problem after query execution

Can someone of you experts please advise me on this situation: I have a dedicated hard drive. It contains the database and log file. I have run a query over night and the log file maxed out the size ...
-1
votes
2answers
2k views

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK ...
0
votes
1answer
158 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
1
vote
2answers
103 views

How to change to a new computer with SQL Server 2005 installed (100s of databases)

The old database server is getting tired, and I'm upgrading it to fresh hardware. What I need is an exact copy of the old ~100 databases to the new computer. I have read some about replication and ...
1
vote
2answers
346 views

How to migrate SQL 2005 to SQL 2008 R2 on new hardware with same server name

We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2. When all is said and done we want the same IP and hostname that was on the "old sql ...
0
votes
2answers
273 views

Killing a cross server SELECT query has lead to an indefinite KILLED/ROLLBACK process. What's going on here?

A long running query was being run on a SQL Server 2005 database which referenced tables on a SQL Server 2000 database. Both instances of SQL Server are running on the same machine. It was only a ...
0
votes
2answers
307 views

Configure SQL-SERVER without running service

Is it possible to change the location of the temp.mdf or other files without starting SQL-Server? I wanted to reactivate an old server but one of it's USB hard disk was been already used somewhere ...
3
votes
4answers
718 views

Lower the I/O priority for backups

I have a job that nightly runs a backup of all attached databases however it can bog the server down if someone is connected during that time. I have TONS of CPU overhead to work with (I am barely ...