Not the Windows form calendar control. You can return the data for a calendar and use a Matrix/table to create the calendar.

Those are not SSRS controls so they wouldn't be enabled when you are working on a report. You'd need to be working on a WinForm or other project/object to...

What controls were disabled?

I don't know that you can create an ODBC connection in a trigger. It "may" be possible. I was assuming you could use a linked server or OPENQUERY(),...

Sorry to say that you are basically screwed since you have no backups. Your only option is to run DBCC CHECKDB or CHECKTABLE with one of the repair options,...

Sure you could do it, but I strongly recommend against it. Anytime you are doing something outside of the SQL Server instance then you are asking for trouble. ...

You can do it either way. If you are doing 2 totally different things on the different actions then 2 triggers would probably be best, but if you are...

Can you provide some sample table structures, data, and code you have tried? See the first link in my signature line for how to do this.

Looping is usually not...

You can also query sys.database_files (must be run in the context of the database you are interested in). You do need to convert the size from 8kb pages to...

In my experience this is one of the drawbacks of the data-driven subscription as there is no way to specify that if the report has no rows don't send the...

Happy New Year to all.

subs99 (12/30/2009)

---

Errr... I'm pretty sure he put that post on his blog after reading my question! His answers are, ummm... unhelpful.

Look, SQL gives us access control right down to the...

Here are some issues you'll need to deal with:

1. sp_msforeachdb returns a result set for each database. You might be able to get around that by creating a temp...

If you read the About us[/url] link on the left it gives some history.

Interesting question. I use sa and, interestingly enough, Tibor Karaszi has a blog post about this exact question today. Check it out.