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, 11 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, 11 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...

No, because the parameter value is the primary key and so only one row can match.  You're deleting one row, changing the parameter value, deleting one row again, and so...

How are you running the query?  The query for which you posted the plan will only delete a single row, since your WHERE clause specifies a single value of the...

Jonathan is right.  To answer your question directly, no it doesn't mean that.  The CATCH block will be invoked because there was an error in the TRY block.  The XACT_ABORT...

I guess that your question is how do you check the space remaining on the drive?  Try using the stored procedure xp_fixeddrives.

John