That worked for me. Thank you!

Thank you, all sample ddl is below

--will create the table

CREATE TABLE [dbo].[Seating](

[id] [int] NULL,

[cube] [int] NULL,

[capacity] [int] NULL

) ON [PRIMARY]

GO

--will insert 3 rows into the table

INSERT INTO dbo.Seating

...

Thanks Lowell!! I will give this a try in a loop and see where it takes me.

I actually need to generate 2400 files. Each named from a value taken from another column in the same table and ending in .jpg

give this a shot, hope it helps!

http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/11/30/what-s-using-space-in-tempdb.aspx

Why not just shrink it with DBCC SHRINKFILE commands and/or create mulitple files?

The services just do not start once the server was rebooted. No entries in the sql logs and nothing in events as if the services are not even trying to...

He replied with it has to do with read/write conflicts and serializibility which I guess my explanation of isolation levels did not cover as well as it could have.

All he mentioned was that it was an IT Database analysis class. Does that help or should I ask for more info?

Good Call 🙂

Co-Workers homework question that I am embarrassed I did not have the answer to after working as a dba for 15 years but it got me interested...

This insert into event_log should insert into Bankruptcy the bayview_loan_number, bankruptcy_id and the max(actual_end_date)

as the new field I created Motion_for_Relief_Filed_Date. If the bayview_loan_number, bankruptcy_id already exist in bankurptcy then based...

My script to extract data for the Bankruptcy table is chocking on a few fields but the other tables I was able to extract sample data. I hope its posted...

Hi,

Thanks, it does make sense and I tried that approach but I am unable to get the value from this statement (especially the fact that I need the max(actual_end_date))

SELECT...

Hi,

I had started with the first trigger and 1st field but in testing I am updating all rows and need help with the insert.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE TRIGGER [dbo].[tiu_bankruptcy_event_log]...

Its not that the application wont work, I need the users to be able to connect to the server they are used to without having to connect to server\instancename. Also,...