You can define the foreign key to automatically delete child rows when a parent is deleted. So the FK definition has to look like this:

FOREIGN KEY REFERENCES users(user_id) ON DELETE...

John Cooper (5/22/2014)

---

Thanks Jeff,

That's what I have been doing is opening it in SSMS, clicking on properties and then OK.

I was wondering if someone had found a better way. I...

george sibbald (5/22/2014)

---

a large log file in itself will not lead to a larger backup as only enough of the log is backed up to allow for recovery during a...

You'd have to hard-code it.

I think you want:

=Sum(IIF(Fields!TimeGroup.Value = "LW",Fields!SalesSelling.Value,0))

You could use a linked server, but I prefer to stay away from them. I'd probably use SSIS to read new customers and then get the archived data for...

If the database is in Simple Recovery model and the log is growing out of control that means there is a long-running transaction that doesn't allow the a checkpoint to...

An already running job cannot be started again until the first run completes.

TomThomson (5/20/2014)...

But I probably ought not to say such things - after all, most of the audience here are US citizens who regard anything done and accepted by the government...

I've never seen that issue. I can view reports in Chrome, although they don't render that well.

When you say blank screen, do you mean you don't even see the...

You'd have to query the DMV's to find requests that are doing update statistics.

Creating a LOGIN requires server-level permissions, so it doesn't really matter what permissions you grant within the database, even a user with dbo/db_owner permission won't be able to create a...

Since the data is coming in as a string then you could do something like this:

="$" & Replace(Fields!amount.value, "-", "-$")

Excel is just formatting the data as a percent for display it actually has the data stored as 0.84, etc...

If you want the data to be stored in the database...

I don't normally include SET OPTIONS in my scripts. I allow the script to inherit the database/connection SET OPTIONS.