Tools For MSQL
Nov 16, 2006
Hi,
1. I am wondering if exist a tool to let me easily document my databases, unde MSQL.
e.g.I want to create a doc file or better a html file with all my databases objects, descriptions, DDLs etc...
2. Another tool to create code patterns; I need a something that generate custom code patterns, but in VBScript or C#.
p.s. Sorry if i created this topic on another forum.
Thanks,
<u><b>Jack Bower</b></u>
software developer
IATAR Studio
http://iatar.port5.com
View 13 Replies
ADVERTISEMENT
May 11, 2004
Hi
Can anyone help me with the MSSQL following problem:
I want to update the field "Date" with today´s date in a Tabel named Customers
I want to click on a "button" that runs something like:
Update Date with Today´s date where CustomerName = TextBox.text
Thanks in advance for your help
View 1 Replies
View Related
Jul 26, 2004
Greetings everyone.
A couple days ago, i posted a question on the Access boards.Here (http://forums.databasejournal.com/showthread.php?s=&threadid=36511)
Long story short, instead of filtering the results Locally, returned by query run locally on linked tables in an access front end, seems we should filter remotly. Seems easier and more secure.
We still want to hand out MS Access front ends. The results of queries run by users must be filtered based on authetication and values in the tables they query. There would be two ways to accomplish this.
1 - Stored procedures, apprearing as queries in Access.
2 - Views, appearing as tables.
Stored procedures are sure to work, but somewhat a hassle, sine we have to write code for each.
Views seem to be the simplest approach. we only need to build an SQL statement representing the new table. yet again, we have not done any constructive filtering. Is there a way to pass arguments to views just like stored procedures?
An exemple could be :
SELECT field1, field2, field3 FROM edu_details WHERE ID_department = @usr_dept AND ID_Division = $usr_div
usr_dept and usr_div being fields in the queried table(or course) AND auth information.
Cheers,
Lawrence
View 1 Replies
View Related
Dec 17, 2007
Hello friends,
i am newly installed my client server from there i suppose to access the application.... when i clicked on the application icon it showing he following message:
Please note down the Error and Call EDP!!!!
Error number->[-2147467259]
Error Text->[[DBNETLIB][ConnectionOpen(Connect()),]SQL Server does not exit or access denied,]
am getting the above error..... can any one through your view plz.........
ENV: windows 2003 small business server, MSSQL (server)
windowsXP (client)
its working fine with all other client mechines.........
View 1 Replies
View Related
Jun 4, 2007
Hi All
My SQL is extremly rusted so I need some help with a very basic function. I have a character field which is built up using a category code + '-' + number. The problem I have is that the category codes are all different lengths and the items were added using 9 instead of 09. I'm trying to clean up the data so that the same item with e.g. category code DZ20 cannot be added as DZ20-1 and DZ20-01. How do I find the position of the '-' in the Query Analyser for MSSQL 2000?
View 1 Replies
View Related
Jul 20, 2005
Hi All,I want to use MS sql server edition 2000. I have installed the server. Now iwant to create the database on this server with tables and triggers. Canplease someone suggest me how to do this ?Thanks a lot,Dinesh
View 1 Replies
View Related
Aug 10, 2005
hello all during the instaletion i get an error message that SQL server can not start the service, after that the programm rolls instalation back.do someone knows what's going on?i use win xp pro.thank u for ur help.
View 2 Replies
View Related
Mar 25, 2014
Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies
View Related
Oct 20, 2014
The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068052700
Exit facility code: 1212
Exit error code: 1316
[code]...
View 10 Replies
View Related
Jun 1, 2007
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?
View 3 Replies
View Related
Sep 20, 2007
Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
View 2 Replies
View Related
Apr 24, 2014
Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.
Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?
Where would I find the version "bytes" in a BAK file?
View 4 Replies
View Related
Jun 16, 2008
Dear All,
how can we know that wether we had server tools or client tools on my machine?
Arnav
Even you learn 1%, Learn it with 100% confidence.
View 1 Replies
View Related
May 16, 2002
Know any good performance monitoring and analysis tools for SQL server.
View 1 Replies
View Related
Oct 14, 2007
Is there a tools simular to php admin. for MS SQL? If not how can you view the data without writing a query? ThanksDee
View 6 Replies
View Related
Sep 28, 2000
Hi,
Is there a way to determine whether sql tool are installed on a client machine. DTS wouldn't run without sql tools.
Is there a workaround?
TIA
Barath
View 1 Replies
View Related
Apr 30, 2002
Is anyone aware of a tool, utility or Stored Procedure that would allow you to compare stored procedures on diferent servers and to copy stored procedures from one server to another (eg. test to prod).
Thanks,
Ken Nicholson
View 2 Replies
View Related
Apr 9, 2004
Can anyone recommend any tools or bundles that are out there for MSSQL databases used for comparing and syncronizing stucture, data, stored procs, etc.
I'd like to hear about any and all.
View 4 Replies
View Related
Jun 19, 2008
Hi guys,
for one of our forthcoming sql project.
I need your inputs/recommedations on the tools and techniques widely used in SQL SERVER based on the following parameters
Design efficient schemas
optimizing queries, stored procedures
fine - tuning indexes
Performing efficient transactions
analyze and understand execution plans
Scalability pitfalls
Test and monitor data access performance
Generate historical and reporting data
Processor,memory and performance related bottlenecks
DISK I/O related bottlenecks.
SQL IN Minds
View 4 Replies
View Related
May 30, 2007
Hello,
what tools do you usually use for DBA job, like performance monitoring and performance tuning etc?
Thanks
View 1 Replies
View Related
Apr 20, 2005
I planning some web app that I would like to use MSDE to power. I admit I am intimidated by the thought of creating databases with no GUI. So my question is can I use SQL server 2000 tools with MSDE or can I create databases with SQL server 2000 then deploy them to a machine running MSDE?
Thanks
View 2 Replies
View Related
May 30, 2002
Does anyone know of any good debugging tools for transact sql? I know there is one by compuware called dbpartner but was looking for other options.
Thanks,
Eddie
View 1 Replies
View Related
May 27, 2001
Hi
Can anyone suggest me a good case tools that works fine with SQL Server. We have old version of ERwin and we like to upgrade. The decision is whether to upgrade ERwin or go for any other tools better than ERWin.
Thanks in Advance.
Jaya
View 1 Replies
View Related
Sep 22, 2001
What's my question is ? Whether there are any tools available for normalization produced by Database vendors or any third party. If yes, Can u kindly give me clear documentation.
Thanks,
venkat.
venkat_26178@yahoo.com
View 2 Replies
View Related
Sep 22, 2001
whether there are any tools for Normalization? If yes, Can u please send some documentation or some reference where I can get them.
-venkat
venkat_26178@yahoo.com
View 1 Replies
View Related
Jul 5, 2000
I need to be able to administer SQL 6.5 and 7.0 servers from a single pc.
I have been told that I can't have SQL 6.5 and 7.0 tools installed on the same pc.
Is this correct? I can't find anything in BOL or Technet on the subject.
Regards,
Kevin Napier
View 1 Replies
View Related
Jul 5, 2000
Hi Guys
I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message:
The SQLOLE OLE object could not be registered. Class not registered (80040154)
After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled.
Still no luck.
Any ideas?
Many thanks
Stuza
View 2 Replies
View Related
Oct 26, 2000
can anyone tell me where can download stress testing tool for SQL Server 7.0.
Thank You,
Piyush Patel
View 1 Replies
View Related
Jun 15, 2000
Hi,
What are the best tools for web reporting that can extract data from sql
server and also draw graphs.
thanks
View 3 Replies
View Related
Jun 5, 2002
We are evaluating a tool by Lechotech that can optimize sql statements. It is a pretty good tool, but we would like to compare it against some others. Has anyone seen any other such tools?
View 1 Replies
View Related
May 2, 2001
Hello,
I'm kind of new to SQL Server 2000, I've heard about debugging tools in Query Analyser
where can I find this tools?
Thanks
View 2 Replies
View Related
May 24, 2001
What if any are the implications of using the SQL 2K Client tools to access and administer SQL 7 dbs???
View 2 Replies
View Related
Sep 20, 2004
wondering what software tools people in the industry use for development of SQL projects.
I use SQL Enterprise Manager to manage the server then a mixture of SQL Query Analyser and MS Access to develop queries for our ASP/WEB projects (using access as an instant graphical front-end to the data).
Used to use a third-party tool to develop the sql code but not anymore as it was just a pain to get done, was called RapidSQL.
look forward to people's replies on this one, any input much appreciated,
View 4 Replies
View Related
