T-SQL doesn't prompt for input. You need to provide the input.

Also, has anyone placed an order for silver spoons? Looks like we have a higher than normal demand.

Luis Cazares (6/12/2015)

---

I suppose that you could create an unformatted partition for the disk or simply deallocate all the space. I'm not sure what are you referring to.

Also, a disk...

Welsh Corgi (6/12/2015)

---

GilaMonster (6/12/2015)

---

Hell no. Use SSMS from a client machine. There's pretty much no case I can think of where you'd...

Alvin Ramard (6/12/2015)

---

Lynn Pettis (6/12/2015)

---

Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it. Maybe if you imaged...

Welsh Corgi (6/12/2015)

---

Lowell (6/12/2015)

---

No.

the point is there is no need to have SSMS on the server.

you already have...

Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it. Maybe if you imaged it first.

ScottPletcher (6/12/2015)

---

Your best chance might be to "unformat" the drive. Some formatting software makes provisions to do that. Of course the more you've overwritten any part of the...

Well, since most of us may not have the code for sp_who3 it would be hard to tell...

Didn't realize that SQL Server had a CORE version. I know that Windows Server can be installed as a core server limiting the surface area of an attack on...

We could if you provided the DDL for the table(s) involved, sample data for the tables, and expected results based on the sample data.

Has to be a permissions issue on the system you are using. Not something I can really tell you why.

Jeff's answer is good if you are talking about schema changes not data changes.

Have you tried running SSMS as an administrator? If you right click on the SSMS icon you should get a pop menu with one of the options being run...

This is also one of several threads asking the same question. Just haven't taken the time to locate them all.