touchwithme2 (11/18/2009)

---

Hi,

It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.

Plz update on this ....

Waiting for your...

I guess I am confused by that...

All instances installed have to have a name - whether it is the default instance or a named instance. The default instance has...

I would bet that the file you are working with does not have a CRLF as the record terminator. If the file comes from another platform - it could...

Nothing really - until you have a messed up...

It will show as synchronized - that indicator does not tell you the mode of mirroring but the state of the mirroring process and whether or not the mirrored database...

What do you want to happen with the 2012 instance in cluster 2?

If I read this correctly, you have 2 clusters and you want to combine the nodes into a...

You can use the 'undocumented' xp_deletefile which is called from the maintenance plan cleanup task. Since it is undocumentated - it may not work in future versions, but so...

thava (11/22/2012)

---

anthony.green (11/22/2012)

---

Well Table B has to have a value it its ID Column which exists in Table A you would an inner join.

If you want TableA to TableB then...

Why do you feel you need to reduce the size of the database? Databases grow as you add data - and unless you have had an event that grew...

If the password policies are different on each node - that could effect how soon that account would be unlocked. Or, it was just the fact that logins will...

There are no system tables - Litespeed installer will install the binaries on the server, setup...

Not saying this is the answer, but I have seen similar issues...

SQLSrvrN00b (10/1/2012)

---

The server in question does not have any snapshots or hidden DBs. The DBCC task that runs prior to this looks for databases that are offline or unavailable....

All the Execute SQL Task does is execute your script - so, if that script is not completing all of the tasks then the script has to be the problem.

This...

The next thing this could be is a problem with your script. We need to see the script now to determine if there are issues that would cause a...