Thanks, that query is much faster than mine.

:blush: You're right it's 5 nibbles..

I was just testing, I am simulating an uniqueidenfier column and needed to split the bigint into...

Thanks Grant.

I can see it now clear.

Will contact you in case of needing a compression software 😉

Steve Jones - Editor (5/19/2010)

---

Ditto. Backup the db, shouldn't be too long at that size. 160GB isn't that large.

Detach, copy, attach.

You'll have orphaned users, so I'd use sp_help_revlogin (from MS)...

Hi all

Thanks for your help.

I didn't explain it very well. We'll make a backup of the system state.

The old server is dedicated to that database and, if something goes...

Thanks guys for your answers!

When you say 'backup'.. do you mean an SQL Backup? or files backup?

We are doing backup of the drive which contains the database every day, and...

Hi ggraber, thanks for your reply.

I've used your solution sometimes to enumerate documents, but this issue is special because the key is given by the user.

Hello again!

I've been reading this article:

http://www.sqlteam.com/article/implementing-table-inheritance-in-sql-server

It simulates OOP's hierarchy like Michael suggested.

It could work.

Thanks a lot for your useful help!

thanks again!

The tables are in hierarchy (sub-dept under dept, dept under area and area under work-center). I could use a surrogate key for them.

I thought in a fifth table that...

Thanks Steve, so the best solution could be a trigger..

Thanks for you reply.

I think GIUD couldn't work.

The four tables compound the structure (work center, area, department and sub-department) that could have a company (it'll be an accounting program).

The...

The problem to use multiple databases is that if two tables are in separated databases and exists referential integrity between this tables, I must make stored procedures to control it. If the...

The problem to use multiple databases is that if two tables are in separated databases and exists referential integrity between this tables, I must make stored procedures to control it. If the...

Sorry for my poor english, I can't speak english.

I'll explain my problem a little more:

I've a general DataBase, this DB contain tables that will be used by all my applications:...