Before you do a clustered installation of SQL Server, there has to be a Windows cluster for it to be installed on.  I'd be surprised if you can create a...

Paul

It won't work unless you happen to have no indexes on the columns that you'll be altering.  Constraints and indexes on such columns all have to be dropped before you...

I don't have the answer to this, but I think it's a "gaps and islands" problem.  Try searching for one of the articles that's been written on that.

John

I can't answer that without seeing the stored procedure definition... and even then I couldn't be sure.  The only way you can know is by testing.

John

It runs the DecisionDataExtract stored procedure with the specified arguments.

John

Indeed.  Make sure he doesn't have access to TEST, if you don't want him connecting directly.  Then, create a login on TEST with the permissions he needs.  He doesn't need...

The users don't need direct access to the remote server in order to connect to it through a linked server... depending on how the linked server is configured.  Create a...

Perhaps the permissions have been granted explicitly rather than through membership of a built-in role.  For example, if a user can change a stored procedure, maybe he has ALTER permission...

I really would recommend that you back up to a different folder, rather than giving access to the Administrator area.  Something on a different server would be best - provided...

What's the error message?  I'm thinking it may have nothing to do with the spaces in the path, but more to do with trying to back up to C:\Users\Administrator, which...

SET @fileName = '"' + @path + @name + '_' + @fileDate + '.BAK"'

John

Edit: PS - why not use Ola Hallengren's database backup and maintenance suite?  There's...

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

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