Sometimes (but not always), "dbo" user will be lost after having a database restore, how can I make the "dbo" user appear again ? ...more >>

I have a dev box running at home. The box is configured with Win2k Advanced Server, with sp4 and all security updates. It also is running SQL 2k Enterprise Edition with sp3a. It sits behind a Linksys firewall that is usually sealed tight. I typically only keep 2 ports open; 5900 for vnc and ...more >>

Hi, I am getting error 1802, CREATE DATABASE failed. Some file names listed could not be created. Check previous errors. I have Windows 2000 professional installed on my PC. I am installing remedy 5.1 that uses MSSQL server 7 and I am getting the error above on remedy instalation... ...more >>

Hi, I hit a message 'could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. ' when I ran backup/restore process. The process has been terminated/aborted...more >>

We find that when a Windows XP client user changes their network/windows password(s), then their Enterprise Manager loses all server registrations There is no problem getting them registered again, but why do they get lost in the first place This doesn't happen with NT based clients....more >>

Hi, Any one can tell me is it true that The SQL Server in Windows Small Business Server 2003 Premium Edition have a limitation on building a database can not bigger than 10G. It is difficult to find such info. in MS web site Please help, thanks a lot TO...more >>

Can anybody tell me are there are stored procedures or system tables show me : (1)The hard disk space allocated to a database. (2)The hard disk space used on a database (3)The hard disk space allocated to a database's transaction log (4)The hard disk space used on a database's transaction log...more >>

I have a database with a lot of old records i want to delete. when i try to make the delete, i get the timeout message. I don't care that the delete job will run several hours, but for that i need to configure a large timeout time for a specific database? Somebody can advice me how to do that?...more >>

I have two sql servers, one is replicating to the other using log shipping. The backup directory got deleted. Now replication says it is working, but I don't know how because the .trn files are not being generated. What do I have to do to get that started again? Scott Emick ...more >>

I need to know how to get to the terraserver ariel photos. I went to the website and it change. The site it connected me to was some SQL site or somethin that talked about terraserver, but did not give me the actual ariel photograph map. Can someone please help me?!...more >>

I am looking for a 3 drive 36 gig 80 pin hot swappable Raid 5 set of hard drives and was wondering if anyone has any thoughts on drive brands. Seagate Cheetah, Maxtor, Dell? It will be running in a Dell Poweredge 2600 server. The server will be running Win2003 server and SQL 2000 server. I am loo...more >>

I have a problem when backing up the transaction log the server seems to freeze and other processes on the server are stopped due to a timeout or locking my question is what is happening behind when I backup the transaction log , things that can have an affect on our other applications run...more >>

Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old installation. In addition, the data owners of some databases in the old SQL Server installation are not dbo. I ...more >>

Hi All We are setting up a site to sell binoculars to the birding community. I hired a programmer to set up and create a database of products for our pages to draw from. He is telling us that we can not input our own data in the fields without spending several thousand dollars to buy the applicatio...more >>

when i launch the statement USE HRMASTERDAT G DBCC SHRINKFILE (hrMasterData_log I get this message Cannot shrink log file 2 (hrMasterData_Log) because all logical log files are in use What can I do ...more >>

Hi there, We have an internally developed application running at our company which regularly experiences poor performance. The finger is being pointed at the app, but I am not convinced. Unfortunately we are not permitted to watch performance counters, and instead have to rely of the DBA t...more >>

Hi! I have a large table in SQL Server 2000 with a datetime-column 'dt'. I want to select all rows from that table, excluding days which fall on holidays or weekends. What is the best way to accomplish this? I considered creating a new table called "holidays" and then selecting all rows (sort ...more >>

Is anyone aware if MS is considering any thoughts of deploying SQL Server service packs while the databases are still online ? Even with clustering, we take a hit by taking the databases offline. Any ideas if Yukon would help here... ...more >>

Hi, I have problem with rolling back a named transaction: begin tran a insert Table1 values('test') rollback tran a I get this error: Cannot roll back a. No transaction or savepoint of that name was found. How can I rollback Transaction a? Any help would be greatly appreciated. Rega...more >>

When attempt to delete a job, the following error is encountered: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. How would you reslove this? Thanks, Ben...more >>

Can anyone see any problems with me installing SQL Server 2000 on my XP Pro laptop? Why would I want to do that you ask? Because I am doing some development work and won't always be connected to the LAN, so could do with SQL Server running on my laptop if possible. ...more >>

Hi, What does a database marked suspect for recovery means and how could I recover from this? Thanks in advance Teng...more >>

When I try to do a restore, there are restore points already made. I pick one of the dates, and it says it is making changes then will reboot. All looks like it is going well, the computer reboots but then comes up with a message that says System Restore could not be completed or something like that...more >>

Hi, I have lost my win 2k server where I had my Sql 2000 data. Now I need to attach to sql server my database, but I have lost the log file. If I use the enterprise manager I get an error, if I use a stored procedure I get an error. How can I do to attach my .mdf file to Sql Server...more >>

Hello all, Our database server went down due to a power outage but everything came back fine except the MSSQL serverice won't start. I get the following error listed below when trying to start the service. I tried starting the service with the -f switch, which didn't work. I also tried the re...more >>

I used the technique of detaching, copying and attaching a database to setup another one. The data did not get moved only the objects (tables, etc.). After further investigation we found that the original db that was detached also lost it's data. Good thing it was a test db. What could have hap...more >>

I have a problem with locking on sql server 2000 sp3. I select one record from a table using the primary key on the where clause, inside a transaction with serializable level. In another connection, I try to do a simple select * from sametable (also using serializable transaction level) and this ...more >>

Hi I tried to set up default instance of SQL 2000, but the application hung abruptly and failed. I tried to uninstall through Add/Remove Programs and also thorugh Setup instructions, but that also failed because it told that there exists a corrupted file under SQL directory. So, i created...more >>

I am trying to restore a master database after a server rebuild and need to get the build number back to 8.00.818. I have installed (or so I thought) the SP3a and the 8-11-03 patch to get it to that build number but when I check the build number in Enterprise Manager it still shows 8.00.194. Help?...more >>

Help!!! When attempting an insert to a table in SQL I get a message indicating that the ARITHABORT setting is incorrect. Running (select databasepropertyex db, 'isarithabortenabled') returns null. Running (alter database 'db' set arithabort off) doesn't change the setting. I've tried setting...more >>

I'm sure restoring master/msdb on the same server should be no issue. But restoring on separate hardware might have these issues (if you know others please tell me): 1: File path (drive letter, file path) different for the location of the database on the replacement server; 2: Securit...more >>

The database file is getting almost too big to back up. We have to shrink it twice a week and that takes so long we can't do it more often than that. I know that there can be multiple data files for one database, but is it possible to split one giant file into smaller ones? How does it work? Thanks....more >>

I have an SQL Server that has a structure as follows. 1. There is a common database that contains hundreds of stored procedures. 2. There are also 50+ identical databases, with the same number of tables and table structures. 3. The common stored procedures must be able to read/write data to any...more >>

Hi chaps, My company runs a website that allows users to sign up to a seven day trial of a software product. What we would like to happen is, about three or four days after the trial expires a message to be sent to the user encouraging him to signup to the paid service. My question is, what...more >>

H I am very new in SQL2000. My question is , is it possible to change the sort collation in SQL2000 after installation and how. Currently my server is set to case sensitive. how do I change it to case insensitive? Also is it possible to do this on my select command instead? For instance, my...more >>

Hi , we have one server with 1 GB of RAM and 500 MB is pagefile. Sever is not dedicated to SQL Server since there is also Microsoft transaction server running and IIS4. SQL Server connsumes aproximatelly 980 MB and mts alone around 20 MB. Thant means that mts has to go to the pagefile....more >>

Hi I use SQLServer 2000 with SP3 I have script file that has been created using "generate SQL script" command from SQL server Enterprise manager. But I can't find how to create database using this script file. Is there any way to create database from script file? I appreciate your ...more >>

Hi, I have three user databases on my production server and I noticed a strange behavior whenever the server gets rebooted. on two of the databases the recovery model flips back from Full to simple when the server is rebooted any time. On the third database the recover model stays as Full even...more >>

Is cascade delete and cascade update new to 2000 or did it exist in 7? Thank you, Mike ...more >>

sql server 2000 versions 8.00.760 and 8.00.818 i found a strange bug. maybe it's not a bug, but it sure seems like one to me. these tables are from a database for a cots product called facility center. the "bug" occurs down at the very bottom when you run the queries specified. see my ...more >>

We have a table that is constantly having records updated/inserted/deleted. And recently we've had problems with table and page locks that slow the entire office down to a grinding halt. I was wondering if this had something to do with the way data is stored within the table (there are numerou...more >>

Hi, We have an application that works with SQL Server 2000 and has 20 users. All the users reach 4-5 tables most of the time.They do select/update/insert very frequently to those 4-5 tables. The problem is, 2 or 3 times in a day, all the user applications stuck with showing hourglasse...more >>

I've configured SQL2000 with both security sql + windows (sql propierties) and I can't access to the corporative administrator on the clients. It appears a validation error message. I can't use the sql superaccount 'sa' to open the sql server. This didn't happen with Win2000 Server. Must I recon...more >>

I need some help with Date Conversions. I am getting the following error when I run the query below. The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. declare @inputdate char(10) declare @tempdate datetime declare @validdate char(10) ...more >>

I have on the table 'MyTable' one trigger after update In VB I update more records of the table with an unique statement for example "update MyTable set FirstField = 10" cause 10 records updated Why the trigger fire only 1 time and not 10 times thank ...more >>

I have a quick question. This SQL executes fine in Sybase, but returns the following error in MS SQL Server "Cannot perform an aggregate function on an expression containing an aggregate or a subquery." The problem is clear to me. The aggregate function Max() is being performed on the results o...more >>

What is the easiest way to transfer data between the SQL Server and the DB2 on a AS/400 ? Is there a good documentation about it?? Thanks for any help....more >>

I wonder if someone has experienced what we're seeing on one of our prod Servers (running WinNT4 SP6a + SQL7 SP3 on 8-way Compaq, 4GB RAM, 2TB Hitachi Thunder SAN)? A Scheduled DTS Package failed a couple of days back with the message "Error string: No Steps have been defined for the transfor...more >>

Hi, How to create jobs in MS SQL Server 2000 for the following purposes - 1. For re-organise/re-index to 10% per page & 2. For checking DB integrity. Can someone let me know please. TIA, Harish ********************************* Long way to go before I sleep .. *** Sent via...more >>

Hello! My current sql database is MSSQL 7 SP2. The databse will be upgraded to MSSQL 2000 SP2. Actually my paln is to backup sql 7 db, move backup file to new sql 2000 server and restore it there. And then run sp_updatestats agains the restored db. Now my question is: Do I have to apply t...more >>