Gail gives you the right idea. Create logins on the principal, script out and xfer to the mirror. Changes permissions/users only on the principal

No support on weekends? Is this in the US?

That doesn't sound right. Polyserve was a small company before HP bought them, but I can't believe they don't provide support on...

You can't avoid index fragmentation unless you don't change data. Sooner or later with deletes or page splits you'll get fragmentation. The thing to do is monitor it (as shown...

There shouldn't be restrictions, but there could be some things that don't work. My Query Analyzer connects, but because it makes some calls that aren't supported, the Object Browser doesn't...

The first command runs a backup to a UNC device, appending backups to the same file (listed there). This is not recommended for a couple reasons

- The backup across the...

Once the logins are moved, if you repeat the process, they will remain there (assuming you're not messing with the master database). You will still need to use sp_change_users_login to...

Someone must have altered them somehow and not restarted the server. Were there any trace flags set on the service startup?

You can move the files back using the process here:...

You could search through syscomments for "select *" as a key phrase in those objects that are views.

You need a trace to see what activity is taking place. The log grows when any transactions are running, including index rebuilds, DBCC, etc. Something is happening. Check jobs as...

There isn't necessarily a great way to do this, although perhaps a tool like SQL Compare (REd Gate) can help.

select * isn't recommended because things can change. It also...

Is there a question here? You need more disk space.

SANs centralize the storage and often contain more drives than you can physically attach to one server. The PC architecture has limitations, and most vendors don't go beyond a certain...

I think the naming could be better. Logs, for the most part in computer science, are just extra information about what an application is doing. It seems more and more...

Very strange. Could you have two registrations? Perhaps under another email with the same display name?

If you're having issues, then you might need to apply the SP. If not, I'd hold off. Typically when I've called MS in the past, they want the latest SP...