You might want to check the scripts you have running around that time...maybe a script is causing the database connection to close.

-SQLBill

One other thing to check...did the admin change the port SQL Server is listening on?

On the server, open Enterprise Manager, right click on the server, select Properties, select General tab,...

Senior DBA is usually the person-in-charge. When you have a company that has Senior and Junior DBAs, that usually just means the SR DBA has more experience and might have...

Looks to me like something corrupted your log file (.ldf).

Can you DETACH the database?

If so, do that and then move the log file to another location or just rename it....

quote:

---

The only thing that i need to change is this key? This is an 'official' procedure? Seems like i'm breaking some license...

Looking at your code, it looks like you DON'T want any SYSUSERNAME from this list:

'valverde\pGist'

'valverde\jGolden'

'valverde\tPeepgrass'

'valverde\lGallo'

'valverde\cBerry'

'valverde\aGuild'

'valverde\rGlenn'

'valverde\mSarkissian'

'valverde\cJenkins'

'valverde\rKepler'

Is that correct, that you don't want ANY of those names?

If so, you need to change...

Way to go Dale! Glad to hear you are back up and hopefully without any problems (besides a boss you would probably like to strangle). Maybe now your boss will...

quote:

---

Dagoboz, where exactly do you live that gas station attendants STILL PUMP YOUR GAS??

---

Dagoboz might...

Or better yet:

SET DATEFORMAT mdy

SELECT CONVERT(varchar(10), '010702', 101)

-SQLBill

Try:

SET DATEFORMAT mdy

SELECT CAST('010702' AS DATETIME)

-SQLBill

quote:

---

Note to self: Investigate the most commonly used vehicle to drive on the left side in Britan before the war of independance...