ganesaselvam_thylak (9/1/2009)

---

hi Lynn,

Thanks for your query, can u explain the query?

select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate())...

I'm sure you have as well, I just couldn't remember. Never had...

Care to share what that pluggin is?

-Luke.

Roy Ernest (8/27/2009)

---

Barry, Thanks... I knew I would mess up even when asking a simple question... :hehe:

This is the scenario.. We are moving our Main DB to a new Hardware...

GilaMonster (8/26/2009)

---

Yay. ISP down, again. This time their main basestation is down, affecting every single one of their customers. It's been down since around 3am this morning, eta until repaired,...

Yup gotta toss another suggestion out there for the VM. One thing to watch out for though... Doesn't matter which one you choose (MS, VMWare, Sun, Citrix) if you...

GilaMonster (8/13/2009)

---

Can't help much, but root cause is that some other app's listening on the SQL port. Only one app can listen on a port at a time (AFAIK). First...

Also, have a look at the following link. Going through those posts may have give you some more things to check...

http://www.sqlservercentral.com/Forums/Topic334467-149-2.aspx

Cheers,

-Luke.

Edit: corrected the link.

I've not experienced this, but I do have a troubleshooting step for you, just to make certain you know what's happening. Have you tried to run a trace on...

perhaps if you provide a bit more information on what you're trying to do we might be able to suggest a better way of performing the update rather than row...

seems like something has to be listening on that port.

What do you get when you run netstat -anob? This should list all listening or connected ports by...

Making use of a distribution list, as Elliot suggested, really makes this type of thing quite a bit easier. It also makes it much easier to manage down the...

Jan Van der Eecken (8/11/2009)

---

Hey Luke. "Huwelijk bij de Abdij" sounds almost right, except if you literally meant the wedding is at the abbey itself , which would better translate...

One of the things that I've seen DDL triggers used for is a sanity check on dropped tables... It's one the more popular examples of DDL triggers I've seen...

Cause you use the British English regional...