sql server2005 command promt

• ram-912425

  Old Hand

  Points: 317

  More actions

  October 18, 2008 at 12:35 am

  #194740

  hi friends,

  if i want to write stored procedure

  sql> ed checkuser then i will get a note pad.

  to do like that where and how can i go to that sql> prompt.

  if any body knows plz help me.

  thanks in advance,

  ram.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737159

  More actions

  October 19, 2008 at 11:41 am

  #886905

  There isn't a comment prompt in SQL Server. You can execute sqlcmd from the Windows command prompt and get data that you can send to a file or a program like notepad.

• ram-912425

  Old Hand

  Points: 317

  More actions

  October 19, 2008 at 11:14 pm

  #886967

  hi,

  thanks for your reply.

  cheers,

  ram.

• Grant Fritchey

  SSC Guru

  Points: 398979

  More actions

  October 20, 2008 at 7:46 am

  #887119

  Also answered here:

  http://www.sqlservercentral.com/Forums/Topic588077-149-1.aspx?Update=1

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning