this is the offical link for the exam

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us#tab2

take a look at the link in my signature for the string splitter

thanks but that doesnt get free space if the file has unrestricted growth. how do you determine how full the file is to stop SQL auto growing the file...

there is no issue with this I find, dev guys here usually leave SSMS open so as long as they dont execute a statement in a transaction and walk off...

yep thanks got it. cheers again

seems to be a problem with the chars putting in &#x0D

USE [master]; SELECT DatabaseName = DB_NAME(), CollectionD

Sure I can figure it out, time to brush up on my...

Answered my own question I missed this one

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

satishm94 (2/24/2012)

---

hi

what if we forget to restore that backup to secondary fro 2 hrs and after that

if i restore thatbckup file means

will other logshipping job backup files will move automatically...

if the job shows as executing in job activty monitor then yes its still running.

to get the box back again with the green play icons etc, I dont think you...

looks like you have a logon trigger enabled, i would suggest looking at that and trying to add the agent account access to login.

db_executor must be a role which was created by yourselves as its not a standard db role.

depending on what the db_executor role rights are depends on what they can do.

if...

Raghavendra Mudugal (2/24/2012)

---

Sorry for this off-topic question.

I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.

Just wanted to know, now I see...

Thanks Cadavre. Touch wood, not had a problem with sp_MSForEachDB so far, but thats not to say that I wont in the furture.

I'll review your script and build...

as its sql 2005 i take it you have configured IIS correctly first and followed to link provided.

are you trying to install SQL 32bit or 64bit and is your server...

Raghavendra Mudugal (2/24/2012)

---

SQL Version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with...