You may want to look at BIML, as that may offer the flexibility you're looking for. Check out John Welch's blog (http://www.agilebi.com/jwelch/[/url]) as he developed it. BIDS Helper[/url], a free...

Also, because I include this picture in my presentations... http://twitpic.com/1gdrwv

Please think of the kittens...

Read this blog series by Brent Ozar, he does a good job of explaining fragmentation: http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/ [/url]

http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-2-size-matters/[/url]

Also check out this article by Paul Randal: http://technet.microsoft.com/en-us/magazine/2009.06.sqlqa.aspx

viduvs (6/16/2011)

---

I am going to use SQL Server management Studio to restore the database for point in time recovery.

So should i first restore the full database backup and then transaction...

viduvs (6/16/2011)

---

One more thing.

How do I retore the databases in order to recover the data?

As we have lost LUN, we don't have database running up to take tail log backup.

We...

viduvs (6/16/2011)

---

Thanks for your reply.

I was having the same solution to install a new fresh instance and then configure the things.

Though we don't have a backup (even external backups), we...

Then it looks like you'll need to plan a downtime and patch that server to bring it up to proper patch level.

Do yourself a huge favor and check out (disclosure: I work for Pragmatic Works) DTSxChange. It will convert packages for you automatically. It will save you TONS of time/headache. Can...

Open Internet Explorer using 'Run as Administrator' option and browse to your SSRS site (i.e. http://localhost/reports). Click on Site Settings at top right. Go to Security. Click new...

Here you go, wrote this up for you: Find Heaps Using Policy-Based Management[/url]

Awesome, I'm glad you've found it useful. Thank you for your support!

Steve, thanks again for doing the write up on SQLU! Koen, if you like SSIS make sure you check out the great posts from the previous semesters especially Josef's series...

Up until this point in my career I've been strictly an operational DBA for my organization(s). Now I've transitioned over to a consultant role wherein I'm travelling around interfacing with...

WayneS (9/6/2010)

---

That's not why I don't get on those sites. I'm one of those folks that are absolutely paranoid about protecting my personal identity... and all of those social networking...