I have created a new stored procedure. p_LogData
I need to know
a)how I can grant permissions to a particular user and
b) grant permissions to everyone to execute the stored procedure.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23343237.html
I am using T-SQL/ SQl Sever 2005
I have a stored procedure called p_log, this is called by other procedures.
I need to know if there is a way to find all the stored procedures that call p_log.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2334...
I have a set statement in my stored procedure witten in t-sql
I am pretty syre records are updated, but the message always displays
'Summary Records updated 0
So is this statement syntax corr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23352157.html
I need to find all the objects that reference a particular table
I tried this, but I get an error - Invalid object name 'Information_Schema.routines'
select * from information_schema.routines...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23354561.html
T_SQL -
I have a select statement which I set a variable to, if the select fails I need to default the value to a single value
Then on the next statement I concat some text and the variable
wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
I have a stored procedure P1 which creates a temp table #tmpT1, this stored procedure P1 calls another stored proc P2, the insert in the temp table occurs in P2, when I do a select count on the tab...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
I would like to know, if there are could be any reason triggers could be set in Production but not in Qa for a given table.
I just realized that while testing that certain tables in the database...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
Update statement in T-SQL
I have a table TransactionTable which has six columns,
ID - this is the primary key,
Region
RegionValue
Code
Date
Area
I have another table Translation
which...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
I have an sql statement where filters are appended base on the values passed in
I have six filter values a s input, of which all are bit except thte last one as varchar which a has a default value...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2338...
I have an T_SQL stored procedure
I need to know is there any way, I can add some wait or sleep logic in T-SQL
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23401382.html