When looking for these 'special' accounts - you have to specify the local system and search for 'nt service\mssql'. Once you do that they will show up and you...

Since that drive is dedicated to tempdb - why are you concerned with recovering disk space? Let it use what it needs...

As for the objects - do you have...

SSIS packages store the connection information in the package - and that is not stored as localhost. It is stored as the instance name - and for default instances...

If the original server is no longer running - then yes, you can transfer the licenses to the new server. You do want to make sure the new server...

You can also get different plans if the users executing the code don't have the same default schema - and the objects in the code are not schema qualified.

SELECT *...

I believe the problem you are having is related to the snap technology being used - which is causing the log chain to be broken. You need to find...

To see the other backups - click on the Timeline button to select the date range.

Note: I would highly recommend that you change your strategy. Using a single file...

Maintenance plans store the database connection information inside the package. So yes, when you clone a server all maintenance plans on the new system will have a connection to...

Generally - errors in SSMS creating or modifying maintenance plans can be tracked back to mismatched versions. There are some known issues where you have to re-register the DTS...

Nicole Garris (7/9/2014)

---

SQL Server 2012 Standard SP 1.

Stored procedure A calls another stored procedure B. Rowcount is set properly in called procedure B, but does not seem to return it...

Generally - that...

1024 KB = 1 MB

1024 MB = 1GB

KB / 1024.0 / 1024.0

Put the code I posted in a CTE - then use your calculations to convert it to MB/GB. Or, just wrap the calculation that is in KB with the...

I think you are making it harder than it needs to be:

Select db_name(mf.database_id) As DatabaseName

, convert(int

...

There are several products available that can help with this kind of data transfer. I used RocketStream before TIBCO bought them and it worked very well.

You have to be...