sp_MSforeachdb will run the command/script in every database.

I use it when I want to search every database for something, such as a "where used" scenario, but would be hesitant to...

If the query starts during file_1, but completes during file_2,...

I usually dump the files into a table so I can more easily query them, based on the file date and when an event occurred:

SELECT * INTO Trace_20131229

FROM fn_trace_gettable('F:\TraceFiles\MyTrace_x131123_x2330_54.trc', 1);

INSERT...

What do wedding invitations have to do with SQL ?

http://www.poshscript.com/

Yes, great example of what not to do !

You just need to put in some UPDATE statements at each step.

You can't choose a network path, but you can type/paste it in to the GUI screen. The you can choose "script" to get the code behind the gui and save/modify...

5. Simple means you could lose all the data between each full backup. So if you take a backup once per day, and you have a disaster right before the...

Someone else will probably have a better explanation, but I believe that although it is running in 2008 compatibility mode, it is still a 2012 database underneath. It just can...

You cannot attach or restore a higher (newer) version database to a lower (older) version.

1 solution is to script the objects on 2012 server (in 2008 compatibility version), run the...

Thanks.

It is a table in an archive database that is in simple recovery mode.

The index itself is 1 or 2 gig. The database has 2 files (mdf & ndf), I...

I have been curious about this too, but in my case I have an Android phone.

Maybe the user needs permission to folder where the attachment is located ??

Yes, I saw that too, but I have already truncated the table. I will keep an eye on it.

Thanks

P.S. I wonder if I can restore a MSDB backup as MSDB_Test...

Thanks.

The growth seems to correspond to when I modified most of the jobs to "Log to Table". I did the same to other servers and they do not have the...