nelsonj (11/18/2008)

---

Gaby: The repeating characters, either caps or lower case aren't a big deal. The first time I tested the proc, it just seemed to have an inordinate...

Very nice, I too will add it to...

Bob Hovious (2/5/2009)

---

Thank you for sharing, Gaby. I hate to come across as being dense. I guess I've just been fortunate enough to have the freedom...

Bob Hovious (2/4/2009)

---

Hey Gaby, I'm still curious. Why would you want a uniqueidentifier for a row to ever be null, even if it isn't the primary key? ...

It would be useful if I have a uniqueidentifier column that is not a primary...

m.schmidbauer (2/4/2009)

---

Dear Gaby,

i know this really comfortable feature and i use it a lot.

Good to know that it also works with SQL 2008 since we are actually using SQL2005.

But as...

Sequential is necessary for me to preserve any...

John Reid (1/28/2009)

---

If your objective is only to send an email alert when SQL starts, and assuming you also have SQL Server Agent set to start automatically, you could set...

Hmmm, I was wondering that. Now I'm hunting for a way to trap the last step...

John Reid (1/27/2009)

---

Assuming SQL 2000, you must already have SQL Mail set up anyway ... you also have to initiate the SQL Mail session first using xp_startmail, and terminate the...

Ewan Hampson (1/16/2009)

---

Alan Vogan (1/16/2009)

---

Maybe we should be looking at this from the point of establishing and legitimizing IT as an actual profession in our society, like teachers, doctors and...

fhanlon (1/16/2009)

---

Surely management does not want to create resentments like this and can be prevailed upon to correct this in some way. Mangement that fails to do this can...

It may not be feasible (or desireable) for companies to disclose salaries publicly, but how about disclosing the average salaries for departments?

I remember reading of a scenario in the...

Heh heh... That works too.

😀

Gaby

Try select serverproperty('ServerName')

Sometimes select @@version doesn't give the true server\instance name.

Cheers.

Gaby A.