Please post what you've already tried so that we can see what you're struggling with. If it's getting the time difference, use DATEDIFF. If it's getting a corresponding...

Sysprocesses is a view of the processes that are running on SQL Server. You can't update it. If you want to stop any of those processes running, use KILL....

So you see that error message when you attempt to do the restore? Please will you post the RESTORE statement that you're running?

John

Well, you could fiddle about with an SSIS package or linked servers or similar wizardry, but I think the way I'd do it is to build the INSERT script on...

We can't see your screen, and we can't read your mind, so this is all guesswork, but how about this?

WITH Numbers AS (

SELECT n

FROM (VALUES (1), (2), (3), (4), (5))...

Something like this?

WITH Numbers AS (

SELECT n

FROM (VALUES (1), (2), (3), (4), (5)) x(n)

)

SELECT n

FROM Numbers n

JOIN T1 s

ON n >= Serial_Number

AND n <= End_Serial_Number

WHERE Serial_Number = 1

John

If you run a trace to capture failed logins, you'll get all sorts of extra information, such as the name of the application that's trying to connect (if the application...

drew.allen (5/26/2016)

---

You want...

You don't need table1 at all, do you, since everything is contained in table2? You didn't specify expected results, but here's a guess:

WITH Lengths AS (

SELECT

code

,code_name

,ROW_NUMBER() OVER (PARTITION BY...

DesNorton (5/25/2016)

---

If you need an editable "computed column" ...

Create a standard column [NICKNAME]

Create an INSERT trigger that sets [NICKNAME] = [LASTNAME] + ' ' + [FIRSTNAME]

Then the column is available...

Yes, that's true. You only want the actual key columns.

John

Do you mean (report_id, flow_name, report_item, source)? ...

But the user is dbo already, so you don't need to...

Yes, you need to reinstall as Standard (or build a new server and install on there) and then restore the databases on it, including the system databases. First, though,...

If userabc has just restored the database, then it's going to be the database owner (dbo), so you shouldn't need to run sp_change_users_login. Unless I've missed something, that is....