I SE of Denver, E of Parker. As you leave the Tech Center, if you headed E, you'd find me.

This is beautiful country

I think that Andy has it right, you ought to keep things private conversations private unless you ask permission. I have emailed a lot of people about things before I've...

like pentagram tatoos at an interview to work at CBN[/url].

Are there relevant entries in the SYSTEM or SECURITY Event logs?

You need to restore the full backup first, then each log individually, in order. I would restore everything with NORECOVERY always, so that if there is a mistake or another...

Jeffrey has laid it out well, and Joie is correct, you need to understand how your SAN works. I have had SANS that snapshoted things without letting SQL know that...

Do you know what SCD is? If you research a bit in terms of what this is, and how it works, you ought to be able to answer these questions.

Many...

You might defrag the index, but you cannot defrag a table without a clustered index. Set one up, then defrag.

What folder are you choosing? It shouldn't be the same one as the default instance.

As noted, this is a simple rights issue. Administrator doesn't necessarily have rights to every...

Public doesn't have rights to select from tables unless you granted them. And as noted above, you should not grant rights to public.

Before you remove them, however, you might...

Integration Services not being instance aware means you can't install multiple instances. It doesn't mean that security is compromised. SSIS still needs an account to connect to the named instance.

I'm slightly confused. The test you show has datetime values in it. Are you not using date data types and time data types.

The issue is that you have times that...

Glad it's working. Be sure that you have log backups running, and manage the size over time, watching the growth and balance that with the backups you need.

The horses do graze some down, but they're not consistent, and they'll eat to the roots, so it destroys the growth. We rotate them around the 4 areas we...

Moving this to 2005/Admin.

What is S3?