No need to add an (extra) row_number, because there is allready a rownumber defined and only the maximum rownumber is needed in the result

select

#abc.*

from #Abc

inner join

(select ID, MAX(rownum) as rownum...

Allthough the SQL Agent service is installed with SQL Express, it is not possible to start it. The SQL Express version doesn't include (a working) SQL Agent.

If you want to...

Why would you want a copy of the files themselves?...

Does the account of the user has enough permissions to login the SQL instance and on the database(s)? Take a look in the SQL Logging and determine the "state" and...

When you put a # sign in front of the table name, the table will be created in [tempdb] database. This table will be only available within your current session...

See the code below. I have stated remarks inbetween the code to explain the different actions.

CREATE TABLE users (

users_id VARCHAR(100) PRIMARY KEY

, username VARCHAR(100)

, password VARCHAR(100)

, designation VARCHAR(10)

)

CREATE TABLE travel_request...

Instead of INSERTing a single row where the values are hard-coded, you can also INSERT multiple rows using a...

If the destination database is created upon running your transfer, then there is another possibility. You can create a backup of the complete source database and restore this as the...

That is not what you have to do. You are changing the variable part into a hard-coded string....

chris.miller1 (7/4/2013)

---

Ok so I did so more research myself and please correct my assumptions if they are not right:

A full backup does not break log chains (only a log backup...

Just execute a restore command with the RECOVERY option.

RESTORE DATABASE [{databasename}] WITH RECOVERY

In your previous post http://www.sqlservercentral.com/Forums/Topic1469296-392-1.aspx I gave you allready a sample you can use to insert values into a table that has a foreign key relation to another table. This...

Of course I can't speak for anybody else, but from my experience it depends on the kind of DBA and the kind of company.

The larger the company is and/or the...

I'm sorry, due to too little time on my hands I didn't generate the correct code and didn't test this in my own environment. Today I'm able to give you...

I noticed an apostrof to little!

You'll need to add an extra apostrof after the text stats=10

I've edited the post above