dlucas-615847 (9/19/2009)

---

When I try to creat this stored procedure, I get two syntax errors:

Msg 102, Level 15, State 1, Procedure usp_maintain_database_log, Line 107

Incorrect syntax near '?'.

Msg 102, Level 15, State...

lakb200 (9/19/2009)

---

Congrats!!

How many days of reading would you recommend before taking this test ?

Also is this book sufficient for the test or anything else also ?

Are you...

cindy.hutchins (9/18/2009)

---

Our company has had many consultants come in over the last few years and apparently one of them wrote a stored procedure that hasn't been run since 06. How...

Just FYI - procedure has been updated on SSC to account for checkpoint (previous post).

NP - good luck! 🙂

You could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.

This is an artifact of copy and paste 🙂 You can safely comment out the "set @sql = 'checkpoint'" after the backup. It won't do any harm in however I'll...

Can you confirm SQL is listening on TCP 1433? i.e. open a command prompt from your workstation and type: telnet myservername 1433

Is Windows Firewall running? You might need to add...

Thanks 🙂 I'm assuming you are referring to the simulation questions? I didn't encounter any of these questions on 70-432 however I would prepare for them as it is my...

Are you using the same recovery model on both instances (2000 vs. 2008)? i.e. Bulk Logged vs. Full?

I expected to see more questions on some of the newer features in 2008; i.e. policy based management, row/page compression, etc. I'm guessing more of these will be on 70-450...

Thank you - 920. Any suggestions regarding reference material for 70-450?

UPDATE:

Just received confirmation from MS that the development team has agreed to address this issue in the next service release for 2005/2008.

thanks everyone 🙂

rahulgoparapu (7/7/2009)

---

Hi guys Im a beginner to sql server so i have a question, when do we use a full backup and a file back up because we know that...