As I said, I don't know the reason for the timeout, but best practices are to do the best you can to size your database files so that they do...

In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database mail through...

Are the view and the tables in the same schema? You may want to check out this blog post on ownership chaining.

What is not working? Is the report opening, but the parameter value not being recognized?

Have you tried putting the url expression in a textbox and then copied the value...

I don't know the reason for your timeout issue, but I can say that you should reset the size of the file so that it does not need to autogrow...

As Lynn has said it is easier to provide an answer with code if you provide at the very least the ddl for the tables.

I think John has given you...

Do you want to save the schema defintions (Create Table etc...) or the schema and the data?

This is interesting because you cannot write to the mssqlsystemresource (resource) database, you can only read from it, so I wouldn't think that a user being in the db_denydatawriter role...

GilaMonster (5/15/2009)

---

Back to the subject of questions...

There must have been 8-10 questions on database corruption in the last week or two. Is it open season on corruptions all of a...

RBarryYoung (5/15/2009)

---

Plastic.

(actually, I kid. Although New Jersey has the highest population density of any state in the US, South Jersey isn't that bad. North Jersey, on the other...

If you use SSMS after installing SQL Server you can modify the default locations for your Data and log Files by right-clicking on the server and selecting properties. Then...

J-F,

I was wondering how close we came.

Tom,

Yeah that is a good solution as well, I just think for newer developers the LEFT JOIN syntax is easier to understand. I...

Yes you can see that in the Default Trace, IF the trace files have not rolled over. You could run a query like this:

SELECT

TE.[name] AS...

All you have to do is specify it as an OUTPUT Parameter in the stored procedure. Then you need to check the value to decide if you want to...

Sounds fairly simple, if I understand everything. There are a couple of syntaxes you could use to do it, but. in my opinion, the easiest to understand is this...