I am about to rename a column in one of the table. How can I check the dependency for the column specially in store procedure? I am using SQL server 2008.
Thanks in advance
View Complete Post
I need your help. Imagine that I have two tables:
Supose that my tables could be differnced by a number 1 is for ALUMN and 2 is for SPORT.
And the columns of each table too. So 1 is for IdAlumn, 2 is for Name and 3 is for Address. 1 is for IdSport, 2 is for Name 3 is for Players and 4 is for Description.
For example the combination of table 2 and column 3 is SPORT-Players.
Then I want to do an stored procedure that receives two parameters (the table, the column) @tab and&
I have scenario where i need to run my store procedure on specific time frame ? For instance i have a field in my table1 called count.
i think for this some job should continous run in background, I have store procedure and i want to run that store procedure as background job in MSSQL continous. How can we do that or any other approch? please suggest me.
This is the sproc I am calling from my Asp.Net application:
ALTER PROCEDURE [Uds].[Dashboard_GetJobs2]
@date as datetime = null
Select * From Uds.RealtimeLogging
Where (@date is null or [timeStamp] > @date)
If I ran from query analyzer I get the correct results:
exec Uds.Dashboard_GetJobs2 '9/20/2010 11:01:23 PM'
However, if I ran the Asp.Net page, ALL records are showed. Looking at the SQL Profiler I see the following call:
exec sp_executesql N'exec Uds.Dashboard_GetJobs2',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'
And if I ran the statement above in query analyzer it WILL return ALL records. Why????
I remeber I can use analyzer to debug sql in 2000, and it seems it does not have the analyzer in sql 2008 any more. Here is what I do:
1. select the SP, then script SP to->execute to->new window.
2. click debug.
then step into the SP line by line.
Is this the correct way to do it? one problem is: I will have to script the input into the SP directly. Is it possible to let sql pop the window and ask for input like analyzer does?