Can event profile capture sql statements when using oledb interface?
logic sequence :
Will SQL SERVER save the data like that(physical):...
When i use the store procedure "sp_spaceused TableX", it will show me the messages like:
As i know, when i use DBCC SHOW_STATISTICS(A,ix_1) command, i will get the message about the statistics of table A.
I don't understand why i use the...
I was wondering if there was any way to know how many times the store procedure was execute when the server start.
why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server....
In Store procedure:
1. Insert thousands of rows to tableA.
2. Update the rows in tableA Immediately.
can i do that in the store procedure?
When i call the procedure sp_jysczld_new from the Analysis Query, it runs slowly.
But when i extract the sql scripts from the procedure...
Separate names with a comma.