No rush but I am looking forward for you to release an article or post on the presentation you did yesterday. Very very good, Jeff!

No we set the AGs to failover manually. I know, it kind of destroys the purpose. Good point on the instance naming for auto failover AGs though! Thanks

Thanks, Perry! I understand what the listener functionality is. My only question is that I am able to login through listener with a different port number that it has no...

thats what i am wondering how to send.. A private message????

i know its pretty known to evryone but just wondering...unless if u want me post here

I am okay with doing...

Lowell,

I am not usuing raw dbnames but using a cursor to loop through all the dbs and back them up to the folder location. There is no...

thanku i just came to know that.. Thanks for the quick response

I dont think so.. I have a check box with...

Default Trace???

Keith Tate (12/11/2013)

---

Do you want to prevent them from dropping objects? If so, you could write a DML trigger to prevent that:http://technet.microsoft.com/en-us/library/ms191524(v=sql.105).aspx. Or you could use the trigger to write...

Erin Ramsay (4/18/2013)

---

prathibha_aviator (4/18/2013)

---

I know right but apply the same on below

IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

...

I know right but apply the same on below

IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

...

This is an example i gave u... with created tables and column values...and datatypes exactly replicating my original table at work...but I am missing some string conversions in my program.....

okay what if we do this

IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

...

sry i gave wrong values in the condition.. pls excuse

here is the condition now

IF (SELECT COALESCE((SELECT dI.[entry] FROM dbo.InitialData AS dI WITH(NOLOCK) WHERE dI.Dept = 'Support'

...