Good morning all,

Just thought I would post this. It seems to me that the error message I posted, is a generic error message that SQL uses when it cannot for...

Hi @spaghettidba,

Thanks for your reply. I have followed the advice in the article, and here is my finding (problem still not solved)

On my local machine, with Windows authentication...

i found the answer...:-P and thought i'd share it for those of you who r interested:

select database_name,max(backup_finish_date) as backup_finish_date from msdb..backupset

where database_name='Libra'

group by database_name

There is also a useful article at:...

does anyone have any idea?;-)

Hello Everyone,

I posted this topic some time ago, and then got busy with something else...

I would like for my PRINT statements in my stored procedures to be written to an...

Thank you for your input - this solves my problem, as I can now continue with my project...:-)

i was also thinking about the latter solution, but wondered if there weren't other solutions

thanx, ill give it a try!

to get the hex value of your job:

select job_id from msdb.dbo.sysjobs where name = 'your_job_name'

to run the sp mentioned above use the following format:

EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory

...

absolutely FANTASTIC!!

Thank you very much, this is exactly what I was looking for.

I'm writing a java program, and in order to make the functionality as dynamic as can be,...

yes, maybe it is not the best way to do it, but it has to be done that way;)

Hello

I can confirm that the query I am trying to execute is of this format, (select * from x).

can you maybe give an example of how the fix will...

hi, not to worry, solved my own problem and will share the solution with those interested:

declare @date varchar(128)

set @date = select top 1 startTime from table_name order by StartTime asc...

Hi,

This is cool, but it is not the one I am looking for. I am looking for

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Or am I missing something? can the returned *.ldf file...

Hi,

is your problem sorted yet?

I agree with the previous writer, but alternatively:

in your vb code, retrieve the resultset with your data;

in the transformation of this data, that is, where you...

Hello Gail,

thanks for your interest. I have a procedure with an incoming resultset(rs)

then I would like to get all the column names of the particular table, tab separate it, into...