Ugly but it does what you want 😉

DECLARE @ServerNames TABLE

(

[ServerName] VARCHAR(50)

...

you may want to read this thread: http://www.sqlservercentral.com/Forums/Topic523260-291-1.aspx

Here is a simple rule. Show that the change (hopefully little) that you are going to make can be equivalent to $$$ for the company and you will be on...

Mike Levan (7/2/2008)

---

SELECT DISTINCT emp

FROM #tblseat

INDEX((IX_placing),NOLOCK)

I get the this error when i exec above sql stament in a proc

Incorrect syntax near 'INDEX'. If this is intended as a part...

Grinja (7/3/2008)

---

Hi,

this is my first 2K5 replication attempt.

I have server which is acting as Publisher + Distributor.

My replicated DB is 450MB pre-replication setup and after it is around 820mb....

riga1966 (7/2/2008)

---

I don't have any other solution other than add another job step

"Cancell_If_Time_Passed":

It's too many little steps now in the...

ungmax (7/2/2008)

---

Would SQL SP2 for SQL 2005 resolve this? Anyone know?

transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing...

I think Jeff is reffering to ALTER TABLE SWITCH ... for partitioned tables

Thanks for sharing!

smunson (7/2/2008)

---

You'll have to look at the Orders table to ensure that Title is a field within it. If it's supposed to come from Employees instead, then I'll have...

You should pass the "-h ORDER() " hint to your bulkload statement 😉

The first thing to do is to really "Know your data". You need to have an idea of what is stored and how it is. Then you will be able...

All of this is probably better handled from the client side but YMMV 🙂

I know DNS alias do NOT work for replication. For example try to register a publisher using a DNS alias in ReplicationMonitor and you will get an error like the...

Bob Shaw (7/2/2008)

---

We resolved the problem, by accident.

We had one single publication and the table causing the timeouts had about 70 joined filters on it for the child tables,...