July 22, 2015 at 4:05 am
Hi beautiful people,
Lets say I have no idea how to write a sql code.
But lets say I am good at managing sql server profiler tool.
So, is it possible to get sql code from sql server profiler without sql code writing knowledge?
-------------------------------------------------------------------------------------
[font="Comic Sans MS"]I am vba expert not SQL. HerryMarkowitz[/font]
---------------------------------------------------------------------------------------
July 22, 2015 at 4:08 am
Yes, providing you use the correct events and have the required access to the server. But don't ever use profiler (the GUI) against a production server, it can cause nasty problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 4:34 am
Hi GilaMonster,
Thanks for your comment.
I runned an inventory report from SAP front facade then checked from sql server profiler what was going.
And see that a lot of lines, all of them includes some codes...
But I need one line and one sql code.
Any idea?
-------------------------------------------------------------------------------------
[font="Comic Sans MS"]I am vba expert not SQL. HerryMarkowitz[/font]
---------------------------------------------------------------------------------------
July 22, 2015 at 5:30 am
A lot of copy-paste work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply