Awesome. Query worked.

Solutions is very easy to understand and i an wondering why i couldnt think of this.

Ok, My question is kind of misguiding.

I want to list the logins which does not have any permission to any database (in User_mapping tab).

Ex login: test

At one time "test"...

I am still having the same issue and error. Anybody has any ideas how to resolve this?

Install Shell ?? I wish. Its prod, i cant install anything 🙁

I will check and install SSDT.

Thanks all

Yes :-). Obviously the final option is that.

Now, I am wondering if SSDT was installed. I checked and IS service is running.

Yes, I tried that. It lists all, but not data tools. I tried the same in another windows 2012 server and it lists there.

I am not clear why its not...

Thanks again. I will use the copy option instead of ADD.

Furthermore, a rather dumb question. I cant find SSDT in a windows 2012 server. Since there is no start...

Thanks a lot for the quick reply. Yes, I can use DTUTIL to export to folder. Then, from there, should i have to add each pkg, one at a time...

Yes, I tried giving the instance name and as well as the server name. Error remains the same.

Okey dokey. Being a dev I can shrink the database.

Would it also increase LOB index fragmentation?

Igor,

Shrinked log file. It didnt frag the indexes in the tables i am testing the Ola Hallengren script.

I have to understand the script to better customise it for my needs.

DBA From The Cold's script did the trick. it created table with above 90% frags.

What about LOB columns. Wont it have Fragmentation?

yes.. added few 1000 rows and ran deletes too. Fragmentation increased by 0.001409

Some are Big tables, has more than a million rows

To test the script, index frag has to increase. Only then the script process can be fully understood,.