|
|
-
Vishal Gajjar Commented 2 Years ago through Blogs
No, Just 2 days apart.... :-)
http://sqlandme.com/2011/08/23/sql-server-hide-an-instance-of-sql-server/...
|
-
Vishal Gajjar Commented 2 Years ago through Syndicated Blogs
No, Just 2 days apart.... :-)
http://sqlandme.com/2011/08/23/sql-server-hide-an-instance-of-sql-server/...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned
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...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned
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...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned
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...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned
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...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|