I am required to migrate my database on SQL 2005 from a remote server to the local server. I am going the backup restore way as I did in the...

you can search books online for DBCC shrinkile or truncate log. For the time being use this which is very effective

USE DatabaseName

GO

BACKUP LOG DatabaseName WITH TRUNCATE_ONLY

DBCC SHRINKFILE(TransactionLogNameFileName)

The solution is simple. Uncheck Auto growth on the mdf. If not, specify the limit to say 20 Gb on MDF

The logic behind this is SQL server by default increases...

Even if some one was to resize a field does it not require to be logged into a Change Request. If this is a test or dev environment I wouldn't...

Adding a datetime column and doing the convert and checking for failures sounds really good. But when I have to do it for 8 columns I cant really say what...

I see that the isDate() when ran checks for each and every record on that column and comes back with either a 1 or a 0.

In my case most of...

The need is felt with an upcoming application that needs the date fields to be datetime.

Now when I check the table proprties there are many a date fields that are...

Thanks a bunch Williams...it really works..

Basically I am using a FTP task which puts this file after it is created on the customers site. Now the issue is that they have a utility that runs...

USE Hr_database

GO

BACKUP LOG Hr_database WITH TRUNCATE_ONLY

DBCC SHRINKFILE(Hr_database_log)

This should reduce the file to the max possible...thanks

Only if you can make sure both get the required share of the resources. If you think one of them is critical and might consume a lot resources then place...

How big is your database..the way you say it was accidentally deleted I dont think it was either big or it was mission critical. Anyways if you use Litespeed then...

If you dont have a recent backup, try using the 4.6 version to restore to be on the safe side or else do a backup with the 4.8 version and...

The 800a0cc1 error returned by the ADO Recordset Object is usually accompanied by the following text:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or...

Use 'SET XACT_ABORT ON' in the PROCEDURE CODE. Hope this helps!!!