If modifying the sp is plausible, then you can alter the statement where the sp prints the error message to a select.

example if the sp is printing a message then...

I think I know what the problem is. The stored procedure is printing the message to the screen and not returning a result set. Is this accurate?

If so,...

I found a function that may be more along the lines of what you are looking for. This function requires two inputs and the number of words you would...

mischif,

You should change the nonclustered index to clustered, per Jeff's recommendation. This way you ensure that everything is sorted correctly.

Thanks for pointing that out. It makes sense as the clustered index actually affects the sorting of the data.

In this case, the sorting of the data is...

I had a little different approach. Either way.

declare @startdate datetime,

@enddate datetime,

@sec int

set @StartDate = '2008-02-26 01:40:08.000'

set @EndDate = '2008-02-26 01:49:21.000'

set @sec = datediff(s,@startdate,@enddate)

select

floor(@sec/60)-floor(@sec/60/60)*60 as Minutes...

cdun,

Todd's solution will do the trick.

Providing table ddl and sample data goes a long way in receiving a quality solution. Todd had to take extra steps to figure out...

This does work and is the standard for dumping sp data into tables. What error message do you recieve. Below is...

Just saw your post. This is going to require a little more thought than an order by. Let me look at it more.

The easiest way is to order by cout desc and grab the first record, as Todd mentioned. I would stick with this method.

You need to do something like this:

create table #t (

id int identity(1,1),

[text] varchar(500)

)

insert into #t ([text])

EXEC master..xp_restore_verifyonly @filename='C:\Backup\MyDB.lsb'

You have to make the remote server a linked server. You can expand the server objecsts folder in SSMS and add a new linked server.

You have to use...

One way to view if a database is currently using Full Text Search is to open SSMS -> Expand databases --> expand the database --> expand storage --> expand full...

Are you trying to run a query or output the query results to a file?

The database maintenance wizard can take care of backups (overwrite) and database shrinking, but cannot truncate a table.

You have to create a job that does each step (Backup...