Eirikur Eiriksson (7/27/2014)

---

This can be done, check Features Supported by the Editions of SQL Server what is available for your SQL Server Edition.

Suggest you have a look at these pages...

>>>>http://sql-format.com/

yes. This is what I need.

thanks

I want to format sql query.

Thanks. This was very much helpful.

I have one more question . ....... If I want to refresh data , what is the easy way to do this ?

Do...

I am worried because .....

source...

This worked fine.

Excellent.

Thanks guys.

Have a great day.

Loundy (10/22/2013)

---

2 second google search gave the link you need:

http://technet.microsoft.com/en-us/library/ms190447(v=SQL.105).aspx

This link gives you exactly what Gail is referring too - study it well, the example at the bottom shows you...

one can not change database names in...

still have confusion.

I am confused because you have mentioned database path. ( not disk path)

If you're restoring as a different name, you want the files renamed too, hence...

[/b]

bold part not understood.

Can you please put an example for the bold part...

Kurt W. Zimmerman (9/27/2013)

---

Now I have a data compare tool from RedGate called SQL Data Compare. This does much the same thing and works very well. It just...

Kurt W. Zimmerman (9/27/2013)

---

This is something I do all the time. There are several methods you can choose from. The first is a real simple method that you...

Is not backup and restore mess up permission ?

I am scared about it....I don't want to set up permission again.

All I need is fresh data imported from...

does it overwrite data in destination DB ?

I want to refresh destination DB in fact.

kapil_kk (9/23/2013)

---

spectra (9/23/2013)

---

I have two columns Student_ID and MAC_ID in my table.

I want to put Unique constraint on these two columns together.

I am using SQL Server Management...