Travis, This is a public and professional forum. You need to expect people to respond to your posts, even if they are directed specifically to one person. ...

Grant Fritchey (6/7/2012)

---

I trust these guys, but you know what, don't listen to them. If you want answers on licensing, go to Microsoft. That's the single best source of information...

I get it, I should have used the DATE data type instead of DATETIME2 for the question so I could have left off the time portion on the answers. ...

Setup auditing on logins. This will allow you to determine if someone is logging in with the service account.

SQLKnowItAll (6/6/2012)

---

Lynn Pettis (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

hehehe... I would take then off of the join condition as well,...

Try this:

CREATE TABLE PS_TestForOnline

(

specialty VARCHAR (50),

ref_date_Week_Comencing_Date VARCHAR (50)

);

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT INTO PS_TestForOnline

VALUES('AE' ,'2011-06-06');

INSERT...

SQLKnowItAll (6/6/2012)

---

hehehe... I would take then off of the join condition as well, it confuses me...

j_e_o (6/6/2012)

---

This thread has been hijacked. Where are the authorities when you need them? 😀

By the way, when someone uses, :-D, they are making a light hearted jest and...

It depends. You would need to test this for each situation. If you define a CTE and use it once in the immediately following query, then taking the...

I missed this one as well, no parens:

exec insert_table_column 'dbo', 'test1', 'ssn', 1

But it is. Here is the post where you said it:

TravisDBA (6/5/2012)

---

MdApache (6/5/2012)

---

People like Chase are...

Welsh Corgi (6/6/2012)

---

The reason for stopping & starting the service is proably classified.:-)

I have used the Start & StopService method of the Win32_Service Class to do this.

I would not use...

TravisDBA (6/6/2012)

---

Jeff Moden (6/6/2012)

---

TravisDBA (6/6/2012)

---

Unless you are a moderator on this forum (which I don't think you are) please sir, mind your own business, You have no right to...

Still haven't got a real answer. Why does SQL Server need to STOP and START the windows service? What is the purpose?

sqlfriends (6/6/2012)

---

These steps are initally setup by someone else.

For now I wouldn't want to change much about it. I know they can be scheduled to run as a windows scheduler...