get sysinternals handle to find out what other thing is holding your file.

I think you have an operator percedence problem: Your ORs stand on their own, neglecting the other predicates.

WHERE (c.CustomerID = '3942')

AND (ol.DetailTableID ...

- Nice intro to SMO for this purpose.

- Keep in mind, you have to inspect the .bak files content. They may contain more than one backup.

- You can even perform...

Books online states:

Converting a Partitioned Table to a Nonpartitioned Table

Changing a partitioned table to a nonpartitioned table simply involves modifying the partition function of a partitioned table so that the...

colin Leversuch-Roberts (6/16/2008)

---

ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it...

this is a long shot...

but are u member of the (local) windows group of DB2 users ?

Maybe launch a non-sql topic, to get a more accurate inventore of which SSC members are attending.

I am going to attend SQLPASS2008, but I had to use another code.

I hope...

Well... there is this little caveot with linked servers. They have their own credential mapping.

Have a look at the linked server security tab.

I don't advise to shrink data/log files on production boxes !

If sqlserver needs it, leave it that way ! so if you make an assesment of your space needs, you...

Last year at the SQLPass2007 conference there has been a pannel discussion regarding os virtualistion.

The conclusion in rough lines was:

- don't virtualise our db servers in a production environment

- virtualise...

No you're on 64bit.

In task manager, in the processes...

don't just move the binn, install, log,... because they are instance system resources.

To move data files, there are Ms KBs that describe the way to do it (userdb vs system...

you can download SQL2005 express edition at Microsoft download.

(keep in mind to download the sp2 version)

When running the setup, you should specify "kbmss" for instance name (according to your requirements)

also keep in mind, if SQLServer doesn't need memory, it will not use memory.

i.e. it may be your sqlserver only uses 150mb, if it decides it doesn't need more.

However...

I did interprete the line as "you can only mirror a database to a single mirror".

I'm still doing some tests with it, and didn't test the scenario you aim for.

What's...