Re: Mass loading SQL SERVER stored procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: robert song (robert.song_at_modelsoftcorp.com)
Date: 10/07/04 

Date: Wed, 06 Oct 2004 19:33:46 -0700

Hi Kevin,

in Query analyzer run: insert into test(name) EXEC master..xp_cmdshell
'dir my_dir\*.sql' , have error msg:String or binary data would be
truncated.
So How to get only filename list from dir? Sorry asking you so detail
question, but I really got stuck here. Thanks.

Cheers,

Robert Song

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Backup-Problem mit einzelnen SQL-Datenbanken
    ... Versuch mal mein Skript im Query Analyzer: ... EXEC sp_attach_db @dbname = N'varial', ... dass der Query Analyzer nicht mit einer anderen Datenbank verbunden ist! ...
    (microsoft.public.de.sqlserver)
  • low speed in report
    ... i have a procedure in sql server ... when i exec the procedure in query analyzer it shows records in 2 seconds ... Prev by Date: ...
    (microsoft.public.vb.crystal)
  • Re: Linked Server - Force Translate
    ... > At first I created it through Enterprise Manger. ... > exec sp_addlinkedserver 'JDE', ... Hm, what happens if you convert the binary data to varchar, as in ...
    (microsoft.public.data.oledb)
  • Call DTS from Query Analyzer
    ... I'm trying to execute the following script from Query Analyzer. ... objective is to update the Global Variable in the DTS package. ... EXEC @hr = sp_OASetProperty @oPKG, ...
    (microsoft.public.sqlserver.dts)
  • Re: Enterprise manager performance
    ... you can find out lots of information via Query Analyzer. ... you can execute stored procedures to find out information ... exec sp_stored_procedures ... > display the stored procedures. ...
    (microsoft.public.sqlserver.tools)