Click here to Skip to main content
15,880,972 members
Home / Discussions / Database
   

Database

 
GeneralRe: Identity primary key Pin
David Salter26-Aug-04 23:28
David Salter26-Aug-04 23:28 
GeneralRe: Identity primary key Pin
Diego F.26-Aug-04 23:50
Diego F.26-Aug-04 23:50 
GeneralRe: Identity primary key Pin
David Salter27-Aug-04 1:12
David Salter27-Aug-04 1:12 
GeneralRe: Identity primary key Pin
Colin Angus Mackay27-Aug-04 1:33
Colin Angus Mackay27-Aug-04 1:33 
GeneralSQL and the growing log file Pin
totig25-Aug-04 20:02
totig25-Aug-04 20:02 
GeneralRe: SQL and the growing log file Pin
mikasa26-Aug-04 3:40
mikasa26-Aug-04 3:40 
GeneralRe: SQL and the growing log file Pin
Mekong River26-Aug-04 3:41
Mekong River26-Aug-04 3:41 
GeneralRe: SQL and the growing log file Pin
totig26-Aug-04 3:47
totig26-Aug-04 3:47 
I found that changing the db to simple, and then running the shrink db command, the log file has dropped and wont grow again. Limiting the log in this instance would not have worked, as the db was expecting the log file to be backed up as well. Had the log file been set to backup, the log files size would have decreased.
GeneralRe: SQL and the growing log file Pin
Rocky Moore31-Aug-04 20:18
Rocky Moore31-Aug-04 20:18 
GeneralNested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 14:29
Sanjeev Kumar25-Aug-04 14:29 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
S Sansanwal25-Aug-04 16:33
S Sansanwal25-Aug-04 16:33 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 16:46
Sanjeev Kumar25-Aug-04 16:46 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay25-Aug-04 22:34
Colin Angus Mackay25-Aug-04 22:34 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 7:07
Sanjeev Kumar26-Aug-04 7:07 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay26-Aug-04 8:45
Colin Angus Mackay26-Aug-04 8:45 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 13:59
Sanjeev Kumar26-Aug-04 13:59 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay27-Aug-04 6:07
Colin Angus Mackay27-Aug-04 6:07 
GeneralParse sql query without executing Pin
tocheng00525-Aug-04 11:42
susstocheng00525-Aug-04 11:42 
GeneralRe: Parse sql query without executing Pin
S Sansanwal25-Aug-04 16:31
S Sansanwal25-Aug-04 16:31 
GeneralRe: Parse sql query without executing Pin
tocheng00526-Aug-04 12:07
susstocheng00526-Aug-04 12:07 
GeneralDataSet with GUIDs Pin
mikasa25-Aug-04 11:21
mikasa25-Aug-04 11:21 
GeneralRe: DataSet with GUIDs Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 
GeneralDealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 10:36
david@mindplay.com25-Aug-04 10:36 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 11:13
Colin Angus Mackay25-Aug-04 11:13 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:28
david@mindplay.com25-Aug-04 11:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.