How to Change the File Extension for a Data File

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension

ShrinkFile

SQL Data File Information

This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName

Configuring Service Account Privileges for SQL Server

How to grant Windows privileges to the SQL Server's service account.

Starting to hate ASP.NET....pls help

Right, I have connection all working and have returned a record count from a table called User, I'm using a SQL server 2000 database. However I'm trying to bring back data using a sqlDataReader. However I'm getting data conversion error "Sytnax error converting the varchar value to 'true' to a column of data type int"I […]

RE: A complex problem

Hi, try this one, I hope it will help: select bh.Tank_no, bh.Start_time, bh.End_time, ts.Output_Reading - te.Output_Reading as Trend_Tonne, eds.Output_Reading - ede.Output_Reading as External_Data_Tonne from Batch_History as bh inner join Trend as ts -- Trend start on (ts.Tank_no = bh.Tank_no) and (ts.Time_Stamp = bh.Start_time) inner join Trend as te -- Trend end on (te.Tank_no = bh.Tank_no) […]

RE: Migrating SQL Server Jobs

I didn't refresh my screen so I didnt see your post noeld. 

RE: How should boot.ini look w/ 4GB

So if we do use the /PAE and only have 4GB, is that ignored or should we remove it? Darren