Thank you Ram; this was very helpful. I went ahead and edited the script a little further -  these are the values that are returned from the script: DatabaseName, SchemaName,...

Ram,

The script seemed to have worked just fine but I spotted an issue with the results. The script is returning the objects in one of the databases for all of...

Ram, I can't thank you enough! Thanks!

The script below retrieves the following values for a database in my instance: ("OBJ_NAME" "OBJ_TYPE" RowCounts TotalPages UsedPages DataPages TotalSpaceMB UsedSpaceMB DataSpaceMB). I would however want to retrieve these values...

declare @sql nvarchar(max);

set @sql = N'select cast(''master'' as sysname) as db_name, name collate Latin1_General_CI_AI, object_id, schema_id, cast(1 as int) as database_id  from master.sys.tables ';

 

select @sql...

I am able to get some of the values for all of the database in my instances with a script I have, but not all of the ones I listed...

Got it! Thanks so much.

I believe the SQL Server Log and SQL Server Error log are different; the SQL Server Log is what I need help with exporting.  Is this log found in the...

Thank you all for your feedback.

When configuring multiple servers using mirroring for high-availability, can I use only one witness for all of them? Let say I have three sets of servers mirroring - can I...

Do you know if this issue persists across all SQL server versions or has it been fixed in any of the newer versions?

Thank you very much; looking into it now. I will update you...

I have been having trouble loading my comma delimited .csv file using Bulk Insert -  commas in the data are being read as an end of a field and it's affecting...