Gianluca Sartori (10/11/2011)

---

SELECT ... INTO can be minimally logged, while INSERT INTO is fully logged.

From a performance standpoint, it makes some...

Ole,

which settings are you using right now. The default setting is "Do not cache temporary copies of this report", so I wonder if any caching is configured yet.

SELECT INTO will create a new temporary table with exactly the same columnnames and datatypes, while in the second case you first have to do a create tabel where you...

Very good question even though I missed the point that INTERSECT precedes EXCEPT

luluwang205205 (10/10/2011)

---

i want to recommend easeus todo backup, it provide advanced backup scheduler and one-click to recover system to dissimilar hardware, incremental backup, differential backup, backup SQL server/ Exchange...

Tony,

have a look here:

http://www.mssqltips.com/sqlservertip/1622/generate-sql-agent-job-schedule-report/

I think this is pretty much what you want.

I'm sure there are a couple of ways how you can do it, but to me the simplest one would be this:

DBCC SQLPERF ( LOGSPACE )

If your question is why the statement like that doesn't work just look at the last part of the errormessage "or it may be an advanced option".

Under the default...

WHen you create the login on the secondary server you should use the SID option to create the login with the same sid as on the primary server.

-- get sid...

If you're using the Enterprise Edition you can simply crteate a Data driven subscription. In the query window write a query to select all the values

SELECT RegionName from yourTable

and...

ap123 (8/31/2011)

---

checked the version of the sql server - it is enterprise edition.

checked the sql services running in sql server configuration manager and found the following 3

1. SQL Server Integration...

Here is a stored procedure I wrote a little while ago to handle such an issue.

I takes 3 input parameters, first the job which you want to know the status...

abhishek_dwivedi03 (8/12/2011)

---

Cannot open backup device '\\matlkgfs1p008\BackupRepository\UPR_FULL_08122011.bak'. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

I have write persmissions on the shared location...

You have to put double-quotes around the table name.

DBCC SHOWCONTIG ("HumanResources.Employee");

Or even better since DBCC SHOWCONTIG is deprecated, use sys.dm_db_index_physical_stats

SELECT * FROM sys.dm_db_index_physical_stats(db_id(), object_id('HumanResources.Employee'), NULL, NULL , 'LIMITED'); ...

Mark,

is this a SQL login or Windows login?

I suspect it's SQL, so did you check if the user and the login are linked together? If not you can...