|
Another thing you can try is enclose the reserved words in [ and ] i.e. [Date]
Bruce Duncan CP#9088, CPUA 0xA1EE, Sonork 100.10030 Hi everyone. My name's Bruce. And I suffer from VB.
|
|
|
|
|
I'm currently thrust back into the world of SQL Server Development after being away for quiet a while. I'm using the SQL Enterprise Manager to edit stored procedures.
What does everybody else use? Are there some better tools out there than SQL Enterprise Manager for creating and updating stored procedures?
Michael
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
I use Query Analyzer and like it a lot better than Enterprise Manager.
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
I'm going to search for the XP version of the admin extensions, if they exist.
Thanks.
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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#[^]
|
|
|
|
|
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)
|
|
|
|
|
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"
|
|
|
|
|
Check out "xp_cmdshell" in SQL Server BOL.
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
thanks andy
---
"all's fair in love and war but in love there is no geneva convention"
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Oh! I get it. Thank you again!!
VCBeginer
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|