Issue Resolved: Customer Support got back to us and informed us about a table of 'counters' (all those Next Numbers). We updated the value and everything is OK.

Thank you...

Thanks. There isn't much in their KB, no hits. I have a call into their support - they...

CORRECTION - I just scrutinized the table and noticed menu_config_id is NOT an Identity!

Any suggestions where to look for the 'seed value' the app is using?

I found information about Reseed a SQL Servier identity column.

In a query window:

DBCC CHECKIDENT

(

menu_config_header

, RESEED

)

I ran this and tried adding using the application - got the same error message.

Dang! I...

Figured it out.

Here's a SQL Command to create a simple Data Dictionary. The Results columns are:

Table Name

Column

Ordinal Position

Data Type - Abbreviated data type and field length/attributes

Remarks - MS_Description (Note: I...

Phew! This is fun.

You don't have to tell...

I found a 'How To' for changing the xp_cmdshell configuration, courtesy of Mangal Pardeshi ...

A. Enable Xp_Cmdshell from Management Studio.

For enabling Xp_CmdShell from Management Studio you need to execute following...

Thanks Shawn.

I checked the suggested sites and Robidoux's appears to be the most straight forward one - in fact, the script I found looks to be the same.

At the end...

The error occurs each time the job is run, nightly at 7:00. (Except for the first 2 nights when the backup file that is referenced still existed).

The way I created...

Houston, we have a problem...

The job is failing. It ran the first couple nights - I checked to see if a record created the previous day was in the Test...

Thanks for the replies.

Dang! They shut down the old server just over a week ago.

Great! I was able to fumble around and create a job by performing the manual steps...

I feel like I'm blogging...

I've been playing with Activity Monitor and slowly gleaning items of value.

Finally noticed how I can catch 'blocks' in the PROCESSES section.

At one point I thought...

Rats! After an hour of finding, reading about, and downloading DashboardPerformance I get errors when attempting to install the sp's:

Invalid column name ... cpu_ticks_in_ms

Cannot find usp_Main_GetCPUHistory

This is what I saw...

Thanks.

Been looking at Activity Monitor.

Dashboard - Is there now a version for 2008? I've found some websites where the person is talking about modifications to the 2005 version to get...

Thanks.

I looked at the two sp's. Been browsing for a 3rd party tool that might help.

Take care.