It goes on for an year unless we mention any expiry date. V Nice B Teaser. I liked it. 🙂

Even two single quotes will also work fine.

INSERT mytest

VALUES

(1, CAST('<customer id = ' '1200' '>Acme</customer>' AS XML))

, (2, CAST( '<customer>Consolidated</customer>'...

2014

It does not drop the temp tables. Still there!

Nice Script but sp_OAMethod scripts are old com+ object types. Do you have any other latest scripting way to do the same?

This can be done easily using Microsoft Visual Studio Data Comparison.

Nice Question.

1 question, what is the suitable situation to use such command ? ( yes, not recommended to use in Production, I know ... but eager to know how we...

Getting the below error. Tested this in SQL 2014.

Msg 2561, Level 16, State 10, Line 2

Parameter 2 is incorrect for this statement.

Msg 2561, Level 16, State 10, Line 2

Parameter 2...

I have fixed this issue while running the below query...need to change the job name and login account details as required.

update

sysjobs

set owner_sid = (select SID from sys.syslogins where name...

if servers are connected via "registered server" list, does it mean that a session will away be active using my account?

Thanks. Actually I am trying to get the pk column and interested to feed in in the arrow marked place to count number of records.

But the $pk_key2 is being placed...

Nice and easy question. Just need to pass the values as below,

USe [DB]

GO

exec sp_estimated_rowsize_reduction_for_vardecimal

@table_name = 'Config'

Thanks Steve!!!

Ops no luck...

Pretty much easily available script