I am in charge of Security, Recoverability and Performance of the information that uses SQL Server databases

Done!

Snarky giggle

Great point Steve - one should not make changes unless one tests out or understands why the change is being made and knows what the effects will be. In...

Hi Michael - not being stupid here - BUT - I think you may have "nailed it!" I "assumed" it was a "true" 64bit machine, when in fact, I...

I agree it is "odd" and just to answer your question - yes it is a 64bit OS - Win2003 R2 Enterprise Edition x64 is what the Properties of My...

I would then do the 'obvious' and re-run the backup AFTER you have fixed the issue! 😀

Yes - DBMail is turned on and configured the same as the stand alone machines - and they are both using the same SMTP server.

I also verified Service Broker was...

Sorry to burst your excitement - but you GOTTA do better than that - I have Several of these

So how is performance for...

Thanks Kevin - and for the most part this Hot Fix is working on other servers (we have several) but a couple of them are causing issue.  For example, one...

You could also check out INFORMATION_SCHEMA views:

--will give you a list of ALL constraints in the db

SELECT * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

http://developer.mimer.com/documentation/html_91/Mimer_SQL_Engine_DocSet/Data_dic_views2.html

is a starting place URL for INFORMATION_SCHEMA views.

Keep in mind...

Thanks peter - I only saw your post after I was finished 'kicking' myself...

-Marti

OK - I feel a little 'silly' but I think I have resolved the issue: that dang SNAPSHOT backup. 

OK!  Now my morning is made!  And here I sit thinking I am a Lone Wolf with my imaginary delights of praying that "This will be the day that not...

Since you are an ASP.NET kinda guy - check out this Site: http://www.aspnet101.com/aspnet101/tutorials.aspx?id=44

It will give you a fairly simple installation direction.  As always - consult Books Online....

-Marti

I suspect the reason it is so 'easy' to link in MS Access, is because both Exchange and Access use the same db jet engine