It looks like something i'm looking for! I'll give it a try and will let you know about the outcome. Thank you.

I had the pleasure of using it lately after designing my little database access model. I couldn't find a way to creat an "admin" login that can create other logins,...

I'm not sure if you can capture the error message itself but you can find out if there was an error or not.

Add -b to the SQLCMD

%SQLCMD% -S %SERVER% -d...

Just set the right variable values, make sure that path to SQLCMD is ok and should do the job

@ECHO OFF

SET SQLCMD="C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"

SET PATH="C:\path\to\sql\files\"

SET SERVER="Server\Instance"

SET DB="Database"

SET LOGIN="sa"

SET PASSWORD="pass"

SET OUTPUT="C:\OutputLog.txt"

CD...

look at

SELECT name ,

recovery_model_desc ,

log_reuse_wait_desc

FROM sys.databases

this should point you into right direction next time.

However my first thought would be - long running/uncommited transacion that was preventing the log truncation...

Performance wise, like you already assumed, there is no benefit of having multiple transaction log files. Best practice from my experience and from what i read in the past is...

I think I found a solution that would satisfy me and my collegues.

The company has a HUB website, sort of a community site where they post all the internal announcments...

[Url]http://www.sqlservercentral.com/Forums/Topic1639247-1550-1.aspx[/url]

You can find all the details in this topic. I think i still have the corrupted log with mdf saved somewhere. I wrote that i could fix the issue in...

I've used it actuallt 2 months ago when i occured a log file corruption, long story short, this caused the database to go in suspect state, the database was in...

Thanks Gail, especially for the last sentence, it shows the point.

"Call the DBA" training would be the training to do, just need to print some business cards :hehe:

We are a small company and I'm the only DBA, my concern is that when people that are not familiar at all with the sql, after a one day training...

danielfountain (1/9/2015)

---

Sorry i dont think i have explained myself well.

There are 5 separate columns all with dates...

ohh sorry...

THEN can return value for one column not a set of columns like you are trying to do.

I think what you are trying to achieve is something like below:

insert...

dwain.c (1/8/2015)

---

Emil Bialobrzeski (1/8/2015)

---

Try this

SELECT

EMPLOYEE_ID

, LAST_NAME

, SALARY

, JOB_ID

...