| Author |
Topic |
|
countydown
Starting Member
8 Posts |
 Posted - 2007-03-12 : 13:52:08
|
| Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.I need to change the number of characters permitted in a certain field.I have to present this tomorrow morning so any help would be greatly appreciated.My friend flew to Italy last night and I cant contact him hence the question." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 14:33:12
|
| SQL 2005 I think. I have downloaded the above and am attempting to remotely access the database. Any tips? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 14:36:13
|
| What is meant by "no admin panel"?To expand a column, you can use ALTER TABLE ALTER COLUMN command. If you let us know more specifics, we can tell you the exact command to run.Tara Kizer |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:03:06
|
I have started to remotely use the SQL from my own PC. It now wants a user name and password which I do not know .Any suggestions?END RESULT: I need to increase the number of characters in a description field to permit the client to enter up to 50 words. |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:05:53
|
| The user needs to fill in a form, containing lots of fields. It currently only permits 10 words per field. I need to change this to 50. I have no experience so this is as technical as I can be at present but will try to improve. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 15:08:46
|
| You can't modify a column in SQL Server to expand it to allow more words. You can expand it to allow more characters though. Here is an example:ALTER TABLE MyTable ALTER COLUMN MyColumn varchar(100) NOT NULLThe above will modify MyColumn so that it now allows 100 characters. The command does not need to know the previous value. You'll need to decide what value to use for varchar. If you put the value too high, you may causes inserts and updates to fail later if the row size goes over 8000 bytes. You really should work with your friend on this.Be warned that by changing a column, you may break the application as the application may not be coded to allow more characters. So you may need to contact your friend anyway to have him modify the application code as well.Tara Kizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 15:11:54
|
quote:
Originally posted by countydown
I have started to remotely use the SQL from my own PC. It now wants a user name and password which I do not know.Any suggestions?
When you installed SQL Server, did you specify to use mixed mode or did you leave it at the default? If you left it at the default, then you need to connect using Windows Authentication, which will use the current security context. If you selected mixed mode, then you can use Windows Authentication or SQL Authentication.Tara Kizer |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:27:21
|
| Is there any way round not knowing the username and password?I have full access to the server. |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:30:35
|
| What is Windows Authentication? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 15:33:53
|
| Windows Authentication means you are connecting with your Windows credentials rather than SQL credentials. When using Windows Authentication, you do not need to pass any userids or passwords. It will use the userid and password of the person currently logged into the client machine. On the screen where you are attempting to log into SQL Server, does it have an option to use Windows Authentication? What tool are you using to connect to SQL Server? I use SQL Server Management Studio. I'm not sure what you get with the Express Edition.Tara Kizer |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:36:29
|
| Yes thank you, I see what u mean, excuse the silly questions. I will try this. |
|
|
|
umayxa3
Starting Member
4 Posts |
Posted - 2007-03-12 : 15:39:48
|
| Windows Authentication means it uses either a local user account on that computer, or a domain user account for database access. You can also create user accounts inside SQL Server that allow users to connect to the database.If it's your server, sign into that server and go to START/RUN and enter 'sqlwb'. This will open SQL Server Management Studio for you. |
|
|
|
countydown
Starting Member
8 Posts |
Posted - 2007-03-12 : 15:54:55
|
| That has worked. Thanks a million for all your help. |
|
|
|
|
HELP, No admin panel!!!!