parth83.rawal (10/2/2009)

---

Hi,

I have an EXE file which i would like to run, what i am doing is running following script but in void.... 🙁

declare @sqlcmd varchar(200)

SET @sqlcmd = 'WinWSSList.exe'

EXEC master..xp_cmdshell...

peter-757102 (10/2/2009)

---

Jeff Moden (10/2/2009)

---

That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has at least 4k rows on...

Jeff Moden (10/2/2009)

---

RBarryYoung (9/23/2009)

---

Heh. ...

Also i was asked about clustering if you have 5 nodes where one is passive and rest are active and you are planing to add more nodes then what would...

Dynamic pivoting can be useful for summarizing and consolidating Attribute type relations, but not for filtering it. And certainly not if performance is a concern.

And frankly, most client languages...

Hmmm, I just realized what you...

I...

RBarryYoung (10/1/2009)

---

OK, but why use XML message types in Service Broker, if they aren't helping you (and I don't think that they do in this particular case)? Instead just...

OK, but why use XML message types in Service Broker, if they aren't helping you (and I don't think that they do in this particular case)? Instead just create...

Comparative performance is tough to generalize between these options because it ultimately depends how many columns there will really be, and how large a range will you have to search...

On balance, my recommendation would probably be to use the Sparse columns if you have SQL Server 2008, and then to use the Attributes approach, within limits. That is,...

tdemille-1102706 (10/1/2009)

---

...

I have three approaches that I'm considering and hoping for input and/or a different approach.

* Current approach: Add more bit fields, sql queries are built...

Control-flow works like you probably think it does. You drop tasks on it and then, connect their arrows to control the order and conditions of execution.

Data-flow, is really the...

Hmm, what is the UID value that it lists?

Also, try this query and see if anything comes back:

SELECT * FROM sysobjects WHERE [name] LIKE 'dbo%'

How are you determining that this second table1 is created with a Null owner?

It seems much more likely to me that the first table1 actually has the name [dbo].[dbo.table1], which...