Mmmm... that's about as helpful as the government saying "Brexit means Brexit"!...

"Access is denied" sounds like an operating system error. Maybe you're trying to copy files to a location you (ie the SQL Server Agent or proxy account) don't have access...

I don't think you can do it with sp_who out of the box. What you can do is look at the definition for sp_who and create a new stored...

I think it would be quite a complicated solution in T-SQL, so much so that you may consider using a different language, but if you want to do it, here...

There are three roles in msdb, called something like SQLAgentUser, SQLAgentOperator and SQLAgentSomethingElse. Each gives a different level of permissions to a user to do things with jobs. ...

Yes, although I assume this is a one-off and therefore performance might not be too important. Also, using EXISTS might not meet the requirement. Since we know that...

Oh, I see, yes - having my ANDs and ORs in a muddle caused XML columns to be included. Good spot!

John

Eirikur Eiriksson (11/14/2016)

---

John Mitchell-245523 (11/14/2016)

---

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested pattern. ...

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested pattern. Beware that the INFORMATION_SCHEMA...

Nicole

Those aren't properties of the column: they're properties of the individual values in the columns. Are you saying that you want to find all columns that have at least...

I'm not sure what you mean by ON DUPLICATE - I don't think it's a T-SQL keyword. You'll need either a MERGE statement, or to do separate INSERT and...

No, you still don't need a loop. Put your list of tables in a temp table and join that to the results of one of the queries that you...

Interesting. I'm a sysadmin and I just restored a...

You don't need a loop to get table sizes. Just type "table size query" into your favourite search engine and you'll get plenty of pointers to what to do....

Like I said, the only way I know of doing it is to change the database owner separately. If you did it before and the owner was sa, could...