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...

Debra

The best solution to your problem would be to redesign your database so that it's properly normalised.  If you can't do that, the only option you have is to use...

I'm not sure what you mean.  What are you trying to create a text log file of?

John

We search for the strings "MSG ", "ERROR:" and "ERROR." during our check.  This procedure is generic for SQL Server (7.0 and 2000) and Sybase, so you may not need...

David

This function should be what you're looking for.  It returns 1 if the number is valid, and 0 otherwise.  It only does the mathematical algorithm part, so you'll need to...