Yup, that's what it's all about break it down into workable chunks. Pick a piece of the puzzle and work that then the next piece etc.

The real take away...

Don't just write it off as not understanding it... take a moment or two and work from the inner most query (the one tabbed all the way to the edit:right)...

Yes this is possible. You can either create the new database first or create it during the restore operation...

Make note of a few things...

Be very careful to restore to...

When you open your services console(start|run|services.msc), do you see any of the following?

SQL Server (MSSQLSERVER)

SQL Server Active Directory Helper

SQL Server Agent (MSSQLSERVER)

SQL Server Browser

SQL Server FullText Search (MSSQLSERVER)

SQL Server Integration...

This should work for you, but you'll need to add your state table back in. There was no data in it and I was too lazy to add...

Can you supply some DDL and some test data for me so that I can see what you are seeing? That would make this whole process quite a bit...

Are you running this from your machine or the server?

Yup I looked at them and frankly dismissed them because it seemed like you were missing the columns that we'd need to provide any other type of solution... You...

The filtering on a variable column name will work with the CASE statement and it has the added bonus of only pulling in the data that you need. Filters...

Have you verified that both named pipes and TCP/IP are configured to allow connections?

This can be done via the SQL Configuration Manager not The Surface Area Config tool.

-Luke.

If you're attempting to match text have you given any thought to using full text search? Today's newsletter had an article by Michael Coles which may be of interest...

Nope, It wouldn't have to be done via ASP I was just thinking that might give your user the best experience (ease of use) and make sure you always get...

yes the SA user is a member of the fixed sysadmin role by default, however I would seriously think about using a different way to connect to the server as...

You want the user to be able to save the file in a location of your choosing, then import it, then report on it right?

Why not build a simple little...

Stephen Lee (10/7/2008)

---

It's possible for one project to have a Status of "Open" multiple times, for example, it's it's Open, then closed, and reopened for upgrades. In that case,...