If you're not already familiar with it, you may want to look at the undocumented procedure sp_msforeachdb, as well as sp_msforeachtable. Very handy and very flexible.

Redgate (the sponsor of...

ddonck (4/27/2009)

---

I also notice the following error:

2009-04-27 16:31:50.46 spid9s MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting...

Chris Hancock (4/25/2009)

---

I do appreciate everyone's comments, but, I'm not talking about a reporting server - at least not in the classical sense. For what it is worth, we...

Chris,

I think I understand what you're after; you're basically envisioning one "version" of SQL for read/write, one (that may be tuned differently, etc) for reporting. A fairly common scenario,...

What do you see in the SQL logs? If this is a production server, it's probably rolling back transactions.

Jack, I won't speak for the OP, but I recently did something along the same lines, where the database name had to be generated dynamically to save me a ton...

Can you explain a little more clearly what you're trying to do, and the errors that you are receiving?

For a user who connects to the database through a domain account,...

looks like you're pretty close.

CREATE PROCEDURE x

@Section int

AS

BEGIN

if @Section=1

begin

Select Date, Customer, SalesAmount from Sales

end

else

if @Section=2

begin

Select date, vendor, PurchaseAmount, Tax from Purchases

end

END

GO

how about

if exists (

select * from tableb )

begin

select columna, columnb, columnc from tableb

end

else

begin

select columna, columnb from tablea

end

David

ramadesai108 (4/23/2009)

---

Hi All,

I have a need not to show a column in a query result in a certain case. Here is my query:

SELECT ColumnA, ColumnB,

CASE WHEN...

I would make sure that your SQL service account has the necessary rights to the file (as opposed to your domain account).

Can you post the command you're using to attach...

Can you provide some samples of what you've tried, what type of input you're looking to get from the user, and what types of packages you're trying to run?

thanks

Is SQL running correctly now? I wasn't able to tell based on what you've written. By this I mean, can you create a new database and have everything...

Actually, SQL 2005 can use the Jet engine as a linked server. Under "Other Data Source", select "Microsoft Jet OLE DB Provider".

It sounds to me like you're still trying to answer the main question for yourself, especially since in a lot of ways you're asking two different questions: what queries...