Another way that might work is to create the stored procedure using the WITH EXECUTE AS clause. By specifying the context in which the procedure is executed, you can...

WITH max_salaries (Salary) AS

( SELECT TOP 2 Salary FROM Workers ORDER BY Salary DESC ) -- returns the two higher salaries

SELECT min(Salary) FROM max_salaries -- returns the lower...

Even when you use aliases for table names, the table name must appear explicitly in the query, so you firstly have to find the table names and afterwards find column...

Sorry I forgot the stored proc in may last post...;-)

use master

go

create proc dbo.Usp_SearchInProc (@s varchar(400),

@flag char(1))

as

/***********************************************************

Written By : yousef ekhtiari

email ...

Some time ago I downloaded the following stored procedure from the scripts section. You can rewrite it to find all the stored procedures that contain specific column names taken from...

After truncating the log using either NO_LOG or TRUNCATE_ONLY, the changes recorded in the log are not recoverable. For recovery purposes, immediately execute BACKUP DATABASE to take a full or...

[/quote]

did you test a single file against multiple files on the same array? any figures on that?[/quote]

Yes, I did... and again it's better to have multiple files (even in the...

george sibbald (2/11/2009)

---

Gail,

thanks for the feedback. It confirms my thoughts on the subject. One thing I am having quoted at me is that with a lot of databases on...

I have read this is valid for user databases too. The recommendation is from 1/4 to 1 database file per processor. In this case each file will be located on...

Since you're actually returning the value of the inserted key in an output var, your stored procedure should look like this:

CREATE PROCEDURE usp_Prognote_ProcedureNote

@AppointmentID int

,@PartyID int

,@EmpUpdated varchar(150)

AS

BEGIN

DECLARE @NoteID int

EXEC usp_Prognote_Insert @AppointmentID,...

SQL server 2005 offers CLR integration... so I have performed this kind of imports coding a stored procedure using C# that reads the text file and inserts the data to...

Sorry, It depends on how you coded usp_Prognote_Insert ...

It depends on how you have implemented the spu_insert.... stored procedure.

Regards,

Felix

The question is clear, but...

Don't you really have the last full backup taken???

If your answer is NO then you have to think seriously about your recovery strategy, since you can't...

The second query is not 100% correct because it depends on the dateformat. For example:

set dateformat dmy;

select 1 where getdate() <= CAST('01/15/2008' as datetime)

will raise an error.