Could this issue be related to this post? Please check if your Windows version and service pack level coincides with the analysed environment.

KB978790 – Update to Windows 2008 to change...

Hi,

Have you tried using the T-SQL syntax? Additionally have you checked that you started SSMS using the "Run as Administrator" explicit option? Minimal role required for creating logins is securityadmin....

I think that you could try to use the PIVOT operator too. Other option could also be an scalar function that receives a primary key an then returns a string...

Hi,

An option could be using the -o (output) option in sqlcmd or redirecting output to a file using the "> logfile.txt" pipe in the command prompt.

I hope that helps.

Hi... I have tried to save the char limit and collation issues using the msforeach_db stored procedure. I hope this helps.

I don not if I am using the latest query...

Hi Basit,

Great article: quick and effective. Just a quick question, since in SQL Server 2008 the resource database is stored in Binn directory, did the disaster affect this directory? Also,...