It sounds to me like something got stuck when it failed the first time. Have you tried simply rebooting the computer you're developing on, to see if that cleans...

I Googled "Reporting Services 2005 Express" and got this, which seems to answer your question:

http://technet.microsoft.com/en-us/library/cc966542.aspx

It's probably a question of rights. The login you're using for the link probably doesn't have access to the other tables.

Removing that account from DB_Owner and SecurityAdmin is a good idea.

Most likely, you need to set up an Executor role that has the rights to execute stored procedures. That's...

If I'm not mistaken, Oracle runs triggers once per row in the transaction. MS-SQL runs the trigger once for the whole transaction. Your trigger is more Oracle style,...

I could be wrong, but I don't think SSIS supports that. It's not designed to work with a consol, it's really supposed to run without any sort of front...

Basically, transactions that overlap each other.

You have to use "dynamic SQL" for that kind of thing.

Create the select as a string variable (varchar or nvarchar), and execute the string.

Here's a quick sample:

declare @Cmd varchar(max);

set @Cmd...

I've been recommending the plans wizard to newbie DBAs for years. As long as you don't go too far wrong on it, it's far better than nothing. If...

We've had a dozen or more threads over the last couple years on the subject of what books a DBA should read. Most of the answers are the same...

In that case, there's almost certainly some place in the plan that lists specific databases to run, as opposed to "All User databases".

Another possibility occurs to me: I think some...

Paul White (1/10/2010)

---

Indeed. i was thinking of an 0900 number...

ifila (1/9/2010)

---

I think 'the drill' is BS! By the time i go thru all the things that email asks for, i can get the response elsewhere, for a LOT less...

Make some minor change to the plan, then undo that change. That might reset it.

Allow their marketing people to post articles about their products. Discussion can follow, just as with any other article. Just make sure they have a tag or are...