Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?
View Answer
| Apr 28 2008 3:49 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server stored procedures, Stored procedures
Running Procedures within the PL/SQL program
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!
View Answer
| Apr 28 2008 10:53 AM GMT
| asked by
Nimsalwayz
PL/SQL, SQL Server stored procedures, EXEC
Looking for a stored procedure to monitor size of Transaction Log file
Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?
View Answer
| Apr 18 2008 1:11 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server transaction logs, SQL Server stored procedures, SQL Server availability
