Understandable. It's a general question but I figured I get some other's opinions.

The code is fairly simple from what I have seen so far. I'm just worried about TDE and...

Just barely failed the 70-450 test today.

Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this test.

Those security...

I know this thread is a bit old but when you say "you really need disks/spindles, dedicated to SQL Server." do you mean have physical disks that the SQL VM...

Ahhhh yes. I should have thought of that.

Thanks a lot. I got it working.

Thanks for the reply. Here is the default location of the file I am putting the files in:

"D:\SQLProgramFiles\MSSQL10.STD08\MSSQL\ReplData"

The box has been checked and that folder is shared. Still no luck.

I...

This worked perfect. Thanks a lot. I was able to get the results I wanted by using a temp table but this is better.

The reason I am displaying the customerID...

I had the same problem. Check it out here

Worked perfectly for me.

I just ran into this problem. I had to replace a line in an email template in our database. I have no idea why the field was an ntext, but...

Oh man...Why didn't anyone say that before?!?!

That was my exact problem. I can't believe I wasted so much time on that and didn't even think of service accounts.

Thank you SO...

From what I have read, MS is NOT going to make a book for this test. I have heard that they recommend reading the admin pocket consultant.

I am looking into...

Well if it helps at all, I used to be in your shoes. I was doing QA at a start up company. Moved up, took over the QA department. Got...

Sorry, I should have mentioned it before.

I have tried hitting it via IP (and port) with no luck.

I have tried static and dynamic ports. I am able to telnet through...

Turns out I did set up the instance correctly. I RDCed into the staging server on the same domain and was able to hit the default instance.

I am guessing...

Worked Beeeaaaauuuuutifully.

Thanks.

The admin privilege got me for a second but it works great now.

Is there a way you can create a .bak on a different computer/server?

I thought you could only create them on the local machine. If it's possible, please explain how.

If you...