wildh (9/13/2011)

---

I have a question, well two actually. Has anyone worked within Business Intelligence under the leadership of IT? And would you have considered it to be a success or...

Resender (9/13/2011)

---

Sorry for this late response I've been buried in an urgent project.

No I haven't scheduled the reports yet, its in the report designer in Visual Studio where it stopped...

SQL_DBA_New (9/13/2011)

---

Hi,

Thanks for the reply.

But I had to shrink the files as the original size of DB was 181Gb and after the maintainance job its became 233 GB.

After shrinking...

Well yes you can.

If ()

begin

sp_send_dbmail

end

Schedule that to run every x minutes and you're on your way.

Sorry to interrupt, but this was not...

halifaxdal (9/13/2011)

---

GilaMonster (9/13/2011)

---

Run SP_configure and set allow updates to 1. Update sysdatabases for that database and set the status to 32767.

Then see if you can access the DB and run...

It's always safer to retest the whole app whenever possible.

Rolling back those upgrades is a major pita.

Yes, that's one big PITA with SSRS. The WHOLE expression gets evaluated. So it still divides by 0 even if you use an iff.

You need something like this...

Any way to do a page restore from and older backup + all log backups?

saravanan_skcet (9/13/2011)

---

Hi ,

Initially to reduce the log size ,take the log backup and shrink log file .

As the db is in full recovery model ,make sure you have log backups...

halifaxdal (9/12/2011)

---

this is not gonna work becoz the db is not even in sysdatabases

here is the error:

Server: Msg 911, Level...

Run this and LET IT FINISH

DBCC CHECKDB(DbName) WITH NO_INFOMSGS, ALL_ERRORMSGS

Did you try to restore that backup on a test server to see if it works and what data it contains?

Any...

I can't code this for you now.

The way you use the calendar table is to use each column as a group to jump timezones with.

Something like

Assumes billing cycle...

Sridhar-137443 (9/12/2011)

---

The insert statement is the only one inside the stored procedure. I thought that when Visual Basic calls the stored procedure, it will wait for 30 seconds (time out...

Bob Fazio (9/12/2011)

---

There is also a patch we are strongly looking at. http://support.microsoft.com/default.aspx?scid=kb;EN-US;976700

The reason why we are leaning towards the patch, is because I think everyone agrees, one bad...