t-pinto (9/16/2008)

---

Hello,

I have an alias for 2 calculations. I would like to filter only those results that are >1000.

Here is my statement.

Select InvoiceTotal,

InvoiceTotal*(.10) as "10%",

InvoiceTotal+(InvoiceTotal*(.10)) as "Plus 10%"

From Invoices

Where...

Another option (possibly) would be to use synonyms in each database. Part of your script would be a check for the synonym, and if it does not exist -...

First, I don't see any difference between the two queries. I am assuming you meant to modify the second query to something else.

As for your problem - can your...

Where exactly in SSMS are you building this query? I have never seen a popup window when I have syntax errors - rather, the results pane will show the...

Glad I could help

Is SQL Server Agent running under a domain account or local account (e.g. Local System).

What is the error you are getting?

bdavis (9/8/2008)

---

I have a stored procedure and with in the stored procedure I have multiple select statements. When I execute the sp, I get multiple results. I would...

Try modifying the call to sp_send_dmail and prefix the call with the database and schema. The call should be:

Execute msdb.dbo.sp_send_dbmail ...

The other thing to try is to make sure...

Yeah - I know what you mean, since I am only proficient enough to have...

You can use either of the following:

-- ANSI standard

UPDATE test

SET col1 = (SELECT col1

...

For this type of process, I use a powershell script that runs on my central management server. The powershell script opens a connection to the database on that server,...

You can run the install from the network location where you copied the DVD contents. If that is not an option (bandwidth issues?), then I would recommend copying the...

When I tested SQL Prompt, I liked it - but, I did not like the price or the fact that it only works for SQL Server. I also have...

ALTER DATABASE tempdb SET RECOVERY SIMPLE;