Gotta love an ISP that depends on their customers to tell them that a portion of their network infrastructure has been offline for 2 days.

Sharepoint provides a whole bunch of web services for retrieving data from the sharepoint DBs. You're not supposed to be querying it directly. Maybe ask that in one of the...

See - http://www.sqlservercentral.com/Forums/Topic770808-149-1.aspx

Might be worth asking on a Sharepoint forum, like this one - http://social.msdn.microsoft.com/Forums/en-US/sharepointadmin/threads

Might have been added in SQL 2008. You can use the script instead.

team (8/14/2009)

---

I'll play with that. I can do it for part numbers but not for the part name. For example, if a user searches for 'resistor' and that...

Drop database is a bit extreme. Personally I'd try an index defrag on the cluster with LOB Compact first. If that doesn't work, then rebuild the clustered index

and, if you move the creation of the indexes to after the population, do you still get this error? If not, that's possibly a good workaround. It also means you're...

No,...

alex (8/14/2009)

---

I didn't write the SP, but I imagine that you're right - that the table can potentially be quite big and it was considered beneficial to reindex it after...

No. The GUI runs the same script you'll run. Could be there's an open transaction of something preventing the shrink. Maybe wait a few hours and try again. It often...

Having the DB in simple doesn't stop you from...

Jan Van der Eecken (8/14/2009)

---

Not in the case of personalised plates, after all you could...

Best to let SQL manage the locks itself. No matter what you specify, an update (any data change) must take an exclusive lock while the data is been changed. This...

This isn't T-SQL. Looks like C# to me, and there's nothing database related in there. You may get better and faster replies posting this pn a C# forum, maybe one...