I'll bet that back in the late mainframe days they were bemoaning laser printers because someone could print out client lists and they wouldn't look like output from a system,...

Try running DBCC SQLPERF (LOGSPACE). It will give you log size and percent utilization for all databases.

If you have some space left on your current server, you could add filegroups/files, and start moving tables, indexes, etc. to their new filegroups. That way, when you restore onto...

Cool, I'll check into that. Thanks!

Yes, like I said I did all of the steps that Microsoft recommends in their documentation in technet, I've set up SQL Agent mail many times, both on clusters and...

You can run the following and see if there is an article for a particular table, and if so, what the Publication name is (from the database in question):

select *...

I know that you can also grab that info with a Multiphase Data Pump . Lookup Multiphase Data Pump Functionality in Books Online. You can write footer information, etc. with...

There's a pretty good script for this in the script section. Do a search for 'Script to list all user and roles'

It will list users, roles, and database access (not...

I don't think that there is a way to do this in SQL Server. Look into application roles, though. If you can create an application role, then set up those...

I've seen a lot of people advocate importing the file into a staging table and then use Stored Procedures to do the Update/Inset logic.

I've only had to worry about this type...

If you delete the tables, you won't have to worry about turining IDENTITY_INSERT on. you could just use the Copy SQL Server objects task in DTS.

If you want to...

RAIB (Redundant Array of Innexpesnive Beers)!

i took a class at a local university (ASP.Net programming with VB.Net) and we used the Murach book. I really liked it as an introductory book.

I actually went further. Here's the originl setup:

1 Mirrorset - Transaction Logs (2 disks). Windows Drive I:

1 RAID10 - Data - MDF and NDF file (8 disks). Windows Drive J:

I was...

I got the best performance by creating multiple mirrorsets instead of one big RAID 10 set (Mirrored stripes). I created a filegroup made up of a file on each Windows...