SQL Server

Page 2734




  • Topics
    Replies
    Last post
  • Connection to oracle / sqlserver / db2 databases
    by Vipul123
    2 Replies
    Last post by Vipul123
      • Hi All, Is there a way in SSIS to change the database connection to sqlserver or oracle or db2 without choosing the connection manager in the source. For e.g. I ran a package which is reading data from sqlserver and later i want to connect to oracle to read the data but without changing the connection manager in the source. Basically, i want to find out from you gurus is about a way to sw
  • When Trying to upgrade to WSUS 3.0 I get a SQL Error
    by MikeG40
    1 Replies
    Last post by Amannex1
      • When Trying to upgrade to WSUS 3.0 I get a SQL Error. it comes up with "Failed to connect to SQL Server <servername>\MICROSOFT##SSEE The specified service does not exist as an installed service" Any Suggestions
  • Backup File Name
    by Imran Hasware
    2 Replies
    Last post by Imran Hasware
      • Dear all, On scheduling the online backup for SQL server 2005 with SQL server management studio, how the backup filename can be automatically change for everyday. I mean the backup filename be automatically generated every day. Thanks Imran Hasware
  • parameterized update sp_executesql
    by AmyGr
    4 Replies
    Last post by AmyGr
      • I am trying to limit network traffic by only sending fields that have actually changed to an update stored procedure. I am obviously not doing this correctly as I am rather new to this. This is a small version of my sproc that I am using to test the workings. I am getting 'Error converting data type nvarchar to int'. If you can help me get this easy query working, I would very much like your help
  • Connection Problem With Sql Server 2000
    by GiampaoloSanRemo
    4 Replies
    Last post by Jens K. Suessmeyer
      • Hello Everyone The my PC's address is 10.0.0.X, and I want to connect with a Sql Server 2000 default Instance That have the address 192.168.1.X I have modified the TCP port of Sql Server 2000 in 1453, instead 1433. In my PC I have modified cliconfig and in Sql Native Client configuration, setting the client TCP port to 1453. Using the old Enterprise manager is possible to connect to Sql Serv
  • The specified network name is no longer available. Communication link failure
    by HMCSharon
    6 Replies
    Last post by Carlos Godinho
      • Problem: We have intermittent failures of SQL Server jobs with the following error - TCP Provider: The specified network name is no longer available. [SQLSTATE 08S01] Communication link failure [SQLSTATE 08S01] Types of job steps failing: DBCC Checkdb, LiteSpeed backups, re-indexing sql in stored procs, home-grown database update stored procs. These types of job steps are failing on 3 different
  • Bootstrapping SQL Server Express
    by RichLeyshon
    10 Replies
    Last post by RichLeyshon
      • Can someone tell me if there is a definitive description somewhwere re how to get SQL Server 2005 to install from the same CD as a VB application. Despite the help pages that I found not mentioning anything about copying the files into the Bootstrapper\Packages folder, I found this in the forums. However, whilst Windows Installer and .net framework install ok, it still bombs out with SQL.
  • Company footer message on all reports
    by Peter Lyon
    4 Replies
    Last post by Peter Lyon
      • I've looked around, but can't find this anywhere. Does anyone know of a way to add a footer to all reports (including new ones being created via report builder) So that when users create new reports, the global footer is there.
  • forwarding error
    by Dietz
    2 Replies
    Last post by Dietz
      • Hi There I am doing the follwing , sending a message from initiator A to service73 at targetA. I am profiling the initiator, forwarer and target. At the initiator everything is 100%, at the forwarder message is forwarded 100%. I am receiving the following error at the target: Could not forward the message because forwarding is disabled in this SQL Server instance. Now i have had
  • many users...all with different data
    by craig11
    1 Replies
    Last post by Martin_McNally
      • Just started looking at SQL Server Replication today. Just need to be shoved in the right direction...I have a 1000 users, and each need to have only their personal data replicated to them....So, is this possible, do I create a 1000 "articles" or do I create one article and somehow pass in a parameter
  • Project Real Report Takes Hours to execute.
    by vidya_084
    0 Replies
    Last post by vidya_084
      • Hi, I tried to create a report on Project Real with one normal and one calcuated measure. The report contains three dimensions Time , Item, Store. when i try executing the report, it will never return any result , its executing forever. When i run the mdx query for the report on SSAS cube directly , again it takes many hrs for executing. Can anyone point me to the mistake i am doing Here is the M
  • no query-results shown in my report
    by haraldhorcicka
    1 Replies
    Last post by adolf garlic
      • hi, i have a problem with a report. if i try it with vs2005 and the preview it works. if i call the report from my web-application i get no error-message, but i only get my headlines and no query-results. i use reportingservices 2005, vs2005 and .net 1.1 my datasource is an olap-cube. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ReportE
  • MDX performance on calculated measure
    by Alexander Kilian
    3 Replies
    Last post by Deepak Puri
      • Hi, i have two problems with the following mdx statement: CALCULATE ; create member [Logistik_TakteReklaRedressen].[MEASURES].[delivery quantity] as null ; scope ([MEASURES].[delivery quantity]); this = Sum ([EVT Date].[HierWeek]. currentMember . Children , [MEASURES].[delivery quantity]); /*Non_Empty_Behavior(This) = {[MEASURES].[lfmenge1],[MEASURES].[lf
  • Exporting to Excel
    by IQ
    14 Replies
    Last post by eksplorer
      • Hi All, I am creating reports using SSRS 2005. After deploying my reports to the reporting server i want my reports to be exported to excel. But when i perform this the formatting of the report gets changed in excel. The cell in excel gets merged.thus the structure gets distorted. Does anyone have any idea in this regrard Why is it so and what is the solution for the same
  • Upgrade SQL Server Express 2005 to Standard Edition
    by artificer
    9 Replies
    Last post by Caddre
      • I tried to upgrade an Express edition 2005 to Standard Edition 2005. I did remember to use the command prompt setup parameter to allow the upgrade but still the option to upgrade is disabled. Can upgrade from express to standard
  • Need to get separate pages for each person..help
    by bkana
    7 Replies
    Last post by bkana
      • I'm fairly new to RS and have a problem. I have a query that pulls information on people, courses they have taken, their score and so on. I have a date parameter setup so I can run it by year. Everything works ok on the query side, I get all the information I need on all the people and the courses they have taken. However, when I run the report, I do not get a separate page for each person and
  • FormatNumber(mValue,2, false,false)
    by Seetharaman
    0 Replies
    Last post by Seetharaman
      • I am u
  • Adding records
    by madskunk
    6 Replies
    Last post by madskunk
      • Hello guys, I hope someone can help me! I have a (probably simple) problem with compact edition, I can't seem to add records using VB 6.0. Here's some sample code I've been testing with: Dim pConn As ADODB.Connection Dim pRS As ADODB.Recordset Set pConn = New ADODB.Connection Set pRS = New ADODB.Recordset pConn.ConnectionString = "PROVIDER=Microsoft.SQLSERVER.MOBILE
  • Report Manager Error
    by silent33333
    10 Replies
    Last post by silent33333
      • I have seen this issue in other posts, but I've never seen a way to fix it. When I try to access the Report Manager, I get the following: Server Error in '/Reports' Application.
  • Interface-less SMO?
    by monk3yatthekeyboard
    10 Replies
    Last post by monk3yatthekeyboard
      • One of the typical uses of DMO was to instantiate COM objects via t-sql either via stored procedures or ad-hoc submissions through Query Anaylzer/OSQL/ISQL. This allows me to construct helper scripts that have access to objects outside the SQL Server process space, and I don't have to create any application (console or gui) to do what I need. It seems that SMO is not meant to be 'interface-
  • 2005 Service Pack 2 problems ..
    by Stuckish
    3 Replies
    Last post by cusman
      • I tried to install Service Pack 2 yesterday but got an error. But now i do not really understand in what state my SQL server is .. The log file with the error saying this. ********************************************************************************** Prerequisites Check & Status SQLSupport: Failed ****************************************************************************
  • AMO:Is there any locking mechanisam available in MSAS 2005
    by vishweshwar
    7 Replies
    Last post by Darren Gosbell
      • Hi All, I am working on Analysis Server 2005 and .Net 2005 and AMO,i already worked on AS 2000 and .Net 1.1 with DSO. I just want to comform one thing is there any thing like OlapLockTypes are there in AS 20005 or AMO.Please let me know how it works. Thanks in Advance.
  • Strange behavoir with XQuery and UNIQUEIDENTIFIER
    by sbrushey
    3 Replies
    Last post by MRys
      • With the example below the first guid works but the second doesn't! Does anyone have any ideas Thanks, Simon declare @id uniqueidentifier declare @xml xml set @id = 'cb5ae187-1012-4b1f-b02c-f08e28fa3dc1' set @xml = '<service><id>cb5ae187-1012-4b1f-b02c-f08e28fa3dc1</id></service>' --set @id = '7F0FDB3C-5EE4-4806-9A8E-DDE7006B62C7' --set @xml = '<service><id>7F0
  • MDX Classroom Courses for AS 2005?
    by DanUp
    12 Replies
    Last post by PETurley
      • Two questions... (1) Does anyone know when this course... "Implementing Biz Logic with MDX in MS SQL 2000" ...will be updated to SQL 2005 This is ...overdue. (2) Is any organization (besides Hitachi Consulting) providing any classroom training totally dedicated to MDX in SQL 2005 (whether or not it conforms to an official MS course)
  • Upgrader SQL Server 2000 to SQL Server 2008 July CTP
    by ahmed mosa
    3 Replies
    Last post by cybershooters
      • Dear all, i have alot of qustions 1) Can i install Side by Side SQL Server 2000 and SQL Server 2008 July CTP 2) Can i upgrade Default instanse of SQL Server 2000 to SQL Server 2008 July CTP 3) Are anyone have advice of upgrade Analysis Service, DTS and Relational database on SQL Server 2000 to SQL Server 2008 i know some points in Readme file but i ask if any one has wor