set statistics time on --timers

set statistics io on --disk reads write

print GetDate()

is the column declared binary of varbinary?

What do you get from my query?

My version is meant to be used as a UDF. It's much easier to use and versatile that way.

Select Dept, count(*) as UserPerDepartement, sum(case when Col = 'XP' THEN 1 ELSE 0 END) from dbo.YourTable group by Dept

Sorry I thaught that the split function was mentioned in that article...

Read this instead :

Arrays and Lists in SQL Server

won't work either... he's not using dynamic sql :

from today's newsletter :

http://www.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp

Basically, a Bookmark lookup is when sql server scans an index to satisfy a where condition, once the index is scanned, it starts retreving the data from the table using...

where Status = 0x80 and id = object_id('TableName')

First I would backup msdb as all the packages are saved there.

2nd you could use sqldmo to save all you dts to file just in case you can't transfer msdb...

Search the script section on this site for table size and you'll get a few exemples.

This is what he means :

Select O.Name as TableName, max(I.rowcnt) as Total from dbo.sysindexes I inner join dbo.SysObjects O on i.id = O.id and O.Status >=0 and O.XType =...

run this in query analyser :

SELECT DISTINCT Op.name AS ParentObject, Oc.name AS ChildObject

FROM dbo.sysdepends D INNER JOIN

...

Can you use the post method so that the parameters get hidden in the url?