Its "by design"

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2016/04/27/sqlcmd-2014-fails-to-authenticate-via-kerberos/.

Complete and utter failure as far as I am concerned. The SQL Engine that can register/de-register SPN's (if allowed), doesn't do this at least in...

Ditto. I do leave SSMS running for a few days, and I get it moaning at me. I've got 11GB of RAM free on my workstation and still it complains.

"An...

The VMWare hotfix is only applicable to Windows 2012 - this is now superseded by a MS patch http://support.microsoft.com/kb/2811670 - recently tested.

Sorry the access denied issue on Windows...

Either the Group Policy change (though you can use Advanced Audit Policy Settings rather than "legacy" of Object Access and drill down further to not use "Audit Removable Storage" -...

Like you've and I've found, apparently the TRY CATCH statement can't catch the extended stored procedures errors:

http://communities.quest.com/community/litespeed/blog/2010/02/08/error-handling-with-the-litespeed-xps

It's a shame, same as when you catch a native backup failure...

+1 Lowell!

It makes my life so much easier this script. Great stuff.

Or this - doesn't drop users who own a schema

declare @sql nvarchar(max)

set @sql = ''

SELECT @sql = @sql+

'

print ''Dropping '+name+'''

execute master.dbo.sp_revokedbaccess '''+name+'''

'

FROM

sys.database_principals

WHERE type...

Ok I am English from England with a B grade A-Level in English Literature (ok a few years ago, but not that many).

I didn't notice the errors immediately.. but I...

Paul, fair point...plus all the websites that have been built using ASCII... I used to be a web dev, so should know better.

I thought it was a trick question... Unicode definately should be considered to outbar ASCII, don't understnad why it wasn't an answer.

Thought there's still a large set of mainframes...

Oleg,

Thanks for the heads up and clear explanation, does make a lot of sense. Will probably remember that one for a long time. 🙂

Eugene,

Whilst it's not neccessary to have...

I may be getting confused with what you're saying..

But all of this works fine

select @@rowcount-- check this one out

select @@rowcount -- check this one out

select @@rowcount -- check this...

The only errors encounted would be if you didn't have the database and table already created as the script relies on them existing.

There's nothing wrong with SELECT @@ROWCOUNT -- a...

Actually if you're on a case sensitive server it's:

SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%Deprecated%')

I didn't know about this, I don't know alot about the DM features of SQL...

sakthi_madan,

Run in query analyser:

SELECT @@ROWCOUNT

SELECT @@ROWCOUNT

The first statement returns a row with 0

The second statement is the count of rows returned from the first, i.e 1 row of 0.

Hope...