It seems that as I talk with more people and get emails from this, that drivers are the biggest issue with Vista. Especially for home users with all sorts of...

I saw a few notes that only the add-ins will be Shared Source, meaning you'll need VFP9 to use them. I guess someone could adapt them back to 6, 7,...

You could do a union, with the WHERE clause in each specifying if that part of the union is getting inbound or outbound.

select sum(), count()

from phonelog

where direction =...

Easiest way to do this (if you need to, answer above questions), is to create a table (tablename, idreset). Have the user insert a value into this table, say the...

First, which version of SQL Server. Second, you posted this in Notification Services. Please post in the forum related to your issue, probably Admin or General in this case.

This looks like homework. Please do not ask us to solve your homework questions. You should be digging in and writing your own SQL.

Please don't cross post.

Discussion here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=353763

I'd make the space and copy it over. Any network hiccups will cause your restore to abort.

I definitely like Robert's approach.

I used to do this with objects by making my own DB, then storing a copy of sp_configure and sysobjects for each db. Then I'd have...

A latch is a type of lock and a timeout indicates that too much time expired. Are you getting errors from clients?

Blocks/locks/timeouts are not serious. They indicate your server, usually...

So they are not failing either? Are there any common attributes in what they do/access?

I'd enable some logging and see if a log is generated. Be sure SQL Agent is...

Event logs have lots of filters. You should be able to move out the SQL Login events easily.

Registration for the BI conference is open at http://www.microsoftbiconference.com/

What's the index? You can see if you have queries that are even capable of using it if you look at the first col in the index and the columns...

backup transaction mydb with no_log

will clear space as well. Then you can run the backup.

Be sure to setup log backups after this along with data backups.