05-18-2013 07:01 PM - edited 03-18-2019 01:08 AM
Hi,
I found this from the help, anyone know where can I run below SQL statements? thanks!
Displays free disk space for each partition on the database server. For this to work, the OLE Automation Procedures option needs to be enabled. For new SQL Server 2005 instances, OLE Automation Procedures are disabled by default. To enable this option, run the following SQL statements on your SQL Server
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
Solved! Go to Solution.
05-30-2013 07:43 PM
On your TMS Server, go to a Command Prompt and use the SQLCMD.exe to connect to your database and run the commands.
ie SQLCMD.EXE -S.\SQLTMS -E
where .\SQLTMS is the location of your TMS database instance
You can then issue the commands in your first post.
Please remember to mark helpful responses and to set your question as answered if appropriate.
05-18-2013 09:05 PM
I take it you have checked TMS Server Maintenance, shown below, to see if this is not already enabled?
If it's not, then you need to run in on the SQL server where the tmsng database sits.
/jens
05-18-2013 09:42 PM
that is not enabled yet, but i don't know where can i run those commands...
seems not just open a command prompt and type it..?
05-18-2013 11:05 PM
Ah, no, you need to connect to the db, probably be best, and safest, if you open a case with TAC and they'll be able to show you in a Webex session.
/jens
05-19-2013 01:09 AM
if you haven't installed SQL management studio, please do so (the express version from MS is free). and run the command there after connecting to TMSNG.
05-20-2013 10:56 PM
Hey,
No need to run the commands. Go to Start > Programs > MS SQL Server > Configuration Tools > SQL Server Surface Area Configuration. Select the same and open. Now select Surface Area Configuration for Features > Select OLE Automation and check the box. You are done, if required restart the server once.
Regards
Sumeet Rakesh
05-21-2013 07:31 AM
but under my MS SQL Server > Configuration Tools, there is no
SQL Server Surface Area Configuration .....
any idea?
thank you.
05-30-2013 07:43 PM
On your TMS Server, go to a Command Prompt and use the SQLCMD.exe to connect to your database and run the commands.
ie SQLCMD.EXE -S.\SQLTMS -E
where .\SQLTMS is the location of your TMS database instance
You can then issue the commands in your first post.
Please remember to mark helpful responses and to set your question as answered if appropriate.
06-04-2013 10:39 PM
thanks, it works!
06-04-2013 10:41 PM
You're welcome
Please remember to mark helpful responses and to set your question as answered if appropriate.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide