|
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
Customized Profiler Trace templates can be backed up - you don't need to recreate them everytime the IT guy formats or upgrades your workstation.
All one needs to do is export the template from the Profiler by going to File -> Templates -> Expo...
|
-
Nakul Vachhrajani Liked 11 Months ago through Just Learned | 1 Point
While trying to send mail via database mail option, encountered this error
' EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.'
Fix: From the message it was clear that it needs permission to msdb databa...
|
RKA
91
·
2% ·
598
|
|
-
Nakul Vachhrajani Liked 11 Months ago through Just Learned | 1 Point
While trying to send mail via database mail option, encountered this error
' EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.'
Fix: From the message it was clear that it needs permission to msdb databa...
|
|
RKA
91
·
2% ·
598
|
|
-
Nakul Vachhrajani Liked 11 Months ago through Just Learned | 1 Point
I were working for UDF full properties last night and a very healthy chat with Jason,Ninja's_RGR'us, and Lowell at other blog site. I founded some point to share plz have a look....
======================
··UDF has No Access to Tables Variables exce...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
I were working for UDF full properties last night and a very healthy chat with Jason,Ninja's_RGR'us, and Lowell at other blog site. I founded some point to share plz have a look....
======================
··UDF has No Access to Tables Variables exce...
|
-
Nakul Vachhrajani Liked 11 Months ago through Just Learned | 1 Point
I were working for UDF full properties last night and a very healthy chat with Jason,Ninja's_RGR'us, and Lowell at other blog site. I founded some point to share plz have a look....
======================
··UDF has No Access to Tables Variables exce...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
I were working for UDF full properties last night and a very healthy chat with Jason,Ninja's_RGR'us, and Lowell at other blog site. I founded some point to share plz have a look....
======================
··UDF has No Access to Tables Variables exce...
|
-
Nakul Vachhrajani Learned 11 Months ago through Just Learned | 1 Point
I just learned this from MSDN. Below script is used to find what are the stored procs are created with "Recomplie" option.
SELECT OBJECT_NAME(sm.object_id) AS ProcedureName,definition as SQLText
FROM sys.sql_modules SM
INNER JOIN sys.procedures S...
|
-
Nakul Vachhrajani Learned 11 Months ago through Just Learned | 1 Point
I just learned this from MSDN. Below script is used to find what are the stored procs are created with "Recomplie" option.
SELECT OBJECT_NAME(sm.object_id) AS ProcedureName,definition as SQLText
FROM sys.sql_modules SM
INNER JOIN sys.procedures S...
|
-
Nakul Vachhrajani Commented 11 Months ago through Just Learned | 1 Point
You may be interested in reading about how to customize "GO". If so, please read my post: [“GO” as Batch Separator – Customize batch separator in SSMS & SQLCMD – What would you use instead of “GO”?][1] (and please leave your feedback as you go!)
...
|