Matt Whitfield (9/18/2009)

---

Ian Scarlett (9/18/2009)

---

In your "football", everyone can touch the ball with their feet and only one person can touch it with their hands (the goalie). So your game...

In your "football", everyone can touch the ball with their feet and only one person can touch it with their hands (the goalie). So your game is like watching two...

You may also be interested in Jeff Moden's article on how to split using a tally table (which I couldn't find the reference to this morning). http://www.sqlservercentral.com/articles/T-SQL/62867/

If you adapt your...

And this would be a prime candidate for a bit of SQL Injection unless you parse the statements first.

Vishal Singh (9/18/2009)

---

no confusion silverfox, I said if nothing works....

There is a script on this site to find the nth occurence of a character in a string. That should get you started.:-

http://www.sqlservercentral.com/scripts/Miscellaneous/30497/

Electrix (9/18/2009)

---

I suggest you do not have your backup in a separate group. Add the Z drive to your sql group so that when SQL server fails over the backup...

1. I have created a share "Tlogs" & given full control to the service account under which SQLAgent is running on Z drive as and given the backp settings option...

Don't forget, when using maintenance plans, they do the backups before deleting the old ones, so you end up with more disk space being used for a while.

That probably...

The only certain way to find out which is best, is to test both ways.

In his book on SQL Server 200 Replication, Hilary Cotter (SQL Server MVP) actually suggests method...

Jeff Moden (9/17/2009)

---

Are you saying that if someone else had a checking account with the name Jeff Moden on it, that I shouldn't be allowed to use my name on...

As you say, he did appologize... which is more than quite a few others have...

It does, but did you...

You admit to being involved in that fiasco!!!!:w00t:

Indeed it...