I haven't used SQL Server express in years now, but I am sure it should be available in all editions at the same location.

Look at the Management Node in the...

Looked like a home work, any way here you go...

SELECT * FROM #statementmaster

WHERE Serial ! = 700 or

(Serial = 700 AND Narration = 1 )

Welcome !

Lynn Pettis (12/16/2009)

---

You'll also want to a process to delete (drop) snapshots after a specified period of time. You can't just keep creating them as you will run out...

Choose the Login, right click and select properties, go to Securables page and click Add, select you server, you should see a list...

You need to have View Server State Permissions

Gifts

Even if you have no 3rd part tool, you can find what's going on with the databases. You have Activity Monitor start there, look if you have any kind of...

Try this

DECLARE @SnapshotNameVarchar(100),

@SnapshotFileNameVarchar(100),

@BKUPSTMTVARCHAR(4000),

@PHYFILENAMEVarchar(200)

SET @SnapshotName = 'Rob_test_snapshot_'

SET @SnapshotName = @SnapshotName + CONVERT(VARCHAR(8), GETDATE(), 112) + '_1800'

SET @BKUPSTMT = 'CREATE DATABASE ' + @SnapshotName + char(13)+ char(10)...

What is your retention policy of those snapshots, do remember that there is a performance overhead on having database snapshots.

Also restoring from one of them will be possible only when...

Agree with Grant's opinion. Linked Servers tend to slow down the query. But it is the only way where you can connect 2 different SQL Servers across different machines.

Depending...

As Lynn suggested, you can compress the data on a Page level or Row level not on a MDF File level.

What I read in an article was having a page...

Please don't cross post.

Let me ask you this, what is that you are trying to understand in SQL Server...

When you execute a package in BIDS, it executes under your security context, and runs fine (since you have enough permissions). But when schedules, it runs under the context of...