Thanks for this instructive and very well presented article!

It really drives home the importance of being very careful when using the TOP statement in T-SQL. I had no idea so...

Thanks for this instructive question. I got it wrong but learned something about the GO statement and white space.

-- webrunner

Thanks, all, sorry about that. This is the comment in the failing job.

EXECUTE [dbo].[DatabaseBackup]
@Databases = 'USER_DATABASES',
@Directory = N'S:\SQLBackups',
@BackupType = 'FULL',
@Verify = 'Y',
@CleanupTime = 72
@CheckSum = 'Y',
@LogToTable =...

Hi Jeff,

Yes, it is a clustered index.

Thanks,

webrunner

PS I think this was an issue where the user name was a SQL login but also had a corresponding Windows login, so may be just confusion between the two....

• This reply was modified 6 years, 6 months ago by webrunner.

PS The user is now also reporting that he can't view object definitions or find/select from a table.

I can see the SQL login in the db_owner group, so I have...

Thanks, ZZartin,

I don't see any DENY entries for this database user. I used this query from another SSC forum post (replacing 'someUser' of course):

SELECT *

FROM sys.database_permissions

WHERE grantee_principal_id...

I know this is a very old thread, but regarding your last statement "The CI conversion only, took 1 hr 1/2 to complete and required 160GB of extra space for...

Hi Rechana,

Your question is interesting to me even though unfortunately I don't have any expertise to share with you. but I subscribed to see what you end up choosing as...

Thanks, Carlo. That's crazy!

-- webrunner

Very instructive - and scary - answer!

I guess there is or was a typo in the SQL syntax. Definitely worth calling attention to any such error, but the question is...

Thanks for the feedback, Phil and Sue!

webrunner

I use both, but honestly, I have found SSDT (well insofar as I need it to make SSIS packages) really annoying to use. So much is embedded in cryptic settings...

• This reply was modified 6 years, 8 months ago by webrunner.

Thanks for you reply, Drew.

Quick question - could you send me the syntax error that you got? I just ran the code and did not get any errors.

To answer your...

Thanks for this question. I got it wrong but learned something important about COALESCE.

-- webrunner