Gail (1/15/2009)

---

I'll check it out later today, I was going to add another statement to my where clause with the @paramhome parameter will i be able to do something like...

I can't wait to see the day where one just goes through ALL SP's in the database and add ; everywhere

Wait, someone should write a program for it, and make...

I don't know what you mean by

Backup Database WebDB To WebDB_D1, WebDB_D2

But the idea is the right one, it should work

We have the same backup policy here

Note though, one...

What's the error when you run the T-SQL query like OPENROWSET?

Server not found, or login/security issue?

I had the "pleasure" to work for a Web startup company in Canada for a "short" while

It was quite different I'd say......... could be just a small company vs a...

You add a Parameter to the stored procedure say @year

configure the SP to utilize the parameter @year

SELECT DISTINCT Key AS PayPeriod

FROM

WHERE LEFT(Key,4)>=@year

ORDER BY Key

Refresh in SSRS Designer

Voila! you'll...

We use Active-Active on SQL 2005 Standard on Windows 2003 R2 Enterprise here, no issues

However, we did try to setup Active-Active with SQL 2005 on Windows 2008, that had issues...

GOOGLE "SQL Server Auto Restore script", you'll probably hit a lot

Or just search on SSC

Above idea is exactly what you should do

Look into msdb tables - backupset, backupmediafamily

for physical names...

I have SQL 2008 Server & Client installed on my XP SP3 (32-bit)

Also has SQL 2005 SSMS installed

Interesting though, usually it'll tell you what you are missing, prerequisites of SP's

SSRS subscription can be either Email or File Share

I'd try File Share, and schedule it to a UNC directory, perhaps even SharePoint if you can access it in SSRS

\\Server\SharedReportFolder

or hopefully...

You can create SSRS report tapping into SSAS cubes, then add subscription on that in Excel, which I believe it will preserve the drill down structure, I hope

Should mention what...

I am guilty of this WHERE 1=1 trick, to make commenting out MUCH easier

Compare

SELECT *

FROM Table

WHERE 1=1

AND Name = 'Jerry'

AND Gender = 'Male'

vs

SELECT *

FROM Table

WHERE Name = 'Jerry'

AND Gender =...

Not knowing too much

What are date formats like?

Possible to CAST them to datetime, and use MONTH(date_column) function?

I thought if the datetime are consistent and still valid datetime format, you can...

Is there Maintenance History Cleanup task in any of the Maint. Plan?

Interesting, I see the same thing

SSMS 2008 connects to SSRS 2008

I see only Jobs, Security, Shared Schedules

I can access the SSRS website fine as well

Does that mean most tasks are...