Starting with SQL Server 2005 you can no longer update the system tables. like you were able to do in SQL Server 2000 and earlier.

You may want to double check the codee you ran. I ran it on SQL Server2008 R2...

Here is my solution, no guaranttees on performance:

Create Table dbo.tab2

(

InmateNumber varchar(10),

Loc_unit varchar(10),

AuditDateTime datetime

);

INSERT INTO dbo.tab2 VALUES('694768','G3','2012-04-19 15:56:00.000');

INSERT INTO dbo.tab2 VALUES('853140','HEI','2012-06-22 11:57:00.000');

--

Create Table dbo.tab1

(

InmateNumber varchar(10),

Loc_unit varchar(10),

AuditDateTime datetime

)

INSERT INTO dbo.tab1 VALUES('694768','','2011-08-23 15:00:59.233');

INSERT...

Okay, I just looked at the code from ColdCoffee. Looks like we used the same method to accomplish the task.

Haven't looked at the code ColdCoffee provided. Here is my solution:

Create Table dbo.tab1

(

InmateNumber varchar(10),

Loc_unit varchar(10),

AuditDateTime datetime

)

INSERT INTO dbo.tab1 VALUES('694768','','2011-08-23 15:00:59.233');

INSERT INTO dbo.tab1 VALUES('694768','','2011-08-23 15:01:50.810');

INSERT INTO dbo.tab1 VALUES('694768','','2012-02-09 09:26:22.850');

INSERT INTO...

Hate to say it, but I think audting is the best option for all requirements posted in this thread.

Not sure. Try running a t-log backup or two, then try the shrinkfile again.

L' Eomot Inversé (7/23/2012)

---

Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

There's a nasty ambiguous word for it: hexose; but it's...

Using SSMS, you should be able to use the ShrinkFile on the log with no problems.

shiva.reddy06 (7/24/2012)

---

Hi with respect to my subject, need to calculate

-Calculate Due Amount Principle + Interest after Due Date, this is for 1 installment (if non payment),

--Suppose he ll not pay...

I can't readily answer...

You can have multiple named instances, only one default instance.

Before you do anything more, please run the following and post the results:

select name, log_reuse_wait_desc from sys.databases where name = 'model';

Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.

Using the [ url ]/[ /url ] IFCode shortcuts (no spaces inside the square brackets) makes...