Shoot - that is one of the reasons I recommended reading the article about how to post. If I had something to test against, I would have been able...

If the event happened recently enough, you can try pulling it from the default trace.

Declare @path varchar(100);

Set @path = (select path from sys.traces where id = 1);

Select *

...

Check the SQL Server logs - should be something in there related to the drop/detach of the affected database.

jonathanmreynolds (7/21/2008)

---

Hi Jeffrey - thanks again for your time assisting me with this....

It probably did not install of the express edition - but, you probably missed the check box to install the database engine.

Try re-running the setup and make sure you select...

Okay, then it should be installed. How are you determining that it is not installed?

What services do you have that start with SQL*?

Try opening SQL Server Configuration Manager and...

levani (7/17/2008)

---

Hi all. I am quite new in SQL and I need help.

What I am trying to do is to export the Data from tables to Excel fiel

I creted the...

You probably installed the Express version and not a trial edition. The express version does not come with the agent.

To verify, run: SELECT @@version; from a query window or...

If you are going to be passing in all of the parameters, then no - you don't need to coalesce the parameters.

No - don't understand what you are asking. Please read the following article and re-post your question:

Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Are you asking about a database being backed up?

Look in BOL at BACKUP and RESTORE to see how to backup a database and restore to another server.

jbloes (7/20/2008)

---

I have an update procedure for my Location table. Out of all of these fields I'm updating, the only required field in the table is the LocName.

The problem...

George - I must of skipped right over...

The only way I can think of would be to create roles with the appropriate schema level permissions. Once you have a role defined, and assigned the users/groups to...

A table, by definition, has no order - so, there is no way to return rows in the order they were entered.

The only way you can write a query in...