The benefit you get from using SSDT for database development is the database project itself not the environment. You get direct integration with TFS for source/version control, code...

Hmm, never seen that error before. A restore from backup would include resetting the identity value to what it was when the backup was taken, so that shouldn't cause...

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, "-", "-$")