Is there any freeware or features in SQL Server or Visio that can reverse engineer a data dictionary from an existing database? I had produce a ER diagram using reverse engineer function in Visio, but I still need to produce a data dictionary ...

I am wanting to put my stored procs in vss. The configuration that I am looking at is Sql Server 2005 Sql Server Management StudioVSSI have not been able to find anything that gets me going, so if someone has a link or some links, please just redirect me and I will continue digging.What I ...

I have a Visual Studio 2005 professional and Sql Server 2005 Express. I download the 'Books on line for Sql Server' but when call help in VB interface or in Management Sql Express the message appear: Integrated help is not available .... This is a bug? Thanks, Marsenne ...

Hi, We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks ...

I've been working with SSIS (RTM version) and I have a problem adding a package configuration of the SQL Server type. Upon completion of all steps in the wizard, the "Target Object" and "Target Property" attributes of this configuration remain empty. Hence, the package ...

Platform: Win Server 2003 Enterprise Edition SSIS Version: 9.00.1187.00 I’ve been working my way through the SSIS tutorials and have noticed a problem when trying to redirect Error Output in lesson 5 “Adding Error Flow Redirection”. Having configured the redirection to the ErrorOutput.txt ...

The main performance issue is performaing the "N" function infront of the strings in the where clause. I get 20x-45x perfromance boost by removing it, but unfortunately my reporting tool doesn't allow me that option. Anything I can do on the DB end to solve this? The DB is not ...

When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error: cannot insert the value null into column "diagram_id" I have searched the web and can't seem to find anything on this. I just simply drag one table from my local db onto the diagram windows ...

Hi, Can you please suggest a good link which describes the sql server2000 features that are not supported by sql server2005 and vice versa. thanks in advance, Nitu

What kind of actions does consume most of the CPU ? joins,triggers,inserts...etc ?where can I find a matrix that shows such as this action consumes this much of CPU ? Tried Procedural without Analysis>>failed!Tried OR/M with Custom Business Objects>> ...

I would like to know what the maximum document size is for full text search in SQL 2005. I found the following in the SQL 2000 Help files, look at the note: Filtering Supported File Types When a cell in an image column contains one of certain types of documents, full-text search uses a filter ...

Is there a way to bound a search that I'm missing? Can't figure out why major types don't appear in the search tab's drop down for content types (e.g "Full Text Search", "Tools and Utilities Reference", SQL Server Programming Reference"). Seems anything appearing in ...

Hi, We would like to deploy SQL 2005 among our organization. We planed to set up 2 servers, one for the datable engine + analysis services + integration services, and another one for reporting services. I already know that we will need two SQL server licenses, one for each server, nevertheless ...

Hi We are upgrading to 2005 version and I am looking to see if SQL Server 2005 version has anything built into it like Red Gates SQL Data Compare Tool. I couldnt find anything thus far that shows 2005 version having anything like this so I thought I would ask to make sure. Thanks so much! Stokh ...

I am at the begin with SQL-server, so for the begin i want to test the value of a datetime field in a table. For example if the content of the field named "danast" is equal with '02.01.1983'. In the documentation witch I've downloaded for SQL-server are explained many things but i ...

Hello, I am jivesh, working on live project with asp.net & sql server2003. I am facing one problem, client is in belgium uses Dutch language, and we are english. when we enter decimal value in sql database it gets save but the client has server in dutch language and in Dutch "." ...

How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it?

Hi, I've installed SQL Server 2005 on Windows Server 2003 SP1 Standard Edition. Before I install SQL Server 2005, I've configured Windows to be an domain controller with Active Directory. As the documentation said that using Object Explorer and then selecting Properties, I have the property ...

How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it?

Hi, I've installed SQL Server 2005 on Windows Server 2003 SP1 Standard Edition. Before I install SQL Server 2005, I've configured Windows to be an domain controller with Active Directory. As the documentation said that using Object Explorer and then selecting Properties, I have the property ...

Hi, i need Info regarding this Can a stored procedure in SQL Server 2005 generate XML data based on the schema, We don't prefer to manually build an xml string inside the stored proc? Is there any SQL Server 2005 feature to do it if possible? Can i find any article on how to do this. Thanks, ...

I have been trying to gather information on the task log and have noted an inconsistency with the naming of an object within BOL 2005. Please have a look at the original post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277667&SiteID=1 ...

Hi all, Im an SQL Server Developer..... Can anyone give me a good link which has the compatibility stuff among SQL Server Versions SAY FOR e.g. like SQL 2000 & Sql 2005...in specific? Thanks in Advance Shaun

Does anyone know the links to doucments showing the SQL 2005 specifications and performance data for the various versions of SQL 2005 including SQL Express?

Hi, I would like to describe what is meant by "read-ahead reads" after having set "set statistics io on;". Do you know where I could find information about it which is valid for SQL Server 2005? In MSDN and Google, I just found information for older versions of SQL Server. ...

Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003. In 'Lesson 1: Defining a Data Source and Dataset for XML Data' ( http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't ...

I hope this is the right forum for this question: Where can I find detail information on the different versions of SQL Server 2005? I need to know what features do each have that others don't. I went for the launch of VS2005 & SQLServer2005 Event and they had interesting information on ...

I've been working throught the SSIS tutorial but have a problem with the package configuration lesson. After exporting the required object to the file the completion step shows:Name: Configuration 1 Type: Configuration File New configuration file will be created. File name: C:\Documents and ...

Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough ...

Is there an easy method to export a topic out of BOL? For example ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm I'd like to export this to MS Word, I need to send this information to a large distrubtion list for review and I'm find it rather ...

I'm new to the architect world and I'm trying to solve a performance problem with a SQL Server cluster. But, in talking to some folks they were recommending that I write a design based on a SQL Server "farm". However, when I ask them for more information about what a ...

Hi, We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks ...

Hello, I've recently taken a new database reporting job. One of my first tasks at hand is to write documentation of existing stored procs, functions, views, etc... They would like to have printed Word documents listing the server location, database names, and other specifics of the existing ...

Hi all, I am new to SQL server. I just installed SQL Server express and Visual Web Developer Express edition. I have experience in SQL but I need some tutorial about how to use SQL Server and create tables and make queries. I can't find any exact location in Microsoft website about SQL Server ...

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access ...

I am looking for the northwind install script in my SQL server 2005 directory and cannot find it. The introduction to VB 2005 uses it for an example and I would like to walk thru it. Does anyone have the sql? If so could you send it to me. I am going to see if I can get it off a 2000 install. ...

Hello! I need to make a query that returns the names of the collumns. Could you help me? Thank's Ronaldo

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this ...

Hi all,I am new to SQL server. I just installed SQL Server express and Visual Web Developer Express edition.I have experience in SQL but I need some tutorial about how to use SQL Server and create tables and make queries. I can't find any exact location in Microsoft website about SQL Server ...

<span class=txt5><font size=3>Please look for the post in the SQL Server Integrated Services forum.</font></span>

I've been working throught the SSIS tutorial but have a problem with the package configuration lesson. After exporting the required object to the file the completion step shows:Name: Configuration 1 Type: Configuration File New configuration file will be created. File name: C:\Documents and ...

Hi,We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks ...

Hye guys, I want 2 export the field names and their properties of my tables to a file by which I would be able 2 print it , Study it and share it with my other friends... for discussions...Which tool can be used 2 export the table stture in a printable ...

Due to reports that some people were getting an older version of the SQL Server 2005 Books Online download, we have republished the download with a new file name.The previous file name was "SqlServer2K5_BOL.msi" and the new one is "SqlServer2K5_BOL_Dec2005.msi". Nothing is ...

Any online vedio training for SQL Server 2005/2005 Express available? It's just a faster way to learn new features. Thanks

In July I obtained and installed the dvd's SQLServer 2005 Developer Edition CTP so I assume this is the June 2005 version and VS2005 Team Suite Beta 2.I tried downloading the above file for Sql server 2005 Books online and it fails saying I need .Net 2.0 ( seems VS2005 installed .Net 2.0 Beta ...

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this ...

Hi all, Im trying to find a list of the different datatypes used when importing a text file,Such as float [DT_R4], Currency [DT_CY], four-byte signed integer [DT_14] etc etc I would like to use the list to accurately match up datatypes on paper before I build a package so I can also double ...

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this ...

<FONT size=2>I can't seem to find any documentation for XCOPY. If someone could point me to any documentation that would explain it's syntax and how to use it, I would be grateful.</FONT></P> <FONT size=2>Thanks,</FONT></P> <FONT size=2>jerryk</FONT></P> </P>