Viewing 15 posts - 1 through 15 (of 77 total)
Thank you sir. I should start using temp tables. I was able to achive what I wanted.
December 6, 2013 at 1:32 pm
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...
November 13, 2013 at 3:55 pm
That worked perfectly. Thanks much. Sorry to it took me a while to actually put it in practice.
October 16, 2013 at 2:21 pm
I do not know too , I will experiment with it tomorrow and will let you know.
June 25, 2013 at 9:11 pm
kranthi.india123 (10/19/2012)
can u refer below the links and once again,can u explain your question briefly.
please check the name resolution - make sure that you...
October 19, 2012 at 7:17 am
any ideas ?
October 17, 2012 at 9:49 am
Lynn Pettis (8/21/2012)
Minnesota - Viking (8/21/2012)
durai nagarajan (8/21/2012)
August 21, 2012 at 12:39 pm
durai nagarajan (8/21/2012)
with full backup and...
August 21, 2012 at 11:39 am
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...
August 17, 2012 at 9:32 am
Greg Milner (9/6/2010)
August 9, 2012 at 3:47 pm
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....
July 30, 2012 at 1:50 pm
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] =...
April 7, 2012 at 6:26 pm
Thank you. I'm trying gain some insight as to the role of Model DB, Managing Tx log back ups etc.
April 7, 2012 at 10:56 am
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...
November 10, 2011 at 8:26 am
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...
November 10, 2011 at 8:24 am
Viewing 15 posts - 1 through 15 (of 77 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy