Thanks Jeff.

We have fixed the issue by using the natural keys of their tables to join database B tables, and in database B we create its own Surrogate key to...

Thanks, I tried the same thing, it works great.

I think I just figure out one way is to compare the result of

select database_id, type_desc, DB_NAME(database_id),name, physical_name from sys.master_files

where physical_name not like '%.ldf'

and database_id not in...

Thanks, I know if attached, the files are used by sql service and cannot be deleted. But if detached, then the files may be not used and can be deleted.

Of...

Thanks much, we don't have mount points. I will give it a try

Thanks Gail, those are excellent ideas.

I will use some combination of it.

I think Gail answered David's post.

Can anyone help to answer my previous post too?

Thanks,

Thanks,

The reason we do that is we have a front end application they can choose serveranme and database name to connect tothis server, we don't want them to connect to...

Thank you SGT_squeequal.

Do you schedule this as a windows task or a sql agent job?

I will give it a try.

Thanks, I am currently using a sqlscript from this site http://www.sqldbatips.com/showcode.asp?ID=4 ,which enables sp_OACreate.

And I just came back from a SQl in the City session, it says to...

Thanks, but my question is where shall I configure alias, in 32 bits or 64 bits client?

Thanks, I DO mean reorgnize.

But if everytime it will reorganize every single index in the db every time it runs, why it maybe each time is shorter than the other?

thanks

Thanks, this is a database that instructor and vendor recommended to use simple recovery mode, we don't need to recover to point of time, but just recovered to...

A little confusing,

If I don't want to switch to full recovery mode, I just want to keep using simple recovery mode, do I need to do a full backup...

Thanks, when I change the database from bulk-logged mode to simple recovery mode, do I need to do a full backup right after that? By changing the recovery mode, does...