Nothing could be better than having all the data in one server. Both Linked Servers and coding from the front end would be more or less the same in terms...

Yes, I think you should use Linked Servers. Replication is when you...

ChrisM@Work (7/26/2011)

---

DECLARE @WordToCheck VARCHAR(30) = 'SQL SERVER'

SELECT Letter, COUNT(*)

FROM(

SELECT Letter = SUBSTRING(@WordToCheck, n.n, 1)

FROM (SELECT TOP 30 n = ROW_NUMBER() OVER(ORDER BY [Name]) FROM sys.columns) n

WHERE n.n <= LEN(@WordToCheck)

) d

WHERE...

What point?

brally123 (4/26/2012)

---

[font="Courier New"]Hi all,

I'd would like to ask some help from you gurus here 🙂 I'm fairly new in this so please forgive me.

I have two tables:

--------------------------------

| ...

This particular OP give me the feel that he/she thinks that he/she owns us. :angry:

Read a lot of posts from him/her. Its the same everywhere.

No Offense Riya Dave. Just what...

Thanks Eugene.

As simple it may be....but that was what I was looking for. 😎

Thanx for all the replies. Just climbed up a few steps on the learning curve and its...

Thanks Eugene.

As simple it may be....but that was what I was looking for. 😎

Run the profiler as a server side trace to know all user and server activities

The way I work allows me to get this down long before I start coding.

Step 1. I start with pen and paper and jot down a few algorithms. Normally, I...

capn.hector (4/25/2012)

method 1. one its bad to share passwords. what happens when some one leaves?? you have to change the password and that can get anoying. and...

Thanx again Dwain.

You're examples were very helpful and have definitely taught me some ne stuff. As far as the Dynamic SQL part goes....you can't have everything always...right??

There are uses for...

This might help:

read-data-from-xml-file-in-sql-server

SQLKnowItAll (4/25/2012)

---

Hehehehe... I certainly don't! Of course, that's what makes it a clever name for my blog. Anyone want to buy...

What was the answer??....:w00t: