Scott

Right click on the database in Enterprise Manager, choose Properties, and click on the Transaction Log tab.  Enter the new value in the Space allocated box and click on OK. ...

Scott

Obviously your log file isn't large enough to accommodate the data from inserting 1000 rows.  So the solution is to make the log bigger and turn off auto shrink.  No...

David

The clue is in the error message.  The database you are restoring from has different file names and/or paths from the one you are restoring to.  So you will need...

I assume the "+" is a typo?  Your query will return all rows from table1 and table2 where the value of the column b in table1 matches the value of...

Scott

A full database backup won't affect the size of your log.  Truncate your log like this:

BACKUP LOG MyDB WITH TRUNCATE_ONLY -- if you don't need to be able to restore

BACKUP...

This won't work if some of your data is (n)varchar or text.  If you want to count the size of these rows individually, you'll need to use the datalength function. ...

Denise

I haven't worked with clustering and SQL Server 2005, but if it were SQL Server 2000 then I would back up the databases, uninstall SQL Server and then build my...

Felipe

Data Definition Language.  In other words, the CREATE TABLE statements.

Thanks

John

Denise

I haven't watched this video myself yet, but it may have the answers to some of your questions.

http://www.jumpstarttv.com/Media.aspx?vid=33

John

Felipe

Can we see the DDL for the tables, please?

John

No variables, no quotation marks, no red text.  Simple:

CREATE PROCEDURE [dbo].[CreateFile] AS

Delete from InpatientMedStat

insert into InpatientMedStat (PatientAccountNumber, MedicalRecordNumber, AdmissionDate,AdmissionSourceCode, AdmissionTypeCode,DischargeDate, DischargeStatusCode, PatientSex, PatientDOB,PatientZipCode, PatientTypeCode,AttendingPhysicianID,PrincipalDiagnosisCode, PatientEthnicity,FinancialClassCode,PatientName)...

Richard

I think I read somewhere that reindexing a table will cause the transaction log to grow by up to 1.25 (or was it 1.5?) times the size of the table. ...

Frances

First off, why are you using dynamic SQL?  You can do away with the string variables and the EXEC statements and achieve exactly the same effect.  Because your code won't...

You can press Ctrl + Enter to get a normally spaced carriage return.

Brandie's script returns all constraints, not just foreign keys.  And if the constraint spans more than one column,...

Are you looking for the second most recent date?  Something like this:

SELECT MIN(t.tef_bas_tar) FROM

(SELECT TOP 2 tef_bas_tar FROM tef_teftis

WHERE kurum_id = @kurum AND birimler_id = @birim AND alt_birim1_id = @alt1...