I believe you wouldn't want to drop any of those objects because they are of no issue even if they aren't being used. Now, if you want to drop the...

AFAIK there is no set format for a 32 bit and 64 bit database files. 32 bit to 64 bit, is like giving more power to SQL Server to use...

I agree with SK.

You will want to monitor the txn log file growth, and based on that set in the growth parameters by appropriate size numbers. If you txn...

Timestamp

Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table rows. The storage size is...

I am thinking that you are talking about a .mdf file or .bak file. If you have a .mdf file do sp_attach_single_file_db and bring the database online. And then script...

Please check the ErrorLog in the enterprise manager and look for the error. You can also check in ErrLog.log in the log folder.

For configuring the report, you will want...

No, I haven't because I don't have space on other drive because I have data files of the same database.

I have tried these options too, but in vain. No success until now.

Here is the backup device create script

EXEC master.dbo.sp_addumpdevice @devtype = N'disk', @logicalname = N'XYZ', @physicalname = N'D:\FT005.YINT01.USERDB BACKUP\XYZ\XYZ.BAK'

Thanks to everybody for providing in thoughts. The query is working like a charm after using

WHERE c.b2 = @Criterion OR @Criterion = ''.

Yes, I did update statistics on the tables of dev. environment and checked table structure for double assurance. I am not sure why is the cause of difference in query...

Yes they are. The hardware configuration of the servers and server options are exactly the same. No difference.

If you are using SQL Server 7.0, sp_dboption would apply but if SQL Server 2000 advised way of changing database properties is using ALTER DATABASE. Do watch for some important...

Chubb

I have a script which I use to find the used and free space in each datafile and here it goes

/******************************************************/

USE TEMPDB

CREATE TABLE FileDetails (    

        DbName varchar(100), FileId int...

Mike, Thanks a lot for a timely reply. I was totally out of hopes, that would I ever be able to understand and explain it. You just trigerred my thoughts...