MS SQL Utilities For Documentation

Oct 16, 1998

I am looking for good utilities that document MS SQL table schema, indexes, layouts etc. I am currently looking at SQL auditor, but this product does not give me table schema or any kind of device revisions. I recently was given several SQL servers that have not been documented in any way.

thanks

ps SQL auditor gets a B+ in my book. Let me know what you think

View 2 Replies


ADVERTISEMENT

16 Bit-client Utilities

Mar 30, 2000

Hi all,

I am going to upgrade a SQL server 6.5 box to SQL7.0. The 16 bit-client utilities are a prerequisite because there is a 16-bit application and requires some of the database libraries. My question is how does SQL7.0 deal with 16-bit application? In my case, could I upgrade the SQL6.5 box to SQL7.0?

I appreciate any input and help ahead,

Stella Liu

View 1 Replies View Related

Palm Utilities For DBA

Feb 23, 2001

Does anyone have any palm utilities, or reference docs, urls - I am administering SQL7 and would like info on Palm-3, using as a references. I have ModileDB installed, with Oracle Recovery references, but could not find SQL.

thanks,
Jason

View 3 Replies View Related

Sql Server Utilities

Apr 16, 2002

HI

Would like to know whether SQL server has the utilities do the following and the command to activiate the followings:
- limit the no. of login (ie to set the number of failed_login_attempts)
- password_reuse_max (eg password A can only be reuse 3 times)

tia
MK

View 1 Replies View Related

Client Utilities For MSDE

Mar 23, 2005

Hi,

I heard from a guy that the client utilities (Enterprice Manager and Query Analyser) that are on the Sql Server 2000 CD can be fetched separatly from Microsoft and that they can be deployed with MSDE to a potential customer.

Is that correct?

And if it is, where can I obtain those client apps?

TIA

Ohlywohly

View 2 Replies View Related

SQL Server Network Utilities

Jan 13, 2006

Hi everyone,
Can anyone tell me the basic difference between Client Network Utility and Server Network Utility and also when to use what..?????

View 1 Replies View Related

Removing SQL Utilities Off Server

Aug 27, 1998

Does anyone know how to remove SQL utilities off the server manually.
When I run the setup.exe from the SQL CD to remove SQL from server that option button is
shaded, I try reinstalling SQL utilities and then I try removing and still it won`t let me?
Help!!!

View 2 Replies View Related

DTS Version Control Utilities?

Jun 15, 2001

We are looking for utilities to help us manage DTS packages. Specifically to help us track changes in the packages in a fairly fine-grained fashion; several layers deeper than the version listing under package info, for example. Think of it as an object-oriented diff utility if you will, something that can report on changes in a package very specifically; for example, we need to know that step 4 of a package is a SQL widget and the text has changed between versions, and what the changes are. Converting the package to a VB project & versioning the source text doesn't work, for several reasons too complicated to state here.

Is there aything like this available? We would rather buy than build, but I haven't seen anything like this yet. If anyone has experience with such a utility I would appreciate knowing about this. Thanks.

Jim Rivera
Software Engineer
Grange Insurance Graoup
Seattle, WA

View 1 Replies View Related

Third Party Reindexing Utilities

Jul 23, 2005

Folks,I work on a system which is growing rapidly, with the number oftransactions we process growing on a daily basis. While this is goodnews or the business, maintenance is starting to become an issue as thedatabase is the backend for a website which cannot be down for alengthy period of time.While I do defrag the indexes, periodically the indexes do need to berebuilt. When this happens, the process locks pages and transactionsstart getting bounced out.Are their any third party utilities which will rebuild an indexwithout this locking occuring? Any help in pointing me in the rightdirection would be appreciated.

View 1 Replies View Related

Loadbalancing Utilities - For Clustered SQL 2000

Feb 20, 2001

Hi all ,

I would like to know about third party tools available or sites where I can get some evaluations on this tools to load balance our Clustered SQL 2000 on Windows 2000. Thanks for the help In Advance.

Shaji

View 2 Replies View Related

Installing SQL 6.5 And 2000 Client Utilities On The Same Machine

Aug 24, 2004

Can I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?

Please, provide me with any information or links in this matter.

View 5 Replies View Related

Utilities To Check For Errors In Stored Procedures

Jul 20, 2005

I have written a utility that checks our stored procedures forpotentially incorrect code (eg = null as opposed to is null, unusedvariables/parameters etc). It also ensures that parameters/variablesetc match our naming conventions and data types/sizes are the sames asthe corresponding type in the database (if appropriate)Are there any other utilities that do this sort of thing?

View 1 Replies View Related

Utilities For Comparing Stored Procedure Results?

Dec 11, 2007

I have large stored procedures in SQL Server 2005 that often get updated. Sometimes it is very difficult to recognize how one change could impact the overall results. I would like to have some sample input that I could test during changes and see it compare the data results before & after my changes. This would help me quickly identify if the results are fine to pass through.

So basically I would like an easy way to compare the results of 2 stored procedures. Any suggestions or utilites that would help me do this?

View 3 Replies View Related

CLR Programming: Best Place To Define Utilities Functions

Apr 27, 2007

Hallo,

I find the CLR integration very handy and I would like to use it in the proper way but I need some helps because is not easy to find "best practice" programming info.

This is what I have to do: from a "period" coming from the DB I have to compute start/End date and save them in the DB.

The computation involves regular expression and several functions that makes several calculations on date type variable.

I have created my UserDefinedFunction class that contains the TV function to return a row with 2 fields (startdate,enddate).
Now my question is: what is the base place to define my utilities functions that perform the computation?
In the same class or it is better to add a new class?

For example I have created a module that contains all the Regular expressions patterns.

Any help is appreciated!

Thankx

Marina B.



View 1 Replies View Related

Compare Utilities For Comparing Stored Procedure Results?

Dec 10, 2007

I have large stored procedures in SQL Server 2005 that often get updated. Sometimes it is very difficult to recognize how one change could impact the overall results. I would like to have some sample input that I could test during changes and see it compare the data results before & after my changes. This would help me quickly identify if the results are fine to pass through.

So basically I would like an easy way to compare the results of 2 stored procedures. Any suggestions or utilites that would help me do this?

View 6 Replies View Related

Failed To Load Expression Host Assembly. Details: The Type Initializer For 'CableReporting.Utilities' Threw An Exception

Sep 18, 2007

Hi

I am using sql reporting service 2005 with .NET 2.0.
I have created a custom dll file for report and put this dll in appropriate folder.
Report is running fine in designer project.
but when I am trying to view this report after uploading to report manager it give me an error like


Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception. (rsErrorLoadingExprHostAssembly)Is there any solution for that?

thanks and Regards

Apurv Shah
IBM India pvt Ltd

View 3 Replies View Related

Documentation

Jul 28, 2004

What information should I be documenting about a server (SQL) and about the databases found on that server. I was task with this job. Please help.

Thanks

Lystra

View 2 Replies View Related

Documentation

Nov 13, 2004

I'd like to go through and document the databases I'm responsible for...it's probably a good practice and I'm sure there a several approaches to doing so.

Anybody have comments, recommendations, or possibly a nice word template that links everything up?

Thanks for the input.

Alex

View 1 Replies View Related

Documentation

Mar 9, 2004

hello everyone,
I have to document about four databases, has anyone got any specific format or tool for documenting a database?
Any inputs would be very helpful
regards,
Harshal.

View 13 Replies View Related

Xml Documentation

Jul 26, 2007

Will there ever be xml code documentation support inside of Sql Server projects?

View 1 Replies View Related

Where Is SQLDMO Documentation?

May 5, 2008

Hi all
Could anyone tell me from where i can find complete Documentation for SQLDMO Object and how can i initialize
and use it in my programms?

Kind Regards.

View 1 Replies View Related

Sql Documentation Tool

Dec 3, 2005

Does anyone knows a good FREE tool for documenting a DB?

so far i'm with ApexSQL but its not free, wondering if anyone knows a free tool.

Thanks,

View 1 Replies View Related

SQL Database Documentation

Nov 9, 2004

Hi guys,
Can any one tell me about any Database Documentation Tool for SQL server.
Please reply asap.

Junaid

View 5 Replies View Related

Documentation For Queries

Sep 20, 2005

Hallo !

Right now I am looking for the query-code to delete a table (not only the rows, but all of it). Somebody could give me the code?

In general I am always looking for a place on the web, where all sql-server 2005 (express) query-functions are explained. Somebody knows the right place?

Thank you very much!

Regards,
Fabain

View 6 Replies View Related

Best Documentation Tool?

Jun 13, 2007

Can anyone advise me on what they regard as the best SQL Server documentation tool. I am currently looking at Redgate and ApexSQL products. Do any of you have experience with these or others? I need one that will document 2000 and 2005 databases.

Thanks.

View 15 Replies View Related

Trigger Documentation

Jun 28, 2007

I am documenting a database.

When I view dependencies on a table I can see a view- so I go to views and copy the information.
But when there is a trigger as a dependency- I cannot find where to go to view it.

Are triggers within stored procedures somewhere? Or do they have their own separate place somewhere?

As you can see- I don’t know much about SQL…

Thanks

View 3 Replies View Related

But The Documentation Is NOT Correct

Jul 23, 2005

The documentation saysISNUMERIC returns 1 when the input expression evaluates to a validinteger, floating point number, money or decimal type; otherwise itreturns 0. A return value of 1 guarantees that expression can beconverted to one of these numeric types.(Cut and pasted from books online)Yet the following, one of many, example shows this is not true.select isnumeric(char(9))select convert(int, char(9))-----------1(1 row(s) affected)Server: Msg 245, Level 16, State 1, Line 2Syntax error converting the varchar value '' to a column of data typeint.So, besides filtering every possible invalid character, how do youconvert dirty values without error. I am not concerned that I may loosepossibly valid values or convert suspect strings to 0 (zero). I justwant to run without raising an error

View 3 Replies View Related

Documentation To Get Started

Jul 20, 2005

What is the best online documentation either on the Web or installedwithSQL Server that I could use to get started? I want to jump in andstartcreating tables, etc for applications.Also, what is the most recommended text for converting my DBAexperience from other database to SQL Server.ThanksBill.

View 3 Replies View Related

SSIS Documentation

Apr 17, 2007

Hi folks

According to the book I am reading at the moment, there's supposed to be an SSIS documentation that ships with the product. I had the software installed by the IT guys but nothing with it apart from the books on line.

Does any one know of specific documentation on this?



Regards

Baldev

View 3 Replies View Related

C2 Auditing Documentation

Sep 20, 2007

Hi everyone,

I am to try to find documentation about C2 auditing into SQL Server 2005. The only one doc I fand about it is:
SQL 2000 C2 Admin and User Guide
It cover SQL Server 2000 and Windows NT4.0.

I do not find any document who cover the security from SQL Server 2005.

Can you help me please?

Thx.

Laurent

View 1 Replies View Related

Documentation Tools For SSB?

Oct 27, 2006

Does anyone know if there are automated documentation tools around that will produce docs for Service Broker objects?

Thanks,

AndrewM

View 1 Replies View Related

Need ActiveX Documentation, Please

Oct 11, 2007

Hi,

Is there a source I can go to for ActiveX documentation? I just need to be able to translate some things.

For example:
On Error Resume Next


What does this do within the ActiveX script?

Thanks

View 5 Replies View Related

Mapping Documentation

Mar 21, 2007

I need to generate a document with the fields mapping from a DataFlow Task. Anybody knows how to do this?

Know I'm using screenshots from the destination object mapping.

Thanks

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved