Hi, 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 >>

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 Server 2000. Given an view with 5 table joins, and a SELECT statement that only referen...more >>

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 >>

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 >>

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? Regards, Chris. bcp pubs..publishers out C:\test.txt -c -U****** -P***** -S*...more >>

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 a duplicate. But, what I am finding is that if the text file has dup...more >>

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 >>

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 >>

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 it possible? Thanks. ...more >>

Hi there, I tried to alter a column in a table and received the following message: 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 >>

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 >>

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 >>

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 >>

Hi, 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 >>

Here is my table structure: ID Sequence FName LastName Team -- ---------- -------- ----------- ------ 1 1 Bob Jones 1 1 2 Bob Jones 2 1 3 ...more >>

Hi guys, 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 >>

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 >>

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 >>

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? ...more >>

Hi everyone, 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 >>

Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date: 2/9/2006 Time: 9:34:06 AM User: N/A Computer: PROSPERO Description: Unable to read local eventlog (reason: The parameter is incorrect). For more information, see Help and Support Center at...more >>

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 >>

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 (xxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx...more >>

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 >>

hello, I want to create a new server role. How can i do it ? kind regards blurk ...more >>

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 >>

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious problem. 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 >>

Hi , 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 http://www.sql...more >>

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. ...more >>

Hello, 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. Please help. Thanks a lot in Advance Regards, Vaibhav ...more >>

Hello all, I am setup a replication from DB_A(publisher) to DB_C(subscriber), but I got a problem after replication created Example: 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 >>

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: http://go.microsoft.com/fwlink?ProdName...more >>

Hi, I have 3 DTS packages I want to run after each other, in no particular order. 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 >>