anam (8/16/2009)

---

Sorry for any confusion. I agree with you on your following points

YES

The problem...

oo sure, but is this what you are looking for?

select

db.[name] as DatabaseName,

db.[create_date] as CreateDate,

mf.[name] as LogicalName,

...

anam (8/16/2009)

---

As masters above have mentioned, it wont break the logshipping process until Enable the Explicit Log backups. Any log backup done will have different (next) LSN and the destination...

Garadin (8/16/2009)

---

I think this is the longest thread I have ever seen. I read page 1 and page 248.

As to whether or not the posts have gotten...

Not much that can be done until you resolve the problem with the destination decimal(1,0) or tell us what you want done with...

harry.sh16 (8/16/2009)

---

As posted earlier my input in source is of Char data type with values like 0,1,5,6, 12,14, 22.

My destination data type is numeric(1,0). Do i need a transformation at...

Full and Differential backups will not break the log chain on the source database, so you will be able to continue running your full and differential backups after configuring log...

If you log your messages to a table variable first, you can then write those messages to a permanent table outside of teh transaction (either after the commit or rollback)....

Your best resource may be the one you may be replacing in January. Work with this individual as much as possible while you can. Learn the systems you...

Jeff Moden (8/15/2009)

---

Lynn Pettis (8/15/2009)

---

GilaMonster (8/15/2009)

---

Yes, you would.... Especially the one that reads 'MCT'

I've corrected him...

GilaMonster (8/15/2009)

---

Yes, you would.... Especially the one that reads 'MCT'

I've corrected him elsewhere also today. I'm...

Having read that you are using SQL Server 2000, not SQL Server 2005 you really should also pay a little closer attention to where you post your request for help....

I think I...

It would also help if you could provide the DDL for the tables involved, sample data that shows the problem you are trying to solve, expected results to be achieved.

Please...

harry.sh16 (8/14/2009)

---

I'm trying to convert number values like 0 , 1, 2 which are stored as char(10) datatype to numeric(1,0) datatype.

Both source and destination's are SQL Server.

Tried various type...