Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 24, 1999

SQL Sam and the Phantom Connection - Part 1 (with clues) - Page 2

By Steve Hontz

SQL Sam and the Phantom Connection - Part 2

Environment: SQL Server 6.5, SP5a

"What does your scheduled task look like?" asked Sam. "And what is the failure message?"

"Well, the TSQL command I'm running is...

load database testDb from disk='f:\mssql\backup\weeklyDump.dat'

...and the failure message I'm getting is ' A CLUE! Database in use. System Administrator must have exclusive use of database to run load. (Message 3101)' But there can't be anyone in the database; I'm the only user on the system."

"Hmmm..." mulled Sam. "Have you tried running sp_who or sp_who2 to see if there are users in your database? You might be surprised...it might be you, if you have any query windows open on that database."

"Sql Sam, you're the greatest!" exclaimed Jimmy. "I'm sure that's it!" Jimmy scurried off to make sure he wasn't connected to the database.

A little while later, Jimmy came back, his shoulders slumped. "Well, that seemed like the problem... I had two query connections open. But I closed those, and I still get the same failure. I even ran sp_who before and after I ran my task, and there wasn't anyone in the test database. All my connections are connected to master. There must be A CLUE! some sort of phantom connection that I can't see."

"Let's look at your scheduled task, Jimmy," said Sam. They opened the task up in the SQL Enterprise Manager:

"Ah-ha!" said Sam. "Not all of your connections are to master!"

What did SQL Sam see? Go to the solution now!

Review SQL Sam and the Phantom Connection - Part 1

Back to SQL Sam Cases

Steve Hontz is President of The Bit Corner, Inc., a Phoenix-based consulting firm specializing in Windows NT, C++, and SQL Server development. You can reach him at steve@bitcorner.com.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM