Answer Questions

• _hunter Other Generate Script problems in SQL Server Management Studio

  Why have often used scripting settings been removed from SQL Server 2005: Issues associated with Scripting options: Query Analyzer allowed the following generic options that have been removed from SSMS: Identifier Delimiter : None, Version dependent, [] or "" Do not script the collation. Generate Transact-SQL to remove referenced component. Script tests for existence prior to attempt to remove component. Do not include 'ON <filegroup>' clause directing filegroup use. and table Scripting Options: Qualify object name by its owner. Do not include definition of identity property, seed, and increment. Generate SET ANSI_PADDING ON and SET ANSI_PADDING OFF statements before CREATE TABLE statements. Also Enterprise Manager ...Show All

• johngccfc Database Restore, Error 3154 and

  Hi all, I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance. I have tried giving the new database the same name as the original and a different name to the original database (Below is the scripted T-SQL that I get from the DB Admin tool RESTORE DATABASE [Fers_Production] FILE = N 'FERS_Production_dat' , FILE = N 'FERS_Production_log' FROM DISK = N 'D:\Microsoft SQL Server (2000)\MSSQL\Backup\Fers_Production\Fers_Production_db_200607270206.BAK' WITH FILE = 1 , NOUNLOAD , REPLACE , STATS = 10 GO When I ru ...Show All

• Stephan Zahariev MS Office Integration & SSIS

  Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq Re: How about using a report tool, such as Reporting Services, it came free in the box too! Can reporting tool be used to run the report in batch mode instead of interactive How about using a report tool, such as Reporting Services, it came free in the box too! shafiqm wrote: Thanks Jamie. Do you have any sample code No. Sorry. Thanks Jamie. Do you have any sample code shafiqm wrote: Using SSIS, every month/week I have to ...Show All

• KeithGWilliams Rows in Pages

  Hi everyone, I have a simple question about Rows in Pages for you. In my opinion, rows are the storage of the data in databases. I would like to ask that there are any important properties of Rows which I am not aware. Thanks Pages and Extents The fundamental unit of data storage in MicrosoftR SQL Server is the page . In SQL Server 2000, the page size is 8 KB. This means SQL Server 2000 databases have 128 pages per megabyte. The start of each page is a 96-byte header used to store system information, such as the type of page, the amount of free space on the page, and the object ID of the object owning the page. The table shows eight types of pages in the data files of a SQL Server 2000 database. Page type ...Show All

• Lawrence 007 Problems While Excecuting a DTS

  Hello guys, I have an application developed in ASP.NET, C# and SQL Server 2000 database. I've developed a subroutine that executes a DTS on the SQL Server 2000 database, this DTS reads the data contained into an .xls file, the DTS process this data and then writes it into SQL Server tables. The admin user can select the .xls file he/she wants to be processed by the DTS. The .xls file is copied from his/her machine to a directory on the webserver and then the new path is passed to the DTS connection for the .xls file. For example, the admin user has the .xls file on "c:\", so he/she selects it from the application. Once the admin user has selected the file, the application copies it to the application path on the web s ...Show All

• Benorama clustered index fragmentation

  Hi I am testing some clustered index on a table I was working on. I put a clustered index on an int column with identity and insert some several thousand records into the table. I check the index fragmentation and notice that it was about 20%. I thought since the identity field is incremental, there would be little or no fragmentation. Is this true or is there something wrong with my server thanks Paul A clustered index is a table (heap), indexed. See: Microsoft SQL Server 2000 Index Defragmentation Best Practices http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx#EJD When you created the index what fill factor did you use Did you select the padding option ...Show All

• CompanyProfile Access to TaskHost from derived Task class.

  Hi, for some reasons, I have to get access to the TaskHost during validation and execution. For example, I wanna know, if my task is within a container or not (parent is Sequence). For the UI during design time, there is the TaskHost parameter. What about the execution time or during validation Any hints Thanks. Thorsten If you look at the two objects and what they inherit or implement, you can see that will never happen. You can get the Task from a TaskHost using the TaskHost.InnerObject property but not the other way. The TaskHost is what deals in the world of containers, the task is the guts that sits below all that to do the actual work. Your task will always be in a container, a ...Show All

• bkana .mdf files

  What are .mdf files and how do I use or open them I have two .mdf files, but have no idea how to open them. I don't have an .ldf file and want to access the .mdf file. How do I attach it to the database I don't have SQL Server. What should I do SQL Server creates an .mdf and an .ldf file for the database and the associated log. If you have both of them, you can attach them to your server. For more info, open up Books Online and read about attaching a database. Thanks, Sam Lester (MSFT) In addition, if you don’t have any ldf file you can try to let SQL Server create a new one for you during attaching the file with sp_attach_single_file_db. If SQL Serve dcan r ...Show All

• Leon Langleyben Subscription Error: "The e-mail address of one or more recipients is not valid."

  I have subscriptions that fail because someone's email is no longer valid, where is this error information stored so I can fix the problem I have a large list and it is hard to do manually. I will be using data driven solutions, but these are existing subscriptions that need to be ran. P Joshi, Did you ever find a work-around I am experiencing the exact symptoms as you. Only my company's domain is permitted ... all others raise this error. My problem is that my company has several subsidiaries with different domain names. Bobby i changed the permittedHosts in rsreportserver.comfig to <PermittedHosts> <HostName>xxx.be</HostName> <HostName>hotmail.com</Hos ...Show All

• NoEgo Using variable in DataReader's SqlCommand text

  I'm attempting to configure a DataReader's SqlCommand text to use a package-level variable and I'm having trouble. I've read about using the "sql command from variable" option but although I see that during the configuration of Ole DB source, I don't see the same option for DataReader source. Viewing the properties of the DataReader and selecting the SqlCommand property does have button to configure the value but only displays a string value editor window. (I was hoping for the expression editor.) The configured connection to the DataReader uses the odbc Data Provider (under .Net providers). I'm connecting to mySql, if that matters. What I'm looking to do is to use a variable in the where clause of the DataReader's SqlComma ...Show All

• jmarkmcdow SQL 2005 Merge Replication using a dynamic filter which is not suser_sname() or host_name()

  Hi ... I am working on a project where the server version of application has vouchers from different entities. I have created a publication manually. My next step was to create a client subscription using rmo and to execute a pull. This part works fine. Code samples from http://msdn2.microsoft.com/en-us/library/ms147314.aspx My next step would be to implement dynamic filtering using the guid of the entity as a parameter. I dont want to use suser_sname() or host_name() as I want to use a fixed login for the replication for all users, and a client could have several host dbs (sql express, sql mobile) My goal would be to pass a guid-value to the HostName Property of the MergePullSubscription class and convert it to an uniquiden ...Show All

• iljanated Confusion over @@ROWCOUNT test

  I have a pair of services. One is an initiator of a conversation, another is a target. I have a pair of message types, one sent by the initiator one sent by the target. I have a pair of queues corresponding to the above services. Both queues have activation stored procedures associate with them. The intiiator sends its mesage to the queue that the target service is defined on. The activation procedure successfully retrieves the message, does some work and then sends a reply message on the same conversation to the initiating service. At this point behavior seems to become strange. Some of the time the send from the target service produces the "zero length message" error and indeed at times the message body is em ...Show All

• Davids Learning Reporting Services with Parameter

  I can not build a report correctly with reporting services using a select parameter can anyone point me in the right direct of a step by step article I would be very appreicative. 2 ways: 1) you have a parameters-tab for your dataset where you can define sql-parameters depending on your report parameters eg @sqlparam=reportparam and use @sqlparam in your query 2) if your query is more complex, dont use the querybuilder and use a commandtext for the query that looks like ="SELECT * FROM XY WHERE ab="+Parameters!par1.value hope this helps you a bit ...Show All

• AlexBB Error importing data from oracle database to an SQL database

  Hi! When i was importing a database table from an Oracle Database to a SQL database table, the wizard returns this error: Could not connect source component. Warning 0x80202066: Source - VB_PERMISSIONS [1]: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used. Error 0xc0204018: DTS.Pipeline: The "output column "PE_ACTIVE" (34)" has a precision that is not valid. The precision must be between 1 and 38.  (S ...Show All

• zhengh Access Database Synchronizer (ADS)

  Hi All, Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device. For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx I urge you all to in ...Show All