SQL Server 2005 General DBA QuestionsPlease post SQL Server 2005 general DBA questions here.how to take the command prompt result in html file- September 17, 2008 Hi Friends, Every night we have to check the space available on all database related drive for all the 16 server. So I am taking this result with command prompt in a txt file. Can someone please suggest how I can take it into html format. We cant use the sql server mail option. So please let me know how can I take the result in html format instead of txt. Thankshttp://sql-server-performance.com/Community/forums/thread/151287.aspx SQL 2005 installation on server then upgrade to domain controller problems - DCPROMO- September 17, 2008 Hi there,Just wondering if anyone can offer any advice to a major issue I am struggling with. We have a brand new windows 2003 R2 server up and running and we then installed SQL 2005 server. After joining the server to our domain we then needed to turn the server into a domain controller. I run DCpromo on the server and all seemed to go ok.The problems started to arise when i was trying to setup the backup jobs and maintenance plans. After...http://sql-server-performance.com/Community/forums/thread/151286.aspx Emergency mode- September 17, 2008 Hey there. Once again this blonde needs help. We did a SAN snap of our production data drives to our training server. Something went wrong and me, thinking it was the same as previous times, tried to set the database in emergency mode so I could run dbcc checkdb, etc. Eventually we picked up that the SAN snap assigned incorrect drive letters to two of the drives. They changed the letters and voila, things were up. Except for one thing. The database is now stuck in..http://sql-server-performance.com/Community/forums/thread/151280.aspx Maintenance Plan Question- September 17, 2008 Hi All, Please help me how can I solved this error generated by the sql maintenance plan alert.I have no idea why I am encountering that particular error in 1 of my 3 named instance under 1 server. Failed:(-1073548784) Executing the query "EXECUTE master.dbo.xp_create_subdir N&39;Shared directoryDB1015488&39;" failed with the following error: "xp_create_subdir() returned error 123, &39;The filename, directory name, or volume label syntax is incorrect.&39;". Possible...http://sql-server-performance.com/Community/forums/thread/151267.aspx Difference among functions like original_login, system_user- September 16, 2008 I&39;m trying to understand the differences among the following functions: Functions returning login original_login() - original login name not impersonated one suser_name() suser_sname() system_user Functions returning database usersession_user current_user user_name() user Do I categorize the functions correctly (login vs database user) Are there any difference among suser_name(), suser_sname(), and system_user Are there any difference among session_user, current_user, user_name(),...http://sql-server-performance.com/Community/forums/thread/151265.aspx SharePoint 2007 & Database Table Partitioning- September 16, 2008 Hi All, Taking a stab in the dark here...Has anyone played with setting up table partitioning on SharePoint MOSS Content DatabasesI&39;m looking into the possibility of using this as an archiving tool; Google didnt turn up much...Cheers Stevehttp://sql-server-performance.com/Community/forums/thread/151239.aspx Update Stats- September 15, 2008 Hi All, My requirement is I cannot do rebuild indexing very often, So I have to do Reorg indexes and Update the statistics. Does anyone has a stored procedure for updating statistics for databases based ( 1 ) On thier rowcount, (2) Based on the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table, (3) And based on number of rows. This is Stored proc for SQL Server 2000, Do anyone have any similar stored Procedure for..http://sql-server-performance.com/Community/forums/thread/151216.aspx DB server role permissions- September 15, 2008 Hi.. How can i get database role permisisons on Particular databasehttp://sql-server-performance.com/Community/forums/thread/151213.aspx JobSSIS job failing intermittently....- September 15, 2008 hi. I created an SSIS package that imports data from 3 databases hourly into a destination server, and runs SUCCESSFULLY, everytime in debug mode. When I imported this to run from the destination server, it SUCCEEDS sometimes and FAILS often with a login error. I also ensured that the account that it runs under has sysadmin access to EACH source server. Please advise how to troubleshoot and resolve TIA! Executed as user: domainMyUser. ....00.3042.00 for...http://sql-server-performance.com/Community/forums/thread/151190.aspx sqlserver 2005 enterprise edition on windows vista- September 15, 2008 shall we install ss2005 in vista.. what are the other edition of sqlserver 2005 that we can install on vista.. thankshttp://sql-server-performance.com/Community/forums/thread/151188.aspx |