Sew

I would start by taking a look at the service account, meaning the Windows account under which the SQL Server service is running. When you shell out to DOS,...

Eric M Russell (10/29/2015)

---

Check what domain groups or local Windows admin role may have been granted login and access, and then check if this user is a member of that...

Quick question - Why are you storing numeric values in a string column?

Pitcher

I can help you out with a couple of them, but I think Sean's right - you aren't going to get all of them in T-SQL. In fact, I'm...

I don't see any problem with it either. I tried Luis's version of it with both varchar and nvarchar, and the update statement you posted works fine. I...

I put the QUOTENAME around the database name in the query that concatenates the final SQL.

SELECT @EXEC_STR =

(

SELECT REPLACE(@SQL_STR,N'{{@DBNAME}}', QUOTENAME(SDB.name))

...

csheldon, what Jeff's talking about is some really cool stuff. He's done a SQL Saturday presentation on it before and it was great. I don't know where you...

Good Night

Phil Parkin (10/29/2015)

---

yb751 (10/29/2015)

---

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but...

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I thought maybe it...

Jeff Moden (10/29/2015)

---

Ed Wagner (10/29/2015)

---

That's pretty slick, Eirikur. I appreciate how you use string replacement using the rows in sys.databases to generate the final SQL to fire. I've...

You're most welcome. I'm glad we're able to help.

Personally, I think this is the best SQL Server forum in the world. Steve does a great job maintaining it...

Greens