just be carefull and test with Exchange if you send the emails

we tried the first one by itself on Monday or Tuesday and it caused a battle royale between SQL and Exchange. SQL...

i'm pretty new at this SQL thing myself, but if you have a FK on a table I thought you needed to have the data in another table with a...

step 1 - create this sp

CREATE procedure usp_blocking_MSaccess as set nocount on

declare msaccess_cursor cursor

            for select spid from master.dbo.sysprocesses with (nolock) where Program_Name like 'Microsoft® Access%'

                                    or Program_Name like...

i'm hoping for year end or early next year. that is when we are upgrading and it would be nice to do some quick testing after the major testing to...

almost positive it does

we have a bunch of access apps that are always running and an automated process to kill their connections if they block another process

is the I/O the same?

how are the drives and the files on them set up?

do you set up your OS partition with little space and install everything somewhere else?

http://support.microsoft.com/kb/815431/en-us

found this by acccident while researching another problem. looks like it's just limited to named instances on windows 2003

do a select * from tables in the msdb unless they are pretty big

then do a select * with a like for the email address in the column that...

i think it's in books online

there is some crazy procedure and if you don't do it right you are screwed and may have to rebuild it again

i think it will run but MS won't support you if you call with a problem

MS isn't supporting SP3 anymore, but if you call they may help you

i use Veritas 5 Netbackup for a bunch of servers. Disk is still pretty expensive if you need months or years of backups. We keep 6 months of backups onsite,...

i think we figured it out

84 million rows in the table and the value in question has over a million instances and the one where the index is used is...

i rebooted the test server around 15 minutes ago based on an article I read on Technet and it's still happening

going to update stats again, even though i did it...

sqlmail is the most evil thing that exists and i cannot wait until we go to sql2005. i don't care about all the gee whiz things in it except that...