DBMail also introduced notifications if i remember correctly

Thanks for the responses guys, i agree with the education route - unfortunately our offshore support teams sometimes "forget" to stick to process :S

CELKO (5/23/2012)

---

This is not a table; What is the key? We do not use reserved words for names, we do not use bit flags (that was assembly language. I know...

Here is a script i use for indexes - you can modify it to your needs.

Press Alt>Q>S to specify the values for template parameters

/*

Author:<Author Name, sysname, Author Name>

Date created:<Data Created,...

THANK YOU EVERYONE!

i was having a crap day but this has totally cheered me up!! 🙂

We have a mix of both physical and virtual in our environments

Check out this video from SQLBits - should give you some insight into the world of virtualization 🙂

http://www.sqlbits.com/Sessions/Event7/Virtualization_and_SAN_Basics_for_DBAs

Had this same issue again but this time it was because the instance name was NOT specified in the config file when it should have been.

Thought it would be useful...

Using SELECT over SET "may" give unexpected results. Consider the following:

CREATE TABLE #tmpstore

(

id INT ,

name VARCHAR(10)

);

---- creating a table to insert temp data

INSERT INTO #tmpstore

SELECT 1, 'Chris'...

vinu512 (5/16/2012)

---

Thanks for the reply Joe.

Yes, that was the problem. I was behind a Proxy which was blocking outbound SMTP.

I finally got it working.

I have another small question. Can I...

hardware should be compatible too - microsoft have a catalogue for compatible hardware.

R.P.Rozema (5/1/2012)

---

I don't have a script to identify the rights one specific user/login has, but I do have this script that scripts out all rights defined per object (if run...

If you're comparing queries i'd be inclined to check i/o too...

SET STATISTICS IO ON

I think it's possible using db projects in TFS - not sure about SVN though - i would imagine there would be some way of doing it - failing that...

I can confirm that if DBCC CheckDB errors during an agent job then the agent will throw an error 🙂

I followed the post above to corrupt a database and my...

Thanks for the reply - nice post too.

However, i've done some searching around and have found a...