Thank you sir. I should start using temp tables. I was able to achive what I wanted.

Yes, I do have a test server and I can restore the master there. but Do i have to restore all the user DBs as well 😮 ? that is...

@stuart

That worked perfectly. Thanks much. Sorry to it took me a while to actually put it in practice.

I do not know too , I will experiment with it tomorrow and will let you know.

kranthi.india123 (10/19/2012)

---

hey Hi,

can u refer below the links and once again,can u explain your question briefly.

http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/this-program-cannot-open-the-required-dialog-box/d3bf5394-182c-4464-9d38-5e13680f1138

please check the name resolution - make sure that you...

any ideas ?

Lynn Pettis (8/21/2012)

---

Minnesota - Viking (8/21/2012)

---

durai nagarajan (8/21/2012)

---

In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss...

durai nagarajan (8/21/2012)

---

In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss incase of disaster.

with full backup and...

Yeah. Its too surprising to believe that there is such huge activity going on in the DB. Is there a way we can determine what caused the trnlog to be...

Greg Milner (9/6/2010)

---

I have been a DBA for 10 years now and I never use the DTA. In my opinion, if a person cannot determine whether an index is needed,...

This worked like a charm, just make sure that you define the text column as large as needed.

Thanks for the post and thanks to the original post's author too....

I was able to figure out TSQL for what I want. ThankQ Gila monster & perry Whittle.

here it is

SELECT

database_name [Database Name],

Compatibility_level [Compaitability],

DATABASEPROPERTYEX(database_name,'Status') [Status],

Recovery_model [Recovery Model],

[Backup Type] =...

Thank you. I'm trying gain some insight as to the role of Model DB, Managing Tx log back ups etc.

Gazareth (11/10/2011)

---

When I compare the old and new objects in both sys.objects and sys.columns, its so convincing that what all the sysobject table[view] needs is a reference to the missing...

Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

my Generate script task stops coz it cant script one of the views...