SQL Server

Page 1671




  • Topics
    Replies
    Last post
  • SP2 SQL Server 2005 Error 29528
    by Franky García
    5 Replies
    Last post by EdGillett
      • Hello, I am having problems installing the SP2 for SQL server 2005 on a W2000 Professional. It appears that the Database Services, Analysis Services, Reporting Services and Integration Services are not being updated. I would appreciate any help with this if anyone has seen or had experience with this issue. Thanks, the basic log file is listed below. SQL9_Hotfix_KB921896_sqlrun_sql.msp.
  • Median calculation
    by pmak
    2 Replies
    Last post by Mosha Pasumansky
      • I want to calculate the MEDIAN time interval between the two date field. In an OLAP cube one of the dimension consists of the two date fields as well as Interval(days) field (calculated at the data source view). How to create a Measure in the OLAP cube to calculate the MEDIAN Interval MEDIAN( <<Set>>[, <<Numeric Expression>>])
  • Migrating DTS packages Question: Dynamic Properties
    by NewWorld
    2 Replies
    Last post by Nayan
      • Hi guys, After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime , I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way ' Add your code here ' Sou
  • When a feild is null I do not want to see the empty cell and Titel in a report?
    by allpdoff
    3 Replies
    Last post by jwelch
      • Let's say I have three fields in a table like this... Name Tell us about cats Tell us about dogs Now I have two records. Name Billy Bob Tell us about cats I do not have any Cats Tell us about dogs "null" Name Joe Slick Tell us about cats "null" Tell us about dogs they sure chase Cats a lot. I want my report
  • Create Subscription For Rpt Service with Windows integrated security !!!
    by nicky_tsh
    7 Replies
    Last post by Peter Cwik
      • hi All, I m nicky here. I have problem on Create Subscription for my report if my Data Source is use Windows Integrated Security, with this error message: "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report , the linked is no longer valid" Please Help .... Thank you From nicky
  • SSIS Configuration File
    by MSDN Student
    7 Replies
    Last post by jwelch
      • Hello All, In my project, developers enable configuration on the packages they develop. This means that if a project has 100 packages, each one has its own configuration file. If our primary database server changes, I have to go an update 100 configuration files. This defeats the purpose of having a configuration file in the first place. I want to have a configuration f
  • Visual Studio 2005 shows wrong SQL Server versions
    by TA
    1 Replies
    Last post by Sam Lester - MSFT
      • Visual Studio 2005 shows SQL Server 2005 installed product versions differently than the actual. As seen below VS2005 displays 9.00. 3042 .00 as the version of SQL Server 2005 however it is 9.00. 3050 .00 in SQL Server Management Studio. [Look at Installed Products section after selecting About MS Visual Studio from Help menu ] SQL Server Analysis Services Microsoft SQL Server Analysis Se
  • different results using ISO-8859-1 vs utf-8 with sp_xml_preparedDocument
    by Bo416
    1 Replies
    Last post by Bo416
      • We have a stored procedure which is passed an xml string (text datatype) and that string is passed on to sp_xml_prepared_Document (btw its a Sql 2000 server). We've had no problems until yesterday when a really long xml string (>18,000) was passed in and all of sudden the proc stopped working with an error message of: "Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line
  • Integration Services - Header and Footer
    by Rudolf Erasmus
    12 Replies
    Last post by Rudolf Erasmus
      • I have been struggling to get this right in Integration Services, Would really appreciate the help. Basically I have a file with fixed length columns that I would like to import into my database using Integration Services, the file looks something like this AN_HeaderRecord0001Testfile.txt MyName MySurname 0127721506 MyName2 MySurname2 0127722322 FooterRec0000000
  • The merge process was unable to deliver the snapshot to users having host_name length 10 and partition_id bigger than 999
    by Hakan G&amp;#252;m&amp
    12 Replies
    Last post by Hakan Gumu?
      • Hi, We are performing merge replication between SQL Server 2005 and SQL Server Mobile with more than 1100 handheld, and recently we have following problem with user name(which is used as host_name in merge repl.) having length 10 chars and partition_id bigger than 999. Error Code: 80004005 Message : Minor Err.: 29006 Source : Microsoft SQL Server 2005 Mobile Edition 20070116-121908 Erro
  • Replacing Null values in query
    by NDD
    5 Replies
    Last post by NDD
      • Hello, I'm using the query wizard in VB.net to write a query for SQL CE. I want to replace null values with text. I expected the COALESCE function to do this but I get an error message saying its not a valid function. This is a sample. Select COALESCE(table.Name,'No Name') as Name from table Any help appreciated Thanks
  • Report objects shift to right on very wide report - why?
    by BlackCatBone
    6 Replies
    Last post by El Pedro
      • Greetings, I have a very wide report of more than 20 inches. I've placed several parameter values in the report header section so that the user can see what filters have been applied to the data. The testboxes shift their position several inches to the right when the report is run from the Report Manager. Is there a way to make sure that a textbox is displayed at an absolute position I thou
  • Conditional Split - 0 KB out files
    by Siva116
    8 Replies
    Last post by jwelch
      • Hi, I'm exporting data to different text files depending on a condition. My "conditional split" looks like @[User::Variable0] == 0 @[User::Variable1] == 1 @[User::Variable2] == 2...........etc... I've about 8 output files from the "conditional split". For each run, only one condition is valid. When I run the package with value 0, I need to get o
  • variable string limit
    by tackett
    6 Replies
    Last post by tackett
      • Is there a way around the character limit for a variable I'm throwing the following in a variable and evaulating it as an expression and having an execute sql task do it, but I can clearly see it's being cut off. "insert work.dbo.data_run select publisher,publisher_db,subscriber,subscriber_db,article,null,getdate(),null from msdb.dbo.sysreplicationalerts where error_id<>0
  • Instructions for setting up a Sybase ASE Server as a SQL Server 2005 Linked Server?
    by Ken Powers
    6 Replies
    Last post by Ken Powers
      • I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server. I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was
  • SSIS configuration files
    by mgale1576208
    4 Replies
    Last post by mgale1
      • Hello, I am having a bit of trouble with SSIS Configurations. - In BIDS, I have added a configuration file and specified the properties I want to expose. - When I build the project, I get the standard bin\deployment folder which contains the package file (.dtsx), the configuration file (.dtsconfig) and the deploymentmanifest. - Before deploying the package, I edit the config file to have the setti
  • SET QUOTED_IDENTIFIER Question
    by dgolds
    4 Replies
    Last post by Arnie Rowland
      • When I execute a SET QUOTED_IDENTIFIER statement, does it only apply to the current batch or current connection I noticed it doesn't change the "Quoted Identifiers Enabled" setting in the Options page of the Database Properties in Management Studio. Thanks, -Dave
  • Defining Analysis Services Named Calculation
    by DineshMurali
    9 Replies
    Last post by PedroCGD
      • Hi, I am creating a new Named Caluclation for time dimension in dsv and added in the time dimension cube from the data source view in the time dimension structre. While processing it is giving the error message that "Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory" Can you please help me.
  • High CPU utilization with SQL Server 2005
    by Peter Chafin
    9 Replies
    Last post by mattgb
      • Our company recently combined our DBs into one SQL 2005 Server. Dell Power Edge 1800 with 3.00 GHz Xeon Processor 800 FSB, 1 GB of RAM Dell Power Edge 1600 with 2.80 GHz Xeon Processor 533 FSB, 1 GB of RAM Combined into one: Dell Power Edge 2950 Dual Core 1.6 GHz Xeon Woodcrest Processor, 4 GB of RAM However, the CPU utilization on this new server is maintaining at ab
  • SSIS Package does not remember password (OLE DB Connection + ADO.Net Connection)
    by Mr Pro Tools
    14 Replies
    Last post by Phil Brammer
      • Both the OLE DB Connection and ADO.Net Connection in SSIS Package does not remember password. Im connecting to a SQL Server 2000 box using its sa password as test. The SSIS package runs fine when you first set up the connection in bids The bottom line is that SSIS keeps forgetting the password I feed into the two Connections that I'm using. I double-click a connection, type the password i
  • character strings as primary keys
    by valentin tihomirov
    10 Replies
    Last post by valentin tihomirov
      • Hello, How bad is normalizing the database to the 3rd form, which requires that all fields depend on nothing but primary key. Consider the first table you create -- users. They have int primary keys, which duplicate the real primary keys -- user names. When user logs in, the user's entry is uniquely identified by its name, which is not primary key. The fundamental design rule -- avoid redundancy
  • URGENT!!! roll back db to point of time
    by RamezR
    3 Replies
    Last post by RamezR
      • hey guys i need help urgently i just ran an update statement without a where statement by mistake and i need to rollback this changes i;m runnning sql express sp2 and the database is set to recovery model simple i hace the mdf and ldf file the mdf is 1.5 gb ledf is 65 mb and the last changed date is the same time i ran the update statement so i think the changes are there in the ldf file but i jus
  • SAP BW OLE DB Provider in SQL Server 2005
    by Andychay
    1 Replies
    Last post by MoreMarvelous
      • I'm trying to connect to some info cubes that contain information generated by our APO module. I've got through security but the provider is having problems reading from the source and I get the following error: TITLE: Microsoft Visual Studio ------------------------------ Could not retrieve the table information for the connection manager 'Data Connection'. Method not supported. -------
  • is there a way to collapse/expande all rows in the report with one click?
    by igor_22
    0 Replies
    Last post by igor_22
      • Hi, is there a way to collapse/expande all rows in the report with one click Thanks, Igor
  • The IDMClusteringAlgorithm interface
    by Renan Souza
    7 Replies
    Last post by Bogdan Crivat
      • Good morning, Well... I'm implementing a clustering algorithm following the examples given on the Managed Plugin Algorithms tutorial. As the samples are in C# and I'm implementing it on C++, I'm facing some problems, but nothing really significant. But I've some conceptual questions about the implementation: 1) It necessary to implement the IDMClusteringAlgorithm interface in order to imp