Awesome script, gets even perfect!

I've done some slight modifications and added optional support for scripting a specific dbuser - see @DB_USER.

If left empty it's executed for all users in the...

Awesome script ... thanks.

I've added support for dbid column when raw sql is executed which is not wrapped through a sp.

Maybe you can change your script that way.

I've also...

Added support for script generation of a given db principal name.

FYI regarding authentication_type

Keep an eye on here: https://msdn.microsoft.com/en-us/library/ms187328%28v=sql.90%29.aspx

It's only supported from 2012+ so it's not included in the following script.

DECLARE...

Hey, guess this should work for mapping orphaned users back to their logins but doesn't create missing logins. (Because it's not on the db level anymore)

This works from 2k5SP2 otherwise...

Wonderful - but where is the script?

Hey guys,

look at here --> udf_ListToTable[/url]

maybe you could run it within your performance tests,

Norbert

PS: For the way upsidedown take this --> udf_TableToList[/url]

Hi,

@davecason

Your function does only return 2 rows if there is a string like that given: 'bla;bla;bla'. And if a string like this is given 'bla;bla;bla;' 4 rows are...

Hello,

thank you for your very helpful tipp.

I'm gonna break down to single indexes and then running this really awesome script.

Maybe you can explain to me how the rebuild concerns the...

Hello,

thank you for your replies.

Lokk at this link from msdn. The LOG file will be used for rebuilding and reorganizing indices.

Yes, I'm backing up the LOG periodicaly so the LOG...

Hi,

what do you mean with "configure in service account"?

Shall I delete all profiles and accounts and login with the account the sqlservice runs? And reconfigure all mail settings?

regards

Norbert

Hello!

I'm using SQL Server 2005 Standard and the script is not running.

Always get a syntax error on the first select statement.

Any suggestions?

I can't find any error...

beste regards

Norbert