Tara-1044200 (11/12/2010)

---

am i doing something worng here.

select distinct name from master.sys.databases s

inner join empdb.dbo.ldt a on s.name=a.dbname

where is_read_only = 0

and dbname in(select dbname,ntile(4) over (order by planid)...

NTILE() is great for these kind of queries

eg:

select a.name

from (

select name,ntile(2) over (order by name) as split

from master.sys.databases

) as a

where a.split = 1

select a.name

from (

select name,ntile(2) over (order by name)...

OpenXML will usually be good enough. Just look up books online

I was getting this error because I foolishly copy/pasted The SSIS Server Conections (tab called Connection Managers) from Visual Studio 2008 to VS2005. It runs fine in debug mode but...