BIDS Opened project Adventure works DW.

Went to deploy/process and recieved 1 Error related to feature availibility and config. The Perspectives feature is not included in the SE sku.

Then..

Adventure works DW...

Now I maybe off track here but I went to

Start >> Programs >> SS2005 >> AS >> Deployment Wizard

Deployment Wizard is asking me to specify the path to the...

I went to control panel >> add/remove >> SQL components and verified that AS is already on the disk. Now whether I need to doing anything further is my question.

GilaMonster (11/24/2010)

---

Well I don't know where you stand and I don't know what your job description is so.... everything. 😉

If you don't have a firm grip of backups and restores,...

GilaMonster (11/24/2010)

---

It depends. What's normal for your system?

That's the answer for most of...

Thanks!

Sorry guys, I found out we are running websense and was having trouble posting. Anyway you lost me at Linked Servers however from what i have read about it, it...

Sorry guys, I found out we are running websense and was having trouble posting. Anyway you lost me at Linked Servers however from what i have read about it, it...

Is there some kind of SQL injection protection going on? Whenever I try to post code the server just hangs. However if I just post text like this there is...

Ok using

I get...

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition...

reading the comments now on the blitz query. Thanks!

While trying to run this...

SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),MAX(backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(19), MAX(backup_finish_date), 100), 'NEVER') as LastBackupDate,

case

when type='D'...

We are running a few 2000 but mostly 2005. No 2008 just yet.

homebrew01 (11/22/2010)

---

Here's a query that you can run to check on when each database was last backed up and the recovery model.

I used this when I started at a new...

Eww. Nice! I just ran Brents Blitz query on my local instance and it came back with a lot of good info but at the bottom of the message was...