ghanshyam.kundu (9/9/2011)

---

It will work u just need to change something

UPDATE Community

Set NetworkLogin = 'c' + cast(id as varchar(255))

FROM Community c INNER JOIN

Constituencies cn ON c.ID = cn.ID

WHERE cn.ConstitCode = @PC

in...

There are a couple of thing wrong with your update statement...

First, SQL server uses + to concatenate values, not &

Second, I assume ID is an integer data type (e.g. integer),...

I don't see why you think having a PLAINTIFF table with a type indicator plus PERSON and COMPANY tables is a bad idea. It seems to me that you have...

Oops, yes, I did mean group 0 :Whistling:

The name isn't significant, you can rename it to whatever you want... preferably something useful

Which is why the differential is taking as long as a full backup

The differential should only be backing...

Are you saying that a Differential backup done using just the standard TSQL commands is quicker?

If the database has been heavily updated since the previous full backup, a differential can...

I presume you are questioning why you are getting NULL in the output.

If so, you need to initialise @colout. Unless you set the CONCAT_NULL_YIELDS_NULL option to off, NULL concatenated...

Yes, that's normal.

I would leave the shared drive in group 1, and install SQL Server 2005 in group 1.

That way, you can move the cluster resources independently of your SQL...

If the application is timing out, you should get an "Attention" event in Profiler.

Couple that with other profiler events (e.g. your long running queries one... look for long running queries...

Search this, or any other SQL Server forum, and you will see so many other people having issues backing up over a network.

Almost without exception, the advice is... Don't...

That looks very much like it's just a problem with the publisher not being able to connect to the subscriber.

It's the transaction undo file created when you restore WITH STANDBY.

It contains uncommitted transactions that need to be replayed prior to restoring the next transaction log.

Thanks for clarifying that Michael.

The trouble is, there are so many definitions of Julian date.

The OP mentions mainframe dates... His definition of a Julian date is in the form...

Michael Valentine Jones (5/19/2011)

---

"The Julian day or Julian day number (JDN) is the number of days that have elapsed since 12 noon Greenwich Mean Time (UT or TT) on...

I hope this isn't seen as hijacking the post, but as Robert is a mirroring expert, I would be interested to...