I don't know if there's a direct way to do that (might be), but you could log that with a start-up proc.

I'd break the item codes out into single-character many-to-many. Basically, they become a dimension.

If it's not running, or wasn't running at the last time the proc was run, it doesn't get you what you need.

I have to agree with Jeff's point, specifically because the context is an interview.

If I were interviewing a potential DBA, and asked a silly question like this, the whole point...

Wouldn't it be easier to use Row_Number() to rebuild the rows, instead of whatever cursor or loop you are using in your trigger to increment the numbers?

create trigger Table_Delete on...

Long-term, the idea of going back to Access because of ease-of-reporting is a bad one. Definitely. If you have immediate needs, and Access is the only way you...

I'd never try to use some clever "all the months without 'e' in their name", so I just took the list as having some business-rule basis, and decided that, if...

"Fiber mode" is part of lightweight pooling. It limits how SQL Server uses threads. Most likely, the server is set in lightweight pooling mode (it's a server option),...

You should be able to do that with a single insert statement, without using a cursor. I'd have to see the table definitions, some sample data (a few rows),...

Are you trying to find out whether a proc has been run recently?

If not, you can always modify the proc to log it's most recent run-date in a table.

I haven't run that particular virtual machine engine, but I have run SQL Server on virtual servers.

Have you tested to make sure the .NET framework is running correctly?

Unless the database specifically uses features that SQL Express doesn't support (there are a few, but mainly in terms of enterprise databases and server automation, probably doesn't apply), you can...

mmgorman (4/30/2008)

---

Hi everybody:

I have a database built through Mimer. It's a DBMS from Sweden. A user asked how difficult would it be to have that database run under SQL Server...

May I ask what this is intended to do and why it's a cursor instead of just using Insert ... Select ...?

Jeff Moden (5/1/2008)

---

Yep... gotta love it when the...