Jeffrey Williams-493691 (1/3/2011)

---

Now I have to ask - why would you do this?

It really does not make any sense to backup the current database, then immediately restore over the existing...

MysteryJimbo (11/18/2010)

---

If the publisher was to fail there would be no way of syncronising between subscribers until the publisher was restored/recovered.

Peer to Peer transactional replication could tollerate a single point...

PaulB-TheOneAndOnly (11/7/2010)

---

Chan Wai Yin (11/6/2010)

---

We need to drop large amount of indexes and constraints and if we use SQL Analyzer to maually drop each of them this task would be...

If...

Do I need to backup and restore those system databases(master, msdb, model, tempdb etc) when I upgrade...

Actually we face...

GilaMonster (9/7/2010)

---

Exec sp_lock (which is deprecated, included only for backward compatibility with SQL 2000 and should not be used for new development) will tell you the current locks in the...

Yes, all kinds of transactional locks like read lock, update lock, exclusive...

GilaMonster (8/17/2010)

---

You cannot put SQL's database files onto a network drive, regardless of whether you create a mapped drive or not. Files have to be on local storage, SAN storage...

Because we want to have only one network hard drive for storage rather than using any local drive and we don't want to mount drive and using network sharing. Thanks.

We've already checked the history tab in replication monitor and nothing special, and we try to look through msmerge_history and msrepl_errors inside both our user database and distribution database and...

Thanks for reply. But actually we've already compared those tables are not synchronized with each other and now we want to find out the reasons and see if there's any...

no one knows??

klj (1/8/2010)

---

Hi,

I have two functions that converts between int and hex, perhaps you can use them.

Create function CRM5.udf_HexToInt(@input varchar(15))

Returns bigint

AS

BEGIN

Declare @x varchar

Declare @pos int

Declare @y bigint

Declare @z bigint

Declare @Result bigint

Set...

Yes, I want to change 0xFFFF(hex) <-> 65535(decimal) and vice versa and that's all I want.

How about any function that can change from character 'FFFF' to hex 0xFFFF and vice...