Great. Glad to be of help 🙂

Can I please suggest a slightly different procedure?

One reason is that your query will not work, as there are collation issues.

Please let me know if this works for you?

create table...

Database permissions live in the database. So when you restore the database, the permissions still exist.

However for SQL accounts, the SID may be different on different machines. To fix it,...

A few things,

Where are you running the management studio from? Is it on your Desktop, or the server where you have the restore running?

Also, what happens if you put this...

You can specify table hints to specify use of a particular index.

Select ID

FROM TableA

WITH (INDEX(TableA_NCI_ID))

Check "Table Hints" in BOL.

Can you copy the file to the server and then run the restore?

Can you not run the query in SSMS

select * from AdventureWorks.dbo.Employee

and select "results to file" and specify the location?

There can be a few ways. you can try CTEs and RANK like below

with cte(id, date1, date2, rank) as

(

select t1.id, t1.date1, t2.date2

, rank() over

(PARTITION BY t1.id ORDER BY...

What happens when you try with the full name (including the Domain)?

For E.g. ServerName.ad.dev

I dont think you can drop a Login, if it owns a database. IF you restore / attach the database, it will take the name of the person who has...

I generally use

select percent_complete, estimated_completion_time/60000.0 'EstimatedMinutesRemaining'

, *

from sys.dm_exec_requests

where command like 'backup%'

However, the Estimated_Completion_Time is not an accurate figure. It does give me a close enough figure on how long it...

SSMS would by default ask for a servername. That does not means you have any Database Engine installed on your desktop.

However, to confirm there are a couple of ways.

1)...

it is working for me. I have tested it both on SQL 2005 SP3 and SQL 2008 R2. What version are you running it on?

Database Shrinking is a very resource intensive operation. it will cause fragmentation. then if you try and re-build the indexes, it might use the space in the same database (unless...

I would be very careful if I change the file size (since it is production). if you alter the file size and try to set it up to a smaller...