Thanks Guys! I don't know the physical location of the file. But I do have the URL. It looks like an item in the document library. So how do i...

Good Question Dr.Dee! I guess writing our queries like SalariedFlag = 'TRUE' makes it more readable. But I wonder if there would be any performance degrade when we use 'TRUE'...

Try altering like this.

ALTER DATABASE db_name

MODIFY FILE

(NAME = filename_Log)

Since the MAX Size is not specified , it will be set to default i.e. unlimited.

In SQL Server 2005, a log file specified with unlimited growth has a maximum size of 2 TB, and a data file has a maximum size of 16 TB. Altering...

Thanks Mike. I'll see if it works for us. BTW, we created a SSIS Package to execute this SP. And ran this package as a job. That worked.

Try this.

CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS

IF EXISTS (SELECT 1 FROM inserted i inner join deleted d

on i.ESSN = d.ESSN WHERE i.hours < d.hours -- Hours Reduced

OR...

Check to see if ics\rluu (i.e. who runs the package) has the necessary permissions on the table.

The following should give you a detailed description of what's new in 2005.

http://msdn2.microsoft.com/en-us/library/aa337468.aspx

Truncating the log file and then shrinking it should work. Also, any file cannot be shrinked smaller than its initially specified size (during creation). If the initially specified file...

We created a profile named "ReportingTeam". And this is set as a public profile. We are using the same in our SP.