We have no bloggng policy per se at my employer. We we have a strict policy of no personal internet use at the office. It is not allowed,...

SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 0).

From the article in today's post:

http://www.sqlservercentral.com/articles/Date+Manipulation/69694/

dave-dj (7/9/2009)

---

> OpenQuery is enabled

(I can run open query commands to other systems)

> I have defined a AD linked server as follows:

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject',...

I have a Dell D820 Latitude with the stick thing. I hate the stick, it gives me a cramp in my finger. I hate the touch pad too,...

ClipMate 7.3 clipboard extender is my toaster. It saves my clips automatically so I can go back to the bit I copied 3 clips ago. I will also...

We also have a table which we use to get sids from. The stored proc that gets the next sid does an application lock so that only one process...

As a woman in IT and a former professor of math and computer science, I feel that the barrier to woman and anyone in Technology is lack of math skills....

Wayne West (11/2/2009)

---

Ross McMicken (11/1/2009)

---

I used to give blood regularly, but after living in Equatorial Africa for 3 years in the early 90's, I am ineligible. I have never had...

I have been giving blood for 35 years ( a grad school classmate had a blood disorder and needed donations). Many people first give to help a friend and then...

Roger Abram (10/9/2009)

---

Thanks... but there would be concurrent activity going on and it would be difficult to coordinate disabling the trigger whenever a certain process needs to be run (involved...

Jeffrey Williams-493691 (9/28/2009)

---

Michael Valentine Jones (9/24/2009)

---

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

Matt Whitfield (9/24/2009)

---

Is there a particular reason you want to use ALTER as opposed to DROP then CREATE?

Do you have permissions you'd like to maintain?

As I said, changing CREATE statements...

WILLIAM MITCHELL (9/24/2009)

---

Terri-92562 (4/2/2009)

---

I am using DMO and vb6 to script my database. It gives me create scripts. I would like to generate ALTER scripts for the stored...

I attended SQLSaturday in Baton Rouge on Saturday, Aug 1 and it was definitely worth the drive from New Orleans and my time. It was 6 hours of Sql...

I will be driving from New Orleans to Baton Rouge tomorrow morning (1.5 hour drive) to attend SQL Server Saturday. I'm happy to have the opportunity for the free...