Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jgrathwohl
Starting Member
4 Posts |
 Posted - 2014-02-06 : 11:35:12
|
| Hello,I am a noob/novice I really don't know where to start. I have a new Job Being SysAdmin for a small office for a plumbing company and they have a SQL Databse running in SQL 2005, and the workstations have a client program to view/edit the data. However the client app is extremely limited in functionality.They have a drop box in the client app that when clicked it has a few options in it. They need some of those options removed. The only way i can figure to do this is to update the database, but i don't know how to look for where that information is stored, i am not a programmer and my background is break/fix IT consulting so my SQL experience is limited to connectivity issues and backup/restoring databases basically. Any help would be extremely appreciated and i'd even be open to scheduling a remote session with someone if they'd be interested in helping.BONUS ROUND: I have successfully found the version of CRViewer.DLL needed for their client app to DISPLAY the Reports the Client app runs, however when you choose to print, nothing happens at all, nothing even gets spooled or sent anywhere whatsoever. This began when they had their Windows 2k3 Server replaced with the Server 2008R2 I was informed. |
|
|
jgrathwohl
Starting Member
4 Posts |
Posted - 2014-02-06 : 12:04:29
|
| And FYI my job isn't really administering the database. we are contracting a programmer to get us something custom and new. I wouldn't sign up for a job being an SQL admin since i cannot. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-02-06 : 13:30:46
|
| If I understand the need, you have to change what the application displays. If that's true, the application would need to be modified; not the database.===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
|
|
|
jgrathwohl
Starting Member
4 Posts |
Posted - 2014-02-06 : 14:21:57
|
quote:
Originally posted by Bustaz Kool
If I understand the need, you have to change what the application displays. If that's true, the application would need to be modified; not the database.===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961)
Thank you for your reply,Well it looks like you may be correct. I have gone to another work station and his drop box doesn't have the same options. That user let me know that you can input new data, just not remove it, in the field. One of the major problems is they don't have the source code or name of the boxed software that this is from and it is from the year 2002.I'm going to dive into the client app folder and see what can be done. |
|
|
|
jgrathwohl
Starting Member
4 Posts |
Posted - 2014-02-06 : 14:49:31
|
| Looks like i can browse the data in Crystal Reports on the server and i have found the info now i must find out how to change it. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2014-02-09 : 02:31:01
|
| You need to use SSMS (SQL Server Management Studio).Install the SQL Server Client Tools on your machine. |
|
|
|
|
|
|
|
|
A couple things - Removing data from view