Database

FirstPrevNext

Re: Writing Stored Procedures Mazdak1-Apr-02 1:32 Mazdak 1-Apr-02 1:32  Michael P Butler wrote: What does everybody else use? I use the same thing and I don't have any problem with that.;) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Writing Stored Procedures Michael P Butler1-Apr-02 1:41 Michael P Butler 1-Apr-02 1:41  It is useable but it lacks the qualities of a decent IDE. I've taken to writing the procedure in the VC++ IDE and pasting them into Enterprise Manager. However this method isn't much use for making changes. I was hoping I'd overlooked a cool Microsoft SQL development tool somewhere and somebody could point it out to me and then laugh at me for being a dumb ass for still using Enterprise Manager Michael Re: Writing Stored Procedures Mazdak1-Apr-02 4:39 Mazdak 1-Apr-02 4:39  It seems that I'm out of date. (I hope I use correct word,my english is not very good.)I have to do something for myself.;) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Writing Stored Procedures AndyG1-Apr-02 4:34 AndyG 1-Apr-02 4:34  I use Query Analyzer and like it a lot better than Enterprise Manager. Andy Gaskell, MCSD MCDBA Re: Writing Stored Procedures Michael P Butler1-Apr-02 8:46 Michael P Butler 1-Apr-02 8:46  Doh. I've been using it with the object browser window hidden. I am a dumbass. Thanks for pointing it out, that is much better for editing stored procedures. Michael ADO problem milan31-Mar-02 17:44 milan 31-Mar-02 17:44  hi all, I got the following error while running the asp page that makes use of Stored Procedure .What might be the problem ???? Microsoft VBScript runtime error '800a01b6' Object doesn't support this property or method: 'CreateParameter(...).Append' thanks Re: ADO problem Wanderley M1-Apr-02 3:16 Wanderley M 1-Apr-02 3:16  Could you give more details? When you use a command object, you usually need to do something like: set cm = server.createobject("ADODB.Command") cm.Parameters.Append cm.CreateParameter(...) HTH Wanderley MSDE users and passwords Lockhart31-Mar-02 9:47 Lockhart 31-Mar-02 9:47  I'm using ADO to interface with MSDE (Microsoft SQL Server 7) but I still have some doubts: 1. What the 'sa' UserID ? Can I use it from my app ? 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Thanks in advance. Re: MSDE users and passwords Giles31-Mar-02 10:05 Giles 31-Mar-02 10:05  Frankesk wrote: 1. What the 'sa' UserID ? Can I use it from my app ? Administrator. Don't use this for normal stuff, as it gives complete access to the database. e.g. create\delete databases, tables, etc. Equivelant of logging into the NT Machine as the local admin. Frankesk wrote: 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Well I don't know about the MSDE extact, as I usually develop on a copy of SQL Server with the Enterprise Manager - which is a GUI front end with wizards etc to create new DB's, tables, Views all the way to new users and roles. Otherwise you may have to do it programatically. On Windows 2000, goto the Control Panel, Admin Tools, Server Extensions Admin. From the menu Add\Remove, and then add from the botton of the dialog. Choose Micorsoft Enterprise Manager. From there you can then administor the Server though the MMC pluggin. Hope this helps, Giles Re: MSDE users and passwords Lockhart31-Mar-02 22:45 Lockhart 31-Mar-02 22:45  I'm going to search for the XP version of the admin extensions, if they exist. Thanks. Re: MSDE users and passwords David Salter3-Apr-02 11:17 David Salter 3-Apr-02 11:17  Frankesk wrote: 1. What the 'sa' UserID ? Can I use it from my app ? This is the administrator account in SQL Server. You can use this if you want, but its probably best to create a user with the minimum set of access rights required to do what you want. Frankesk wrote: 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Have a look at sp_adduser and sp_addlogin in the BOL. Dave about document_storing in SQL SERVER2K 30-Mar-02 16:26 30-Mar-02 16:26  Recently i meet with a problem: I want to store a word document into SQL SERVER and the field is image,but don't select from SQL SERVER.How can i do? thanks! How can I get a list of databases in .NET? spbdenis29-Mar-02 3:03 spbdenis 29-Mar-02 3:03  Could anyone suggest how to get a list of SQL servers and a list of databases using ADO.NET? In VB6, SQLDMO could be used for this, but how it is done in .NET? Any help would be appreciated. Thanks, Denis Re: How can I get a list of databases in .NET? Paul Watson10-Sep-02 7:07 Paul Watson 10-Sep-02 7:07  spbdenis wrote: In VB6, SQLDMO could be used for this, but how it is done in .NET? You can use SQLDMO from .NET: SQLDMO For C#[^] Paul Watson Bluegrass Cape Town, South Africa exa question about execute a procedure which take a long time realfly28-Mar-02 23:03 realfly 28-Mar-02 23:03  I have a program which execute a procedure through odbc. and the procedure is a big one, that takes several hours to execute. And the problem is that the my environment of the network is some bad, and during the long time of the execute, there would have an broken. and then the procedure will be return as an fail. Can anybody has any ideas? please told me, Thanks in advance! i am realfly8) executing .exe's from sql... l a u r e n28-Mar-02 2:34 l a u r e n 28-Mar-02 2:34  ummmmm maybe a dumb one but how does one execute an .exe from a sql batch in a stored proc for example? any help qppreciated --- "all's fair in love and war but in love there is no geneva convention" Re: executing .exe's from sql... AndyG28-Mar-02 5:22 AndyG 28-Mar-02 5:22  Check out "xp_cmdshell" in SQL Server BOL. Andy Gaskell, MCSD MCDBA Re: executing .exe's from sql... l a u r e n29-Mar-02 22:47 l a u r e n 29-Mar-02 22:47  thanks andy --- "all's fair in love and war but in love there is no geneva convention" Ado Program Run Error On Machine whithout VC++ IDE Forlegend27-Mar-02 14:29 Forlegend 27-Mar-02 14:29  My program about ADO run correctly on my machine,but it can't correctly run on the machine whithout VisualC++ IDE. I find it runs the following statment: _CommandPtr cmd; _ConnectionPtr conn; ....................................... cmd->ActiveConnection = conn;/Error occurs I don't why.Can somebody help me! Thanks very much!! VCBeginer Re: Ado Program Run Error On Machine whithout VC++ IDE Mazdak27-Mar-02 19:38 Mazdak 27-Mar-02 19:38  Forlegend wrote: it can't correctly run on the machine whithout VisualC++ IDE. Maybe the problem is because you don't have MDAC on that machine.Are you sure about it? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Ado Program Run Error On Machine whithout VC++ IDE Forlegend28-Mar-02 1:37 Forlegend 28-Mar-02 1:37  Oh! I get it. Thank you again!! VCBeginer msado15.dll missing Lockhart26-Mar-02 10:34 Lockhart 26-Mar-02 10:34  I can't run the code from the articles from CPj site. I haven't msado15.dll. I have downloaded and installed MDAC 2.7. I'm running WindowsXP. VC6 + SP5. MSDE + MSSQLServer 7 Re: msado15.dll missing funbag27-Mar-02 4:47 funbag 27-Mar-02 4:47  I'm sure it's somewhere on your system! Use the windows find utility to have a look for it. When you find it, copy it to c:\winnt\system32 and then from the dos prompt cd to c:\<insert your="" win="" dir="" here="">\system32 regsvr32 msado15.dll To unregister it, go back to the system32 directory, and type regsvr32 -u msado15.dll I'm running Win2k Pro, so I've never used XP, so I'm not sure what it calls the windows directory, but I'm sure you can figure it out! Good luck! skydiving....if at first you don't succeed, you're fecked! Re: msado15.dll missing funbag27-Mar-02 4:52 funbag 27-Mar-02 4:52  I found my copy of msado15.dll in c:\Program Files\Common Files\System\ado\ You should have it, but if you don't, drop me a mail... skydiving....if at first you don't succeed, you're fecked! Re: msado15.dll missing Lockhart27-Mar-02 5:42 Lockhart 27-Mar-02 5:42  Oh, thanks a lot, you have saved me... I used "Find" but nothing showed up (...) I found it in c:\Program Files\Common Files\System\ado\ as you wrote. Thanks again

Last Visit: 31-Dec-99 18:00     Last Update: 2-Jul-24 9:14 Refresh ᐊ Prev1...2433243424352436243724382439244024412442 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.