Answer Questions

• asche 64-bit SQL Server 2005 Installation (Reporting Services)

  Hi, Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server. The Reporting services is not getting installed or the option is disabled. The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. The server also has SQL Server 2000 (32bit). Is the 32-bit SQL Server 2000 (32 bit) a problem But, it was working fine with the SQL Server 2005 CTP. Can anyone help/suggest Thanks in advance. ...Show All

• shyamu Import DB from a SQL 2000 backup into SQL 2005

  How I can to import a DB actually in a SQL 2000 backup into Sql 2005 Thanks Can you not simply RESTORE the backup "JVAF@discussions.microsoft.com" wrote in message news:b0c3c1e0-323b-4118-b70e-4bda20e0222b@discussions.microsoft.com: > How I can to import a DB actually in a SQL 2000 backup into Sql 2005 > > Thanks ...Show All

• Benjamin80 A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication

  Hi, Iam trying to perform merge replication between SQL Server 2005 and SQL server mobile.  It has previously been working.  Recently something is causing the following problem when i try to perform the merge.  I grabed the following output from the replication monitor. Error messages: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the sn ...Show All

• Rafie Stored procedure

  Hi every body when i ran this code in sql server 2005 "use test go create proc testProc @s nvarchar ( 100 ), @t nvarchar ( 100 ) As begin select @s from @t end go" i encountered this error message "Incorrect syntax near '@t'." what is wrong in my code by thanks Javaneh so thanks friends I'll try them ...Show All

• Ultraman76 How to fit report perfectly in Report Viewer in WebParts

  I am able to get my Report Viewer in my webpart bucket to run the report, however all I see is the top panel that allows you to export, navigate, etc. How can I get rid of that and fit my small graph report inside this bucket perfectly ...Show All

• J. Schouten Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...S ...Show All

• prjuanl SQL Server Cluster on SAN storage

  What if any effect does it have on SQL Server performance to have the database spread across several drive letters (LUNs) on a SAN as opposed to having it all reside on a single drive letter. I have heard that the OS can take advantage of the multiple data paths even when the data will all end up on the same spindle and would like some other opinions on the matter. Thanks Paul. I understand and agree with what you said. The questio ...Show All

• Sentinel3304 Bitwise operation in SELECT killing performance, *sometimes*?

  Hi there, We have a high volume SQL Server which gets into trouble at times, with one query blocking out others for 10-15 minutes. The query looks something like this: SELECT * FROM MyTable WHERE MyQueryColumn & 128 = 128 ORDER BY MySortColumn There is an index that exists containing MyQueryColumn.  MyTable has somewhere around 550,000 rows, around 50 of which might match this query at any particular time. Almost every time this query e ...Show All

• iDhinesh Reporting Services on Win XP Pro x64

  I just installed SQL 2005 Express with advanced tools on my Win XP Pro 64 bit edition. I expected reporting services to work but it appears as if it isn't configured. I use SQL 2005 Enterprise at work and there I used the Reporting Services Configuration Toole to configure and set up reporting services. However, this tool is not available with the current install. When I installed, the installer warned that .NET 64-bit is registered a ...Show All

• Gus_ SQL Server 2005 Linked Server to a comma delimited Text File. How do I import fields as text data type?

  Product: SQL Server 2005 Linked Server Setup: Product Name: Jet 4.0 Provider String: Text Question: When querying a comma delimited file, why does sql server try to interpret data types How can I make all fields Varchar or Char Project: Parse phone number fields into to seperate fields, seperating the area code and the rest of the number. i.e. FROM: Field 1: 1234567891 TO: Field 1: 123 Field 2: 4567891 ...Show All

• Dan Kuehn One dataflow for sevral Oracle Instances ?

  Hi, I designed a dataflow which extracts, transforms and load (the main goals of an ETL .... ) data from an Oracle db to an Sql Server 2005 db. The issue is that I would like to run this dataflow on several Oracle instances in a row. This intances are not on the same Oracle Servers. Is there a way to set only one data source for all these intances and to use a loop to execute the dataflow for each . Regards Ayzan ...Show All

• Ken_Bussell Nested data region and data sets

  Hi, I just want to know if nested data region (e.g. matrix nested in a list) support different data sets. i.e. I have 2 data sets, dataSet1 and dataSet2 and want to display in a matrix (dataSet1) nested in a list (dataSet2), does it work Thanks.   Nested data regions do not support different data sets Thank you. It works. However, joining the two datasets may lower the performance of the sql processing, ...Show All

• Dynamo SSRS 2005 and Email Subscriptions - HELP

  Hi All - Having a problem with email subscriptions in SSRS 2005 running on Win2003 server. The email subscription is attempting to email an excell attachment of the report. The report uses a shared data source with stored credentials. Configured email in Reporting Services config manager to use SMTP server OurServer.OurDomain.com Even wrote a test vb.net program to send email using that SMTP server and was successful - yet Reporting Service ...Show All

• Goran Ciric Online Data Transform

  Dear All, I am new to SSIS, and just watched some of the webcasts and take a look at SSIS Hands on Lab on the MSDN site. I want to handle an online data transformation scenario which has some data mappings between. I want the SSIS to add each new record in source table, insert in the destination tables online. If this is possible, please let me know where can I find a sample package and configurations. Happy new year, Sassan ...Show All

• Thomas Danecker Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no ...Show All