It's better if you just let SharePoint have it otherwise it will start b*tch*ng.

If for attach does not work use sp_attach_single_file_db.

Are you setting up another SharePoint App in DCB?

Read This:

http://support.microsoft.com/kb/918760http://support.microsoft.com/kb/918760

Grant same permissions to your SQL Agent Account as the SSIS package for that .bat file.

Great question and i got it wrong because i never used it. Learn something new everyday.

athiyamaan (7/10/2011)

---

error message :

Retrying the bulk-copy operation into the table " " without load ordering hint because bcp data doesnot appear to be sorted in the right order. This...

Open Sql Profiler select save to table option

In Events select Errors and Warnings then select:

UserErrorMessage

And in Column Filter select "Error" = 2812 for stored procedures

Setup another profiler session for Error...

Vicki

You should always check out scripts section 🙂

http://www.sqlservercentral.com/scripts/Security/71562/

These two scripts usually get it done but you need at least 3-6 months if not a year depending on your application.

Our App was financial so we had to run...

There are tons of system I/O happening in tempdb.

Tempdb is a place for instead of triggers, hash joins, sorts, version stores for snapshot isolation, cursors, indexing, (MARS), service broker ...etc.

Yes.

Cluster will only be mirrored in full transaction safety level because that's the only way mirroring is supported in standard editions.

dbcc freeproccache is ok to use in Dev but it's not going to help you in production.

You need to figure out what's being populated in your cache.

finding-procedure-cache-bloat

try deleting db user and server login and recreate both.

s_osborne2 (5/9/2011)

---

Hi,

We are trying to drop a UDF but we get an error to indicate that this isn’t possible because the UDF is currently marked for replication. There is no...

good question and i agree Microsoft does not have good documentation about it