Schadenfreude-Mei (2/3/2010)

---

Steve, dude!

No job is worth that! Unless your getting...

Schadenfreude-Mei (2/3/2010)

---

Lynn Pettis (2/3/2010)

---

Officially, sys admin for a Data General MV4000 system that a...

Steve Jones - Editor (2/3/2010)

---

Not sure you can read the error log with T-SQL. It's just a text file, so you can scan it with FIND, TAIL or other command...

Officially, sys admin for a Data General MV4000 system that a print/fulfillment company used....

Monitor...

tosscrosby-60625 (2/3/2010)

---

Lynn Pettis (2/3/2010)

---

Been there done that. Several employers ago, commute was 90 miles one-way, several times during the winter my boss asked what I was doing at work...

Yes, it could be done. How to do it in your situation, that is a different story. It would help if you could post the table definition(s) (as...

river1 (2/3/2010)

---

take a look at this:

http://www.sqlservercentral.com/Forums/Topic857013-146-1.aspx

you will see my problem.

I have people (in a client company) that are Domain admins and we don't want them to access the...

If the only logins to your SQL Server instance that you setup are SQL Server logins, then windows accounts won't be able to connect to SQL Server.

Okay denizens, any feedback on this, Database Mirroring, would be welcome.

Don't follow. You would only do this if you lost admin access to MS SQL Server as the OP did. ...

river1 (2/3/2010)

---

Isn't there a way of preventing SQL Server 2005 from let someone connect as sinle user?

I mean , can we tell to SQL Server that no one can connect...

Chris Morris-439714 (1/22/2010)

---

The 07:41 from Reading to Leamington was cancelled today for the second time this week. This is unusual, it's been an excellent service so far. The jouney home...

Paul White (2/1/2010)

---

Isn't the academic year just YEAR(DATEADD(MONTH, -7, {date_time}))?

USE tempdb;

CREATE TABLE #Data

(

date_time DATETIME ...

Matt Miller (#4) (2/1/2010)

---

Agreed to avoiding @@identity- although if you...