That actually means that it's impossible to backup. I wanted to backup a set of tables from differnt filegroups, along with all their (possible) constraints, triggers, indexes, etc.

Thanks all for your input.

I had similar techinique to what Lowell suggested, but yours is better. And I also removed the code where I select inserted and deleted into a...

But what the difference it makes for you how you call yourself Junoir, Senior.

Hi all, I even did not expect so many replyes over the weekend.

Dan: Yes, I am looking at space available, and that's easy query, I use sys.database_files along with...

First, they do affect the performance. From time to time users get a messages that SQL Server cannot allocate space in tempdb.

Second, notify managers via email when used space in...

It looks like this is the problem, I do not have 'sa' privileges.

That's because I am tasked to write a script to find largest objects in tempdb. They affect our performance. The code is simple, I just join sys.tables and sys.sysindexes in...

It works, Jack, if I run this code in same connection. But I need to create a temp table in one connection and search for it in another one.

That's amazing! Thanks a lot, Perry. Actually I can use it not only for backups or restores, but for anything else.

Thanks for quick reply, I found files for my table, but this is only 50% of what I wanted: I want to find page numbers as well.

I handled this question in a stupid way. Since this position also assumes some Oracle (but not required) and I never heard about semaphores in SQL Server, I answered that...

Thanks both Lowel and GilaMonster, now it's little bit clear for me.

As I understood correctly, semaphors can be used by developers for row versioning, and is used by SQL...

Thanks for "smart" reply, GilaMonster. I also could have gone to Google and search for it before posting here, but all that links give only very general explanation of it,...

So it looks like the most replyes revolves around two fonts : Arial vs Times. But are there recruiters or hiring managers here on our board ? What's your guys,...

Thanks Gethyn

This is exacltly what I needed. Also, should I set it to multi user after restore ?