Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
OPENXML : missing msxmlsql.dll
Posted by Fahim at 2/9/2006 9:19:26 PM
I am facing a problem with OPENXML. When I try to use OPENXML function I get
this error :
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 18
Failed to load msxmlsql.dll.
I'm running SQL Server 2000 with SP4 and I have SysAdmin privileges on the
server. I...more >>
Table locks from view
Posted by bsg075 NO[at]SPAM gmail.com at 2/9/2006 9:08:16 PM
I am working with a system that is encountering a significant number of
blocked processes, and occassional deadlocks. I believe I have a
solution, but I first need to confirm something about locking in SQL
Given an view with 5 table joins, and a SELECT statement that only
Posted by FJC at 2/9/2006 7:49:27 PM
We are running SQL2k and one of the users is accessesing one of the databases
through the front-end applications, the problem is that the connection is
never closed after the user closes the front-end application and the other
users' do....more >>
High Number of lock requests
Posted by FJC at 2/9/2006 7:37:27 PM
We're running SQL2K over 2K server, there server just has one main database
besides the system' ones for our administration system
Recently we got a tool for monitoring the server and it's registered up to
5.500.000 lock requests/min, my point is, is that normal?...more >>
BCP newbie question
Posted by Chris at 2/9/2006 7:37:25 PM
I am trying to run the bcp utility. When I run it from the command prompt it
works. When I try it from a bat it goes into this crazy endless loop
repeating the command again and again. Any ideas what I am doing wrong?
bcp pubs..publishers out C:\test.txt -c -U****** -P***** -S*...more >>
duplicate in text file
Posted by Johnfli at 2/9/2006 4:08:51 PM
I have my SQL server reads a text file into a temp table, then it copies
that data over to a main table, but it looks to see if a particular filed
has a certain value, if it does, it updates that record instead of creating
But, what I am finding is that if the text file has dup...more >>
Posted by Andre at 2/9/2006 3:47:29 PM
I'm looking at purchasing a new SQL Server - a Proliant of course. My
research tells me that the new Intel dual-core Xeon is the way to go. I'm
also hearing that the new SAS drives are the new standard, and also slightly
faster than U320 SCSI.
I'm wondering if anyone out there is using ei...more >>
Posted by michael at 2/9/2006 3:33:27 PM
Every morning at 8AM, my SQL Server 2005 produces some database backup that
is not a part of any "Job" or "Maintenance Plan". If you look in the Windows
NT Application browser, there is an Event: 1073760088, Source: MSSQLSERVER,
User: NT AUTHORITY\SYSTEM, Category: Backup, which occurs.
I h...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to connect to SQL Server Express db in SSMS??
Posted by egraham at 2/9/2006 2:33:09 PM
I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
able to connect to a SQL Server Express database within the SSMS. I read on
MS's website that this was possible, but can't figure out how to do it. Is
Tranaction Log Problem - Saving Table
Posted by jack-b NO[at]SPAM humlog.com at 2/9/2006 2:05:27 PM
I tried to alter a column in a table and received the following
The log file for database 'dbname' is full. Back up the transaction log
for the database to free up some log space.
I then backed up the transaction log via Enterprise Manager but this
had no effect - i ...more >>
SQL Express issue with McAfee VirusScan
Posted by Russ at 2/9/2006 1:53:30 PM
We've encountered episodes of SQL Server 2005 Express intermittently
"pausing" for up to 30 seconds on a PC (WinXP Pro, DELL 380) that was also
running McAfee VirusScan version 8. This occurred even after excluding all
SQL Server folders and file types from VirusScan.
Issue goes away immed...more >>
SQL Server 2K Linked Access 97 Server not working
Posted by David Kirkman at 2/9/2006 1:32:21 PM
An Access 97 linked server in SQL Server 2K has recently stopped
working. In Enterprise Manager, the following error message appears
when attempting to view the list of tables in the linked server:
Error 7399:OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB error trace [OLE/...more >>
maint plans xp_sqlmaint db bkups and using the backup commands
Posted by Victoria Morrison at 2/9/2006 12:25:33 PM
Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say...more >>
SQL2000 meltdown on its way?
Posted by gstar at 2/9/2006 11:56:05 AM
We have SQL 2000 running with several databases live to the public. In
the next few days our web developers are rolling out substantial
updates to the system and history tells me this could go badly wrong!
Presently I have a maintenece plan which does a complete db backup each
night and hou...more >>
Updates with max sequence
Posted by Matt at 2/9/2006 11:41:37 AM
Here is my table structure:
ID Sequence FName LastName Team
-- ---------- -------- ----------- ------
1 1 Bob Jones 1
1 2 Bob Jones 2
1 3 ...more >>
gateway dropping SQL Connection
Posted by Marvinq at 2/9/2006 11:33:18 AM
I need some serious help from any of you geniuses here. I have a
problem with an Access 2000 adp connection. I have users on that site
going through a gateway to communicate to our server and we are having
major connection problems. It seems that something on the network or
the g...more >>
SqlServer 2005: need help creating a new user
Posted by Steve at 2/9/2006 11:10:56 AM
I'm working with Sql Server 2005 express and the Management Studio Express.
I changed my server to use mixed mode, it had originally been installed with
just Windows Authentication, but I realize now to connect outside of our
domain I need to have mixed mode.
I have been trying and trying t...more >>
SQL Server 2005 Hanging
Posted by Amos Soma at 2/9/2006 10:13:36 AM
We run a .NET (C#) application every night around 3:00 AM that creates a new
empty database and then executes roughly 3000-4000 SQL statements to create
the schema for this database (tables, stored procs, views etc.). Sometimes
this process works without error. Other times SQL Server 2005 hang...more >>
"SQL: The Complete Reference" source?
Posted by SteveH at 2/9/2006 9:50:51 AM
I purchased a used copy of the SQL book listed in the subject but the
CD is missing. I have access to SQL Server 2000 and so don't need the
trial software but would like to get the source for the database used
in the examples. Does anyone know where I can get this?
Reversing a soundex result
Posted by almurph NO[at]SPAM altavista.com at 2/9/2006 9:45:58 AM
Hope you can help me with this one. Given a soundex value like:
"M500" how can you tell what the original value was as a charcter
string? In other words, how can you go back? (inside query analyzer??)
SELECT soundex('help') = H410
but if I was given H410 - how do I determ...more >>
Unable to read local eventlog (reason: The parameter is incorrect)
Posted by Brooster at 2/9/2006 8:57:24 AM
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Time: 9:34:06 AM
Unable to read local eventlog (reason: The parameter is incorrect).
For more information, see Help and Support Center at...more >>
60 GB tempdb not shrink after sql restarted
Posted by Steve777 at 2/9/2006 8:47:35 AM
SQL 2000 Enterprise Edition running in active/passive cluster. Restarting SQL
server couldn't shrink the huge tempdb. Tried DBCC SHRINKFILE with no luck.
Anyone knows if Method 1 in KB 307487 applies to cluster environment? I am
sure the steps listed in Method 1 works for a stand alone built....more >>
Problem sheduling Maintenance Plan (Backup)
Posted by MGW24 at 2/9/2006 8:45:30 AM
I'm trying to create a SQL Maintenance Plan to backup the databases and
schedule it to run at 10:00pm every night. I can create the backup job just
fine, but when I try to shedule it, I get an error saying:
Guid should contain 32 digits with 4 dashes
Posted by Bil Click at 2/9/2006 8:41:37 AM
I am trying to increase the performance of a SOUNDEX search on lastname
column in a table with about 28 million rows. I thought about adding a column
preloaded with the SOUNDEX value for lastname, such as 'lastname_soundex'.
But I cannot see how to force the DIFFERENCE function to use that s...more >>
How can i create a serer role
Posted by blurk at 2/9/2006 8:26:30 AM
I want to create a new server role. How can i do it ?
Showing column values
Posted by mainspring at 2/9/2006 8:11:26 AM
I am using SQL Server 2000 with Windows XP PRO. When I run Enterprise Manager
and select a table then request to have all rows returned I get my view and I
have all the info for all the columns except any columns that seem to be of
the 'uniqueidentifier' data type. I have the columns listed, b...more >>
LSASS.EXE high CPU usage
Posted by The Vogon at 2/9/2006 6:36:27 AM
I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes ...more >>
different kind of Indexes for different tables
Posted by maxzsim via SQLMonster.com at 2/9/2006 3:09:36 AM
I read in Oracle that each table's can have it's own kind of indexes e.g IOT
, BitMap , B-Tree for different purposes used by Application.
Is there such function(s)/options in SQL Server ?
appreciate ur advise
tks & rdgs
Message posted via SQLMonster.com
In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables.
Posted by Daniel at 2/9/2006 1:40:09 AM
In TSQL how to use OPENXML to open an ntext field in a table? I can not read
the ntext into a local var as TSQL does not allowe ntext local variables.
Yukon xp_cmdshell setting
Posted by Vaibhav at 2/9/2006 12:00:00 AM
How does Yukon keep the information about the security context of
xp_cmdshell (user or agent) ?
How can we retrieve it ?
I could not find a registery setting for that.
Thanks a lot in Advance
Posted by beachboy at 2/9/2006 12:00:00 AM
I am setup a replication from DB_A(publisher) to DB_C(subscriber), but I got
a problem after replication created
Table1 in DB_A, i tried to add a new data field. but DB_C can't see new data
field after snopshot done
Is any method can synchronizate new scheme and new t...more >>
restoring 2000 backup to 2005
Posted by luna at 2/9/2006 12:00:00 AM
trying to import 2000 bak file into 2005, and im getting this error, any
ideas ? - seems a pain getting my old data into the 200 server!
Restore failed for Server '********'. (Microsoft.SqlServer.Smo)
For help, click:
Multiple Job Steps SQL 2000
Posted by Gramps at 2/9/2006 12:00:00 AM
I have 3 DTS packages I want to run after each other, in no particular
I have x3 jobs, each running one of the DTS using CmdExec.
I don't want to run these jobs on individual schedules. I also don't want a
single DTS package with x3 steps to achieve the same thing.
I want ...more >>