you could do something like this:

declare @sql nvarchar(4000)

declare @name sysname

declare @t table (dbname sysname, filename sysname)

-- loop over all databases using a cursor/while loop, which I am too lazy...

have a look at sys.databases and sys.database_files

it's really really not a good idea to use select * in a view.

sivasenthilkumar (4/12/2008)

---

Thanks for ur reply.

How to find the UNICODE for Korean characters and COLLATE for Korean?

while inserting a column i need to give Unicode for korean?

Is there is any change...

nvarchar columns can take any unicode char.

the trick comes if you need to, for example, order by this column. In that case you need to specify a...

I wrote an open source app called scriptdb that will script out all objects in a db, and optionally the permissions on them.

It would be a fairly simple...

you don't necessarily need dynamic sql for this.

see: http://sommarskog.se/dyn-search.html

Loner (4/11/2008)

---

I work for a small company and everyone works at home. There is no physical location of the company. The company address is the CEO home address.

I...

is your CLR proc using any IDisposables without disposing them?

you could use bcp to export to csv, which excel can handle no problem.

good luck at your interview! remember to shave! 🙂

or put your query in a derived table:

select *

from refConcUnits r

join (SELECT code,description FROM OPENQUERY(pdxcommon, 'SELECT * FROM concentration_units')) x

on x.code=r.strunits

EDIT: forgot to mention that cross server joins will...

perhaps there's an error in the agent log. CDW uses an agent job to schedule the copy, so check there.

however much I'd like to take credit for that article, it's not mine. 🙂

Jeff Smith wrote it - his blog is very good btw.

I'd use backup/restore.