| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> Database I'm using: Microsoft SQL Express 2005; How do I set up my database in SQL Server 2005 Express?
<1> ?
<1> what do you mean data_art
<0> ah...I'll tell you the whole story
<0> I'm used to using PHP/MySQL for my simple database needs. In particular, all I ever do with it is A) Connect to the database B) run my queries
<0> I'm trying to do the same with Microsoft SQL Server, but it's way complex
<1> nah
<1> what are you using to manage the database?
<0> I'm simply trying to get the Exercises in the Wrox book to work right.
<0> ah
<0> one sec
<0> Microsoft SQL Server Management Studio Express
<1> ok, that's easy to work with
<1> where do you have problems?
<0> now you're talkin'
<0> I haven't figured out how to add a database
<1> you are connected to the server?
<0> I think so. Is there a way to check?
<1> well, hold on, lemme start it
<0> dude, my first kid might be named Phyx
<1> hmm mine is ****ed, i need to reinstall .net
<0> take your time, buddy
<1> anyway, once connected
<1> when you start it, it shows a dialog to login right?
<0> aaahhh...
<0> let me check
<1> click connect
<0> there are three panes
<1> then look down to your left you should see "Object Explorer"
<0> yup
<1> you see your server in there
<0> there's also "Registered Servers" on the left
<0> yup
<1> double click the server in the object explorer
<1> it'll expand the view
<0> yes, Databases...System databases
<1> right click on the "Databases" node in the object explorer
<1> and click create database
<0> got it
<0> it's still working...
<1> after you're done creating it, you'll find it under de Database root node
<0> one of the choices was "attach". is attaching special?
<0> Database Name
<0> Owner
<1> yes, attach is to attah a .mdf file to a name
<0> wow!
<1> leave owner at default, just enter a name and click ok
<0> my tutorial has two .mdf files. shall I attach them both?
<1> you can
<0> I just need to know if this is where I add a p***word and all those database connection doodads
<1> p***words?
<1> you'll find those under the "Security" node
<0> got it
<0> so if I don't want any p***words, I'll set that up in security?
<1> well, i dunno if it'll allow it
<1> seems it does
<1> just add a new role, create a new user with no p***word and give it permissions to access the database(s) you want
<0> dude, I've been working on this since January...where have you been all my life?
<0> rats.
<0> it's being used by another process
<1> heheh
<1> what is?
<0> the mdf file - I bet it's something I did in Visual Web Developer Express...
<1> could be
<1> see if you can copy it somewhere else
<0> just for testing purposes?
<0> that's bad mojo bud...the disorganization...you should see my basement
<0> actually, you shouldn't see my basement
<1> no i mean, just copy the file on your drive itself
<1> make a copy, and attached the copy. if it lets you, if not, find the process that has it open
<0> cool...
<2> Hey all!... I have a weird problem. I am using MSSQL 2005, and have a SPROC which does a simple SELECT statement. I have two parameters. The table has each filed as 'uid int' and status nvarchar(25). Both of these parameters are used for a where statement Where (uid = @uid) and (status = @status). In the sproc i have the parameters intialized such as: status nvarchar(25). My problem is that when I run the parameter, it isnt returning the 3 ro
<3> where is my bunny
<4> knave: paste your code to a pastecode service so we can see
<0> Phyx: it seems to have worked, but it doesn't show up in the database list...
<0> Cannot attach a database with the same name as an existing database...hmm
<1> sure it doesn't exist?
<1> or did you create a database a while back with the same name?
<1> click the database node and press f5 to refresh
<0> I'm pretty sure I didn't...
<0> not in refresh list
<0> can I come back later after I've tried a few things?
<2> DevCodex: http://sql-servers.com/nopaste/?show=547
<1> yeah, but it's almost 24:00 soon
<0> ohch!!!
<1> i'll prolly be online
<0> ouch, that is...
<1> ifnot you can find me in other channels, i'm not normally in #sql
<0> thanks for all your help
<1> np
<0> is it ok to msg you if you're not here?
<1> imho i find the management studio in mssql2k better then this express one, it felt like it was more powerfull
<1> and they intergrated the query tool, i found it usefull as a standalone app, not having to open the management studio
<0> LOL...yeah, you have an idea what you're doing
<5> I should be able to execute stored procs from SQL express in my app right?
<5> I'm getting "SPROC not found" but its there
<1> using the right name?
<5> yep
<5> i imported everything from sql 2k5 to 2k5 express
<5> same code
<5> just using express this time
<5> dbo owns the sproc
<1> hmm my stored procs work fine
<2> is there a way to tell a sproc to write to console a value?
<1> but i only moved them from sql 2k ent to 2k5 ent
<2> im trying to debug this, and that would help a lot...
<6> Knave : sql doesn't have a console
<1> i think you can test in the management studio
<6> Knave : try PRINT
<1> if it's mssql you can run the queries from the management app
<2> Phyx-: the Sproc works fine when i test it by itself, but im trying to figure out why one of the values is not being set...
<7> !call W4HBK
<5> i've been getting an IP visiting my site like 10 times a day
<6> hey pose
<5> actually.......100 times a day
<7> **** ... hi yuppie
<2> test by itself = manually set the prameters..
<5> same IP whats that all about
<6> Knave : sql doesn't have a console
<6> Knave : try PRINT
<1> Knave: if that's working, i'm thinking you should check what you're feeding it instead of the stored proc
<2> I have..
<6> or amend the stored proc to insert the parameters into a table
<2> I actually manually set the value... so its not set by a variable.
<1> hmm
<2> so im actually just trying to observe what it DOES receive... if anything
<6> or amend the stored proc to insert the parameters into a table
<1> do what YuppieScm said then
<1> :)
<1> sure you're giving it the right name for the params?
<2> well i tried PRINT @status and it gives me an error.. might be becuase of where im doing it though.
<2> Phyx-: yeah..
<1> just create a table and push them there
<6> how ya doin', pose?
<1> like YuppieScm said
<6> or amend the stored proc to insert the parameters into a table
<2> ahh just to see what values they hold
<6> in fact
<2> Now i see what you are referring too.. very tricky ;)
<1> lol, NyQuil, is till laugh at that
<1> heheh
<2> hey now, i caught what you said, that wasnt necessary
<6> just to make the point
<1> he got it YuppieScm
<1> lol
<8> hey that rhymes
<6> hahahahaha
<6> "what d'ya know from funny, ya bastards!" - best movie closing line ever
<1> hmmm you should stick to your day job, a poet he is not that one, that he isn't
Return to
#sql
or
Go to some related
logs:
#computers
#beginner
#stocks
#mirc
TaJ RaSeCh
#politics
#politics
#hardware
#stocks
#firebird
|
|