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

Again, if you would please post table defs (CREATE TABLE statements), sample data (series of INSERT INTO statements for the tables), and expected results that properly illustrate what it is...

Didn't think of this earlier, but you really shouldn't be using @@IDENTITY either. You should be using SCOPE_IDENTITY().

mcommmgr (2/1/2010)

---

That is correct. And going forward too of course. I am imagining when we hot 8/1/2010, my academic year would now be 1011 instead of 0910. So on and...