What are you really trying to do?  That is, take a step back and explain a little more, you may be asking the wrong question.

Choose restore  "From device", then next (pick disk) you should have some screen where there's a "browse" sort of option to select a file path on your computer...

First:

1) Get in the habit of using aliases.  This is really anoying trying to wade through unformatted statements.

2) format the statements for better reading

Probably would have been better to have...

See this for a scrambler utility:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=123939#bm177681

You can probably get an idea of how to modify it to do what you need.

Maybe you'll get inspired to add a randomization option...

OK, behind the magic curtain of EM is the fact that some of what it does is not magic.

That is, sometimes what it's doing is renaming, recreating, repopulating, dropping... but...

Half help:

Old defaults' (not necessarily declared constraints--I'm going from memory) source are/were stored in syscomments because they were like compiled code snippets.

Half jab:  Go with the "round" concept with that...

I'll be contrarian:

Everybody I've known who's gotten Dell has problems with them.  Many have to futz with support for a bit (but then support eventually comes through).  As best I...

"I have one last question for the group.  For those of you who have worked with both Oracle and SQLServer, is there a group similar to this one for Oracle...

".... For SQL Server I also do some DBA works eg granting permission, backup database..."

Yeah, but can you dance?

All the tiltles are silly.  Bottom line is how much you're making...

It all depends on what you want to do with the data/how it is to be associated. 

If you want to associate data with lines (e.g. points on roads) that's...

You can create a DTS job that does this.  That would be my preferred method: it's bad to do DML on things outside of SQL Server.

And if you poke around...

How (where) is the G: drive mapped on the server for the user ID that SQL Server runs under?

TRY: EXEC master..xp_cmdshell "DIR G:\" 

or similar to find out. 

Is the word in the column/table names or in the data?

One way or the other you'll be joining SYSOBJECTS (tables) and SYSCOLUMNS (columns) and either doing the query directly against...

First a non-sequitur: I hate GUIDs.

You're half way there.  Use IDENTITY function (SELECT IDENTITY( INT, 1, 1) AS sid ) to insert into a temp table (using TOP 100 PERCENT...

You need to be more clear in your question (your use of the word 'lock'):

Is it just that the query takes forever?

Or is it in a livelock condition that you...