If you want to find out which databases are not used at THE CURRENT MOMENT use this query, since this is 2005 forum I wrote and tested against 2005, but...

I have to explain why we have such problems.

In our legacy application there were 4 lines for notes each by 80 chars, so there were 4 notes columns in...

I am actually using temp table, but I thought that CTE would offer more elegant solution.

Hi Jason, I understand what you mean. You append summary to the last column and it repeats itself as many times as many are records there.

Here I reproduce final...

Hi Noel,

While your solution looks interesting, I copied it but I still get only one result set, while I need both.

If I try to add select * from problem...

Yes bcp logs transactions (as long as the recovery model is full), but in my tests bcp was about 3 times faster then DTS/SSIS.

There is huge number of SQL Server 2005 books printed to day, probably about 100. Come to any Barnes and Noble or Borders store and check some books, you will...

I guess you need something like this:

Select

Prod_No,

Prod_Desc

from Products

where Prod_Category_No in (001, 303, 244)

Besides, if you disable indexes prior to loading and then rebuild them, I would suggest to drop them and create anew.

In SQL Server you can do nothing to improve performance. Even if you create index on Designation column query optimizer will not pick it because you have leading % wildcard.

However...

1. You are etrying to assign 2 values (f.FolderPath, d.DocumentID) while you need only the first one.

2. Correlated sub-query is written incorrect

Try to do this:

select FolderPath

from xsdl_Folder f

where exists(

           ...

You can use simple left function:

select name=left(name, 30)

from sysfiles

Just  make sure that the longest file name is smaller than this number.

It is sometimes inconvenient when SSMS allocates 255 character...

Maybe he has already forgotten about this posting due to some other urgent projects or he already resolved this, but we keep wrangling...

kill spid

I actually expected a reply with CLR, I tried to avoid this because I have no experience with it. We have some people who are familiar with C# or VB.net,...