Hello We have been successful in installing a Windows 2003 Enterprise Server 2 node cluster and successfully installed SQL Server on Node A and the added Node B to the SQL Cluster. When we try to install another instance in Node B with an instance name(DB), the installation fails while trying to...more >>

I am looking for a way to output the results of a query to a text file. Can I do this via statements in my query or do I have to use DTS? examples would be appreciated. Thanx...more >>

I cannot Kill an SPID in SQL server 2000, what could be the problem? Sp_who shows KILLED/ROLLBACK i n cmd column. Pl help...more >>

Hi I need to manage a SQL cluster, monitor database and O.S performance and apply database patches. Do I require local admin rights for this? If not what is the workaround please? Problem is, my organisation is very reluctant to grant local admin rights. Is there a Microsoft article on th...more >>

When using SQL 2000 personal desktop (i.e MSDE) on win 98 Machine with our VB6 application we sometimes get this error [Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: Provider DLL failed to initialize correctly. On Win2000/20...more >>

Is it possible to make available to several administrators a custom SQL Server Enterprise Manager MMC containing 80 server registrations? I would like to avoid having to manually recreate the console on multiple machines. I tried distributing the .MSC file and exporting and importing the follo...more >>

I just installed Office 2003 pro and choose the option to replace my XP installation. I now have two MS messenger icons in my tray - one with a red x and no SQL server session starter icon. It is hard to believe that the two are related but thats's what happened. I need to know how to get the S...more >>

hello please help because I can not find solution myself I have a few tables and I defined on some foreign keys with ONDELETE CASCADE problem is that I'm getting an error that "it may cause cycles or multiple cascade paths" I understand what it means, but that's what it is, there are a few ta...more >>

Hi there, I am interested to explore the MSSQL databases uptime monitoring and would like to publish the indicators in web UI, does anyone has done this before or having any idea how to do it? thanks. ...more >>

Can MSDE be a replication subscriber? What about a publisher? Thanks. ...more >>

Hi all How do I send a script to a SQL 7 engine? I want to script a DB backup Thanks!...more >>

Hello everyone, I have a large file about 75,000 records each with about 3 elements and 1 variable. I need to know how to insert this entire file into an existing table, or new table or anything as long as it is moved from the XML to the msSQL. I read into OPENXML and all that in books onli...more >>

Unpacking works fine. However, the installer never takes off, but complains that I must reboot because there are pending file installations. Multiple reboots in vain. Running XP Pro, Administrator account on an IBM Thinkpad. Does anyone know how to get past that spot? Bjorn Mossberg...more >>

Hi everyone, I was installing the SP3 to the RTM version of the SQL SERVER 2000 and during that process an error ocurred: "Error running script: sp3_serv_uni.sql(1)" When I clicked on the ok button the setup shut off and I tried to restart the service (I stopped it before begining installat...more >>

Hi All, I am trying to import database from SQL7 to SQL2000 using the tool. it looks normal but no SPs and Views and transfered and those not even in the list when I run the transfer tool. and idea? TIA Jerry Qu ...more >>

I am trying to setup my SQL server and I want to plan the backups My ideas were to create a sys_dat_bak device for the full backup of all the system databases (master, model, msdb) and a sys_logs_bak for the transaction log backup of the model db. The backup files created by MS SQL server woul...more >>

I can't seem to get outlook 2000 configured properly on a Windows 2003/SQL 2000 box to send email notifications about my maintenance jobs. I had no problem when using Windows 2000/SQL 2000. What is the best/easiest way to get email notifications of failed maintenance jobs other than using Outl...more >>

i have a DSN created on the SQL Server machine itself. Using my favorite ODBC sql query tool, i can select the System DSN, specify a login and password, and type a select statement and it all works. i go into SQL Server, and want to create a linked server to this same ODBC DSN: Linked server =...more >>

Hi This might be a trivial question, bit I'm not that experienced in updating from a table in another database. We changed a number of records in a table, and unfortunately we did a mistake so too many was changed. I've now restored a backup from last night and wants to update the database ...more >>

Hi all I want to backup my database via script. I want to use something like BACKUP DABASE mydatabase TO DISK = 'C:\DB_BACKUP\mydatabase.bak' Then I back up the file mydatabase.bak with my normal backup software. I tested it and it looks like it is working. Questions: 1) If I us...more >>

Is there a way to see 1. If a view is in use. 2. when it was used last? Thanks. Regards Jonas ...more >>

Hello I have a point in time Microsoft SQL Server 2000 .mdf data file which was taken from a snapshot. Basically, it is the database at a point in time, which I can attach to and view data no problem in a sql server. I also have hourly transaction logs which occured after the above .m...more >>

Hello All, I am a SQL server newbie, so please try to answer in simple terms. I am trying to copy databases from a SQL 2000 (Win2k) to another SQL 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up getting the familiar "Failed to create OMWWIZE share" error. I've set up m...more >>

We are moving an older server to a new box. We will also change our disk/folder layout of all database files to distribute IO etc.. There are about 100 user databases with a lot of logins and jobs. I need your opinion if my plan will work out. 1. Disconnect source server from network and stop ...more >>

Last night, we had a sql server (2000, sp3) whose transaction logs get backed up to a share have the log backup jobs fail. At the same time, a database that is a replication publisher became unavailable. We were getting the following errors in the sql server error log but this error was written ...more >>

Hello eveybody ! I have a small problem with my logs on sql server . Even after a backup (lod and/or db), server seems to not truncate his logs ... so they're growing each days, and need to be deleted manually. Any ideas ?...more >>

I have a large database that gets a full backup every night. We utilize Log Shipping from this database to another database on a reporting server. During the day Log Shipping creates log files on the local server and truncates the transaction log for the database. Everything works great. Let...more >>

HI i have installed VisualStudio Sp6 after this installation when open my Sql 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows don't work. I reinstalled Sql Sp3 but don't work. Can help me? Tia Pupo ...more >>

Hi I have been asked to look into getting a SQL Audit application to view who changed what data, from what workstation and the date and time it was changed. Apex SQL Audit seems to be the only tool i can find for the job. I would like to compare this with another application. Does anyone...more >>

I have a problem with a query. When I omit the TOP clause I get more rows returned than I expect (12 rows out of a 119 in the table), but when I include TOP I get 5 rows from the same data with the otherwise unchanged table. Thing is, the query where I include TOP 1000 is the correct result. ...more >>

We have a table which generally contains about 300K rows. Each night we need to delete obsolete rows (could be as many as 20K-30K). I've noticed some blocking because this delete is originally done in 1 single delete statement. I want to re-write this to break it up into "chunks" where it l...more >>

I have a stored procedure that uses cursers. This stored procedure executed by a user from MTS server. At times, when I refresh the 'Current Activity' and look into 'Process Info' window in EM, I see two process ID (ID 54) for the same stored proc. Shouldn't the ID's be unique and assigned...more >>

Hi all I'm trying to track down a copy of the file s80305i.exe for use in SQL server 2000 upgrade and was wondering if anyone knew of a locatio as it is a broken link on the Microsoft website. My email is ian.hayward@preferredmortgages.com if anyone could email m a copy. Many thanks in...more >>

Hi i am getting the this error now a days. can help me out because my IIS server geting very slow & also i have to restart the IIS Server every time also when this DLHOST coming that time My IIS server get Problem. can help me out & give us what could be the problem it is very urg fo...more >>

Hi i am getting error. i dont understand what is this error can any one help me out & tell us why this error is coming here i am attaching the below error for Ref.. DMI Indication Event Type = Cable unplugged/No LAN activity Component Name = Intel Ethernet LAN Adapter(s) Group ...more >>

Hi i am getting error on my server every time. can any one tell me what this error & why it is coming every time here i am attach the error log files for your Ref.. The server was unable to add the virtual root '/TPlus' for the directory 'D:\tplus' due to the following error: The ...more >>

Hi, I need to create a duplicate of a database (with diffent name) and do some tests on that, i tried to restore it with different name but didnt work, does anyone know how to do that. Thanks in advance-Rob...more >>

I am having a SQl satement as If(Object_ID('DBName.Dbo.##TEMPDelete')) is not null Drop table ##TEMPDelete SET @Name = (Select replace(@Name,' ','_')) Set @SQL = 'Select top 1 Address as AddressTemp into ##TEMPDelete from '+ @Name + ' where eid = '+ @eid Exec (@SQL) Set ...more >>

We have a peculiar issue: Server: SQL Server 7.0 On windows 2000. Backup policy: Daily Nightly backup: Full Database backup Hourly backup for all the transaction Logs. All the DB backups and transaction log backup are created using the Maintenance Plan wizard. For one database...more >>

How do I get the physical size of all individual indexes in a database. Thanks in advance. ...more >>

I want to know whether or not netbackup or tape backup was successful by runnign the script in sql query analyzer....more >>

Hi, Our company has an average of 800 processes at any time and goes to 1000 at peak time (found from sysprocess). Almost 25% of these processes have waittype as pageiolatch_sh at any given point of time. Does that mean that we have an IO bottleneck because of the query waiting for the data to...more >>

probably a very easy question to answer: which client component do i have to use in order to send queries to a remote sql server and receive the resultset, how can i start this utility?...more >>

My database 's marked suspect when I restart my computer. It's too bad I don't have backup. Thanks....more >>

Hi, Can I create a database with the .mdf (data) and .ldf (log) on 2 different disk drive? Is there any benefit of doing it in term of performance? How about backup and recovery? Thanks. ...more >>

I have a hot spare database that I'd like to query, but I don't want it to be out of sync with the transaction logs of the live database. How do I take it out of loading (status 32) without having it do a recovery? I want to be able to switch it into 'query-able' mode, use it, and then put...more >>

Hello all, Can some one please help me with this backup error. We are runng SQL2000 sp3a. We copied our database to a new server (windows 2000 server to windows server 2003). Everything was ok. No errors. On the new server when i try to backup to a tape i got this error message. Microsoft...more >>

I am trying to run a sql statement that executes some drops and inserts. Upon running, I immediately get the above error with the following explanation: Data on dump will not fit into current database. Need 620 Mbyte database. What does it want? This is a legacy system I inherited, and I ...more >>

I have an exclusive lock and I don't know how to remove it....more >>

Hello, I have a table with about 5 milion records, and the performance is = un-acceptable (more than 45 seconds for a query). The table was imported = from a text file. I have defined a primary key (two varchar(20) = columns). Then I checked and the database has created a clustered index = on t...more >>