mysticslayer (7/12/2009)

---

The issue here is that I get an parameter filled with quotes. This isn't accepted by SQL Server when executing the stored procedure. So I can't validate on the...

Just to clarify, the TSM...

While creating a new database, you've specified the path of the new data/log files where files with the names u've specified already exist. Either change the path or change the...

isabel (7/12/2009)

---

what will happen if my "TO" is similar to the original path of my mdf and ldf files? will it cause error that will interrupt my restore? or will...

isabel (7/12/2009)

---

I am scheduling a restore process of my databse, i am confused about the "MOVE" option. I don't know what to indicate in the "TO" destination. Is the "TO"...

I changed the datatype of @TimeStamp parameter of the sp to TimeStamp and created some test data and i could select exact values

-- create a test table

create table #t

(

col1 int,

timestamp...

I suggest you to go through THIS article by Gail. Very good explaination on what options we have when log gets full or missing.

Edit-fixed the URL

can you pls post an example of the format of source data that u want to be converted to datetime?

ALTER DATABASE abc SET ONLINE

I'd prefer Full as it would allow me to recover primary database to point in time(1) and any which ways log backups in bulk-logged recovery mode are (perhaps) larger than...

The error you posted looks like the user doesn't have sufficient privilages to insert data in Books table. Can you reconfirm that as well?

create table #temp1

(

fld1 varchar(10),

fld2 varchar(10)

)

declare @sql nvarchar(500)

declare @FIELDS nvarchar(500)

declare @values nvarchar(500)

set @fields='fld1'

set @values='test value'

set @sql='insert into #temp1 ('+@FIELDS+') values ('''+@VALUES+''')'

--print @sql

exec(@SQL)

This code worked fine for me. Can you post the...

Are you worried abt performance or you just want help in insert/update/delete? In that case pls...

Do you mean suspect mode, recovering mode....? Pls clarify more..

Thanks Lynn. I'd never used that. Learnt something new here 🙂