Hi Mike, you are welcome. Some more scripts are coming up shortly. Thanks for the encouragement. ---Best Regards, Suresh.

HI, No need to attach/detach. Shrink the primary log file (the first log file) to the size you want and can. Then use:

Alter Database DBNAME MODIFY FILE (Name = Logical_File_Name,...

A reader, Tracey wanted to know what thesize of the dta file would be after an increment. Just to put it here, it would be the current file size plus...

In The article, the "Raw File Source" may need to be replaced with "Flat File Source". If I copy the content form event viewer to a text file and designate...

Every connection to SQL Server, either through a script or just a login into SQL Server would spawn an SPID. I have observed SPID's spawned due to connection to SQL Server...

Thanks Steve. When I wrote the script, my concern was only to get data regarding the conventionally named databases. The idea of handling databases with special characters in their names did not occur...

To start with, the idea seems to be to prevent duplications. But the trigger's code suggests that only duplications are to be allowed. Something wrong in the code.

I feel the date column need not be indexed. Clustered index on the first column, CLIENT is okay. This way you avoid memory intensive bookmark lookups.

No need to use convert...

The thread (scheduler) spawned by one of your two processors for an execution context of your process (backup in this case) is unable to release control of some resource, mostly the memory...

That sounds perfect. Backup the old one and restore onto the new server.

You woulkd get database users with the backup.

Transfer logins from the old server's master..sysxlogins to the...

Install 7.0 on new machine. Attach user database from old files. You are done.

If you have earlier backups, nothing easier than restoring that.

DTS needs Proxy accocunt. More security.

No system tables. DMV's populated on the fly.

Service Broker.

SQLImail needs no OUTLOOK or Exchange.

Notification Services / inbuilt and upgraded Reporting services.

Certificates (with user defined rights...

A good starting point would be to install SQL Server 2005 Enterprise / developer edition Beta 2. Express is not that high-end.

Once you do that, SQL Serv er Management Studio...