you should...

very weird;

since you got an SMO error, i might worry that you are using an older version of SQL Server Management Studio to connect to a higher version of SQL...

are you a sysadmin?

are you connecting via a dedicated connection?

does this return anything with the IsEncrypted column being 1?

SELECT

sm.object_id,

OBJECT_SCHEMA_NAME(sm.object_id) AS SchemaName,

OBJECT_NAME(sm.object_id) AS object_name,

o.type, o.type_desc,

sm.definition,

CAST(CASE WHEN...

you could create it WITH NO CHECK so it does not validate the existing data, and would be untrusted...but why would you want to do that?

referential integrity is a good...

i just confirmed this still works on SQL2016, so you are good for all lower versions too.

ok, try opening a dedicated admin connection,

and in the database in question, add this...

take a look at this thread, which explains you can use a combination of the Dedicated Admin Connection and a procedure to view the encrypted definition.

http://jongurgul.com/blog/sql-object-decryption/

if you happen to...

At least for me, i only want a last login if it's changed since yesterday. i don't need 50 updates to update to the latest second

By adding a WHERE statement...

whenever i do a SQL consolidation, i actually stop the SQL Service on the old machine afterwards, and see who complains that they cannot connect anymore, so I can then...

this knowledge base from MS says that support for bcp.exe to use UTF-8 was added to SQL2014 in service pack 2, so if you are in SQL2012, i think you'll...

does the issue go away if you run it in administrator mode instead? Right click...run as administrator?

I've seen that same error before in places where permissions were locked down pretty...

When it is blank white circles, it is specifically telling you that you do not have permissions to start and stop the service (where the MSSQL or the SQL Agent)

if...

here's my first pass, does this do what you are asking?

SELECT distinct jobnbr,tasknbr

FROM (

--do not have a JPRE or JPOS route,

SELECT * FROM #JobRoutes WHERE jobnbr NOT IN(SELECT jobnbr FROM...

it's not that intuitive, but you have to remember that...

yes there is Jim!

i had worked diligently on this same issue, and put together a pretty good version code base that creates a script by reading the metadata, to create...

This is what i slapped together to get started: i figured strip out anything Alpha might work, and preserve numbers, spaces and math symbols? but one of your examples had...