Template For SQL Server 7 Configuration Documentation
Sep 26, 2001Does anyone have a template for storing all SQL Server 7 information.
Database, filegroup, drive, ...etc. Any help appreciated
Paul.
ADVERTISEMENT
Integration Services :: SSIS Standards And Documentation Template
Oct 21, 2015I am sure this questions have been asked  but i was not able to find a useful information.Â
1. I am looking for a SSIS Standards document or source. A document developer can use for developing ssis package. This should include how to name each container, task , and how to organize things. Basics of SSIS. Is there some kind of source where i can find this information . We are starting out to migrate from informatica to SSIS but before we do that we would like to put standards in place so all SSIS development is consistent.
2. SSIS project documentation template that we can use to document each project. Â Is there anything out there that we can follow to document each of our project.Â
SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )
Sep 22, 2007I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
SQL Configuration Manager And SQL Server Surface Area Configuration Tools
May 2, 2007I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
===================================
Documentation Of The Tables In SQL Server
Jul 17, 2007Hi all
I have 15 tables in my database and I want to create a pdf file with description about all the columns of these tables(Data Model)
Few questions
How can I get all the column names in the excel or pdf file?
Is there any tool which can give me the output template for these columns and then I just have to fill the description for each column?
Thanks
SQL Server 2008 Documentation
Jun 15, 2007Hi,
Can you please tell me links to SQL Server 2008 documentation on MSDN? I read SQL Server 2008 CTP is released today. I'm very much interested to know more about it. Thanks in advance.
Cheers,
Gopi
mgopinath.blogspot.com
Where Is Server Template
Jul 27, 2015I have Visual Studio 2012 (Ultimate) installed (Update 4) with SSDT (version 11.1.50512.0), Â I can see the template SQL Server Database Project, but where is the server-level project, SQL Server Project?
Previously, in Visual Studio 2008, I had a Category Database Projects with subcategories for SQL Server CLR, SQL Server 2000, SQL Server 2005 and SQL Server 2008. Â Each of those had a SQL Server 200x Server Project template.These seem to be missing in Visual Studio 2012.
SQL Server Documentation/2000 Vs 2005
Sep 19, 2006Two questions for you all...
1. Has anyone found a good software that does database documentation that is fairly priced and pretty much fully automatic. Something to document tables,views,stored procedures and so on...
2. Have any of you found a paper or better yet a chart that shows what is new to sql server 2005 that wasn't in 2000 and also more importantly what was available in 2000 that will not be supported in 2005?
Thanks
Report Server Database Documentation
May 8, 2007Hail to all the serious Report Server users. Let us all start the documentation effort on Report Server Database (Reporting Services 2005). This will let us work around many problems that occur due to lask of documentation of the RS DB Schema.
Example :
Subscriptions table in the report server database can be used for handling the subscriptions manually. A DML statement coupled with the same on the sysjobs in msdb database can stop corrupt subscriptions (which cannot be modified directly using User Interfaces)
Current Problem
The problem that I am facing is related to the size of the Report Server (it is above 35 GBs, with 422 users) while its counter part with 128 users is only 4 GBs. This is due to a table ServerParametersInstance which is growing in an out-of-bound fashion. The lack of documentation is hurting.
So let us put in some effort & document the RS Database for good.
Any help is greatly appreciated...
Labyrinth
SQL Server 2008 :: Shortcut Key For Template?
Sep 30, 2015I created a template that I use all the time. Normally I just drag-n-drop from the Template Explorer menu, however I'm wondering if I can assign a shortcut key to have it open? I see you can assign stored procedures and other items, but I can't find where/if I can do this for a template.
View 2 Replies View RelatedWhere Is Report Server Project Template?
Feb 27, 2007From file, new, project, I did not see Project types.
Where is Report server project template?
How to make it appear?
Any Documentation On SQL Server State Icons Shown In MMC Console?
Feb 8, 2000Does anyone know of any place I can find documentation on the meanings of the SQL Server state icons displayed in the MMC console for SQL Server 7.0? My server is showing the green running icon but also a vertical red squiggly line. I do not know what this red squiggly line means, and it concerns me. The databases all seem fine, and everything seems to be working, i just have this feeling like something bad is impending and I cannot find anything that tells me what it might be. Any help or suggestions would be greatly appreciated.
View 2 Replies View RelatedClubSite Template + Sql Server 2005 Not Cooperating...
Jun 2, 2007I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.
I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.
I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)
while trying to run aspnet_regsql.exe I get the following error
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper
Start adding the following features:MembershipProfileRoleManagerPersonalizationSqlWebEventProvider
......................An error has occurred. Details of the exception:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: NamedPipes Provider, error: 40 - Could not open a connection to SQL Server)
Unable to connect to SQL Server database.
I have tried several different things (shooting in the dark) to resolve this issue, including:
verifing that port 445 is avaliable on the firewall per these directions: http://support.microsoft.com/default.aspx?scid=kb;en-us;839269
configured SQL server 2005 to allow remote connections following these directions: http://support.microsoft.com/kb/914277
with no change in results.
Anything else I should look into?
Thanks in advance,
Mike
Custom Report Server Project Template
Dec 8, 2007Hi,
is it possible to create a report server project template ? This project must have 2 datasources and 1 specific report
I wanted to use the Export Template, but it isn't available. I can only use it in Developpement Studio not in BIDS.
Thanks to help me
Cédric
SQL SERVER Project Template Not Found For UDTcreation
Mar 20, 2006Hi,
I have SQL2K5 standard edition and I planned to use the CLR-UDT feature of SQL 2K5. Unfortunately, after following these links:
http://www.pcquest.com/content/enterprise/2005/105041103.asp
http://msdn2.microsoft.com/en-us/library/a8s4s5dz(VS.80).aspx
I found that there is no SQL SERVER project template in my installation of Visual Studio 2005(which came with the SQL2K5 CD). How can I get this particular template? Is there a work around?
I need to create the UDTs on SQL SERVER 2005.
Thanks
SQL 2000 Server, Need Help Creating Documentation/disaster Recovery Plan...
Sep 27, 2006I currently work for a company that has had a "family business" mentality for many years. The only trouble is, it has grown into a fairly large company over the years and that mentality just doesn't cut it anymore (We have around 200 employees in 2 offices, and 25-50 remote users).
I have recently taken over the role of System Administrator, and I'm having a lot of trouble trying to get everything under wraps. There are a LOT of un-documented things happening with our database/web server, and in order to keep things safe & secure, I need to try & flesh out what those mystery settings would be. I feel that NOW is the time to get some solid documentation down, to protect my ass before some critical failure happens.
I'm wading into unknown waters here, and I'm hoping that somebody who's "been there" might have some tips to make my life a little easier.
I have an IBM Bladecenter, and a spare blade with which I can use to re-produce as close to a mirror copy of our system as possible. I have installed windows 2003 /w SQL2000 and restored a full backup of our databases and imported all database user accounts, and logins. What about Maintenance Jobs? Error Logs? Patches/Hotfixes? Service accounts? Membership roles? System databases? ODBC Sources? Services? Startup Scripts? I'm sure the list could go on & on... What are some of the crucial details I should look into?
Has anybody been in this boat before having little knowledge of what was built before you arrived, and have any insight on how to get through this without too much headache?
Package Configuration Wizard:-SQL Configurations Configuration Filter Not Working
May 23, 2006Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do
thanks in advance Dave
Background:
SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go
http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx
Wizard results:
Name:
ETL
Type:
SQL Server
Connection name:
ETLConfiguration
Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.
Configuration table name:
[dbo].[SSIS Configurations]
Configuration filter:
PT_CUST_ABR
Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]
USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
Configuration Manager - Which Configuration Type To Chose ?
Jan 14, 2006It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.
Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.
It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)
Let's have some comments
Documentation
Jul 28, 2004What 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
Documentation
Nov 13, 2004I'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
Documentation
Mar 9, 2004hello 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.
Xml Documentation
Jul 26, 2007Will there ever be xml code documentation support inside of Sql Server projects?
View 1 Replies View RelatedWhere Is SQLDMO Documentation?
May 5, 2008Hi 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.
Sql Documentation Tool
Dec 3, 2005Does 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,
SQL Database Documentation
Nov 9, 2004Hi guys,
Can any one tell me about any Database Documentation Tool for SQL server.
Please reply asap.
Junaid
MS SQL Utilities For Documentation
Oct 16, 1998I 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
Documentation For Queries
Sep 20, 2005Hallo !
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
Best Documentation Tool?
Jun 13, 2007Can 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.
Trigger Documentation
Jun 28, 2007I 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
But The Documentation Is NOT Correct
Jul 23, 2005The 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 RelatedDocumentation To Get Started
Jul 20, 2005What 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 RelatedSSIS Documentation
Apr 17, 2007Hi 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
C2 Auditing Documentation
Sep 20, 2007Hi 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