I thought it was a permissions problem so I googled it. Check this out, it might help:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1140586&SiteID=17

You can check the SQL error logs or the physical server security logs for more detail. If you don't find anything, post any detail that you or the user is...

And if you can rename the new machine the same as the old (after taking the old one off the wire), including the IP address, you shouldn't have any issues,...

I'm running S2K, sp4 and both the size and growth columns are the same value on both tables. This is for all my databases that I know have grown, both...

Avoid unneccessary shrinks of the database files. Size the files according to what is appropriate for your business/applicaton (I always error on being bigger than what is needed). Search this...

The account running the SQL services has to have the ability to lock pages in memory. As Colin stated, I've never seen that particular message but the response to the...

Count me in.......

DBCC CheckDB on a regular basis. Update statistics or rebuild indexes on a regular basis. By regular, I mean at least once a week. Keep in mind that this is...

Lynn is right. I forgot about HyperBac. Eval, eval, eval then spend the money that fits your budget. This came out last month in SQL Server magazine:

http://www.sqlmag.com/Articles/ArticleID/98180/98180.html?Ad=1

I've used LiteSpeed (Quest) and SQLSafe (Idera). SQLSafe was brought in due to price (isn't it always about $$$) . Very good support, very good products, both easy to use....

Another from Chicago. The market was very slow at the end of 2007, surely due to the holidays and end of year vacations. I had about 6 interviews in January...

Brandie Tarvin (4/17/2008)

---

But I have yet to find one in IT simply due to the fact that the IT managers I've run across know if they leave me...

Here is SQLite's website. They have some downloads that may be of use.

http://www.sqlite.org/download.html

Not sure if WE can close a topic (I believe that's what you're asking). I know Steve can. Simply quit posting to it and it'll fall off everyone's radar.

Promoting (my definition, anyway): applying the changes you made in the new database to the old. Or will the new database ultimately be your new production database?

Everyone has their own...