"WHERE Date LIKE @Date" doesn't make any sense.  LIKE is a string comparison operator, and if you attempt to use it on dates, you can get unexpected results, as you've...

This is all somewhat vague.  What is the date and how are you specifying it?

John

Or this, given that I think you want either/or rather than both.  But Phil's right - table DDL in the form of CREATE TABLE statements, sample data in the form...

(1) Not necessarily.  DBCC CHECKDB creates an internal snapshot of the database.  Database snapshots are sparse files, so they start off at (near) zero size and only grow when data...

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, 2 months ago by John Mitchell-245523.