Please will you post the whole script?  I suspect that you just need to put double quotes at the beginning and end of the path variable when you use it,...

It's difficult to help you without any table DDL and sample data.  However, if you don't want the debit and credit amounts to appear separately in your result set, don't...

I suspect that it's something to do with having the same name for your subquery (details) as for the underlying table (Details).  Try a case-sensitive search and replace and change...

Best to avoid making the database single-user in the first place.  But if you can't avoid it, you might try this:

ALTER DATABASE MyDatabase SET MULTI_USER WITH ROLLBACK...

I suppose it depends what the DBA's job description is.  But usually I'd say that designing a data warehouse would be the responsibility of a developer or data architect.  A...

OK, please post the login failure message(s) from the errorlog, and the result of this query:

SELECT type
FROM sys.server_principals
WHERE name = 'SVCINFODEVEL'

John

(1) Grant the service account the necessary database access on the server

(2) Configure the application on each PC to run under the service account

John

I typed "sql bridge table" into my favourite search engine and got a few promising results.  Another term for it is "junction table" - you may get some more results...

Yes, you can do that.

John

Have you tried using DATEPART(week)?

John

One way to do it would be to dump the results of sp_whoisactive into a temp table and filter out statements not related to index maintenance.

John

Have a read through this.  It covers the issue you're having.

John

Edit: oops - didn't see Jonathan's reply

• This reply was modified 6 years, 2 months ago by John Mitchell-245523.

Yes - by all means do a one-off shrink after you've truncated all those tables, but don't set auto-shrink on, otherwise you'll be wasting resources shrinking and growing, shrinking and...

Maybe you just need to lose "FROM (" from the first line?

John

Edit - or do you just need a closing bracket at the very end?

• This reply was modified 6 years, 3 months ago by John Mitchell-245523.

If you change EXEC (@SQL) to PRINT @sql, do you still get the error?  If not, the error is in the dynamic SQL.  If you eyeball the @sql output, you...