You can search the internet for videos, whitepapers and articles about SSIS. But SQL ServerCentral has the stairways...

On the internet you can find many custom scripts and solutions for database backup (many incuding database maintenance). Ola Hallengren https://ola.hallengren.com/ has a highly recommendedd solution, but you can find...

You could setup a "maintenance plan" using SSMS for database maintenance. This is an easy wizard to setup basic maintenance (including backup). Don't just check all the options, but read...

First of all: there's no need to put the SERVERPROPERTY in a subselect. You can place it in the outer SELECT.

Second: the EXCEPT is similar to the NOT IN statement...

First pauze the trace, then stop it. Stopping it will also remove the trace definition.

-- pauze trace

EXEC sp_trace_setstatus 2, 0-- sp_trace_setstatus [ @traceid = ] trace_id , [ @status =...

Kummu (10/16/2014)

---

Thanks for your reply.

I'm using SQLSafe for backups, when recovery model is changed from simple to full or full to simple and then try to run a diff/log my...

It doesn't sound logical. Can you extract the additional records from the second query? Maybe if you take a look at them it will show you the logic behind why...

Changing the recovery model from FULL to SIMPLE would break the LOG-chain. This implies a point-in-time restore after this moment is not possible anymore. All previous FULL and DIFF backups...

If your trace is...

You can define a specific end time when you start the trace. But it's also possible to stop the trace through code (using sp_trace_setstatus).

When the trace is running, there are...

PearlJammer1 (10/9/2014)

---

Thanks for the reply. What you describe is exactly what I thought. Would the following link help - It creates the logins from one server and you then run...

The second query only accesses one table, so it will likely use less resources. But if you expand the NOT IN list with more values there would be a break-even...

Every time you restore a backup to another server, all SQL-users within that database will be loosing the link to the logins unless the SID of both the login and...

Perry Whittle (10/7/2014)

---

HanShi (10/7/2014)

---

If you (or the application) are not able to use Windows accounts (i.e. Windows integrated security), you need to change the authentication setting of the SQL instance...

If you (or the application) are not able...