I have a strange situation. A SPID is blocking 3 other SPIDs. The blocking SPID's lastwaittype is PAGELATCH_UP and the waittype is 0x0413 (Update buffer page latch). The waitresource is 2:1:444 indicating something in tempdb. The blocked SPIDs all have the exact same lastwaittype, waittype and...more >>

Why is it when I do a 'return all rows' from a table that contains a data type column of Real I get 0.031, but when I Select All from Query analyzer I get 3.0999999E-2? I'm trying to perform a caluculation like: Cost = (tblAreaCodeRateMatrix.Rate /60) * Duration Where Rate is Cost/Minute ...more >>

I have a database which has the data of size of 50GB. This doesn't change daily as we delete millions of records and add new records so the mdf size almost remains constant. Now the log file (ldf) size changes, mostly during the weekend this change occurs. Last before saturday ldf size was 0.01G...more >>

How do I do that? alter table sdfgsdf rename a to b? S ...more >>

Hi there, Recently I ran into the following problem. I have a database with transaction log files that are set to "automatically grow with 10%". I was doing a data transfer which took a lot of transaction log. At first the file grew automatically, but then the data transfer failed with the er...more >>

Hi everyone, I was hoping someone could help me. I am having problems with my transaction log not shrinking after a log backup has taken place. The log backups are usually of size 400 Mb at 7:00am and generate further 6 MB (approx.) log backups each half hour. The log file is usually of size 3...more >>

Hi All, I have a table that has records for commission splits on products -- one record for each person involved in the product and his split Product Person Split 123 100 50 123 101 50 124 102 72 124 101 ...more >>

I can't seem to find that command in the SQL 2000 reference. By chance, would any gurus know it? I have a query that is producing very bad reports (off by 30K) with a query that _should be_ functionally equivalent; but is not it seems. The only inherent difference is the Access SQL call uses Las...more >>

Our APS.Net eCommerce application runs on a web server that reaches SQL Server in our network. We are looking for options to have two different web servers and Database servers so that if we have a problem in one web server or a database server, the other will still continue to serve our cli...more >>

Hello, Is it possible to write a script using CONDTS object to read all emails from the SMTP IIS "Drop" folder without changing the username and email address in LogonSMTP? or is there completely another way to do it. Here is what I want exactly the program to do: I just want to have one sc...more >>

I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory Manager/Total Server Memory). I would like to allocate nearly all of the availab...more >>

I posted this on the asp.net 2.0 forum but received no reply. My asp.net 2.0 application works perfectly well offline. When I put it online, I get a message that Cannot open database "mydatabase" requested by the login I realize it's a permission problem, but I am a bit confused as to what...more >>

Is it possible to have the MSDE 2000 (v8.0) database access (that means = successfully connect to) database files from MSDE 1.0 (v7.0)? (i.e. = backups are in v7.0 format and the new database serve is v8.0) If so, how? TIA......more >>

Ok i'm trying to make a list of names in one var something like this DECLARE @NAME_LIST VARCHAR(5000) DECLARE @NAME VARCHAR(30) DECLARE NAMES CURSOR FOR SELECT FIRSTNAME FROM MAIN_NAMES OPEN NAMES FETCH NEXT FROM NAMES INTO @NAME WHILE @@FETCH_STATUS = 0 BEGIN SET @NAME_LIST = RTR...more >>

We have an application where we are trying to copy old appointments to a history table on a nightly basis at 2:00 am. In SQL 2000 Enterprise Mgr, Managment, Jobs we've created a job with just one step. The step is of type TSQL and the command is as follows: INSERT INTO TempAppt SELECT * FR...more >>

Hi, I have a website programmed in ASP.Net (VB.Net) where I use an SQL UPDATE statement saying something like this: UPDATE table1 SET blabla = 'hola' WHERE id = 11 The error returned is: Input string was not in a correct format. Seems like a normal easy error to solve, but it just won'...more >>

We are running SQL Server 2000. I can take all databases offline in SQL Server Enterprise Manager except once. The option is not even there on the menu for that database. Does anyone know why this would happen? ...more >>

Which would be more optimized of the two queries given below when using T-Sql IF (SELECT TOP 1 1 FROM table_name WHERE column_name = 'xxx') BEGIN -- code here END OR IF EXISTS (SELECT 1 FROM table_name WHERE column_name = 'xxx') BEGIN -- code here END Of course IF EXISTS (SE...more >>