SQL Server

Page 3551




  • Topics
    Replies
    Last post
  • Service Pack 2 Failure
    by Ed Vanover
    4 Replies
    Last post by Ed Vanover
      • Trying to install Service Pack 2 on a production server and it fails updating the Database Services with an 11032 error. Here is the summery log. Time: 09/13/2007 20:43:21.980 KB Number: KB921896 Machine: SQLDATABASE OS Version: Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Lev
  • messages stuck in sys.transmission_queue
    by John Hennesey
    6 Replies
    Last post by Remus Rusanu
      • Sorry for the stupid question, but I can't seem to figure it out... There are 119 messages that are stuck in the transmission queue, all for the same queue. When I check the status of the queue (via sys.service_queues), is_receive_enabled = 1, is_activation_enabled = 1, and max_readers = 3. When I check to see if there is an active queue monitor (via sys.dm_broker_queue_monitors) there is nobod
  • Calculated Average w/o a dimension specified
    by gnieboer
    4 Replies
    Last post by Darren Gosbell
      • OK, Here's another one... I want to create a calculated member that compares the current member to the average of the other members at the same level the member is in. The catch is that I want this to be a calculated member in the cube that works regardless of what dimensions/hierarchies the data is broken down with. The MDX below shows what I want to do except that it require
  • Mirroring problem between pcs in different location (Witness Issue)
    by Hans1982
    11 Replies
    Last post by Dani Avni
      • I am facing this problem here. Well , I did setup mirroring in LAN successfully (using certificates). Then I try to implement the same method for WAN. Here's the info : Principal : location A (111.222.333.444,1234:5022) Mirror : location B (444.555.666.777:5022) Witness : location A (111.222.333.444,5678:5022) For the mirror side, I didn't put any firewall settings at all; and both pr
  • Schedule SQL Express BAckup using SQL DMO
    by dmouser
    6 Replies
    Last post by Cesar Francisco
      • Is it possible to schedule SQL Express BAckup using SQL DMO do I need to use WScript.Shell,SQLDMO.SQLServer,SQLDMO.Category,SQLDMO.Job, SQLDMO.JobStep,SQLDMO.JobSchedule
  • Jump to URL
    by Kiranvukkadala
    3 Replies
    Last post by Rakam
      • to open a report in a new window i looked up the following line of code = window.open('" & Globals!ReportServerUrl & " " & Globals!ReportFolder & "/" & "myreport " & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"
  • Migrating Data from MySQL
    by jimbo101974
    8 Replies
    Last post by jimbo101974
      • Hello I am looking for a way to migrate my data from a MySQL database to a SQL2005 Express data base. All of my MySQL Schemas only have 1 or 2 tables in them so I would imagine that it isn't that hard to do. I treid just exporting it to a CSV file with the intention of just using import/export in MSSQL but in the express edition, it ain't there. Like I stated all of my schemas are only 1 or two
  • Cross Domain Windows Endpoint Authentication?
    by Dietz
    5 Replies
    Last post by Remus Rusanu
      • Hi There I have service broker working 100% with an initiator - forwarder - target, all in the same domain using windows authentication on the endpoints, for all instances' the sql server service run under the same domain account, which in turn is granted connect on the various endpoints. This all works 100% However i have a scenario where the initiator will be in a different trusted domain.
  • Periodic "SQL Server Assertion" error
    by E_rulez
    11 Replies
    Last post by Alexey
      • Hello, Since we started using another sales program (1C Enterprise), SQL Server started "crashing" (connection between our program and SQL Server breaks) with this assertion error: Event ID: 17066 SQL Server Assertion: File: <"xrange.cpp">, line=399 Failed Assertion = '0 == pxteRangeHrow->m_pxteFetch'. This error may be timing-related. If the error persists after rerun
  • pass hidden parameter from one dataset to another
    by forwheeler
    1 Replies
    Last post by forwheeler
      • I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset. How can I do this I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row.
  • Activation Failure
    by HCB1
    14 Replies
    Last post by bobbins
      • We recently upgraded SQL Server 2005 to SP 2 and now cannot implement Database mail. The message given is "Activation Failure" in the log. I have looked at the stored procedure " sp_sysmail_activate" and there is apparently a failure due to an invalid parameter. Can someone provide some direction regarding how to proceed Thanks.
  • How To Connect Remote Server's DataBase from another's Server's QueryWindow
    by Bhaskar_ExcelIndia
    3 Replies
    Last post by Bhaskar_ExcelIndia
      • Please Help Me to do this... Consider i hv already logged in sql server 2005 ip no : 192.168.2.20 db name: framework from this query window is it possible to access the objects(tables,stored porc's) of another server's database for example , sql server 2005 ip no : 192.168.2.21 db name: framework1 ................................................... Im able to access the same server's db objects
  • SSIS
    by Biju Varughese
    14 Replies
    Last post by Biju Varughese
      • How to convert Character Set ID 937 defined column in AS400 into SQL database
  • Help - Can't get Compact Edition to work with CE.NET 4.2 !
    by CiaranB
    5 Replies
    Last post by Ilya Tumanov
      • I have a Symbol MK1200 device (Intel XScale processor) running CE.NET 4.2 and when I try to reference any SQL objects I get the error: Can't find PInvoke DLL 'sqlceme30.dll' The documentation says that Compact Edition is supported on CE.NET 4.2, (ms-help://MS.SSCE.v31.EN/ssmmain3/html/ee220634-55c9-4123-85c4-4e6ceb07f942.htm) but I came across a hotfix ( http://support.microsoft.com/kb/92481
  • What solutions make returning from a disaster easier?
    by Ken Hutchinson
    3 Replies
    Last post by Michael Hotek
      • I'm trying to figure out what solution (replication, mirroring, clustering) would work best for me. I have been reading many articles in BOL and in this forum. Most talk about getting data TO a backup/standby/subscriber, but I can't find a lot of info regarding getting the data BACK after a disaster is over. We have a main office and a disaster recovery facility. Most of the time there are no data
  • Error while importing Text file using Import Export Wizard
    by Wail_gsm
    14 Replies
    Last post by paragp
      • Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection
  • Read the transaction log (ldf) file. My first post ever :)
    by J-A.G.
    7 Replies
    Last post by Emanuel Peixoto
      • Hi! The purpose is to se history of which user updated, inserted or deleted a row in the database. Can't seem to find any publications from microsoft on how to parse and interpret the log file. Any documentation on how the log file is structured Is it possible to obtain this information through the system views I don't want to use triggers. Thanks
  • SSIS Connection Manager passwords
    by YoungEngineer
    14 Replies
    Last post by jwelch
      • I am having a strange problem in that when ever I create a connection to an OLE db source and use SQL Server authorization and save the password, the connection manager seems to "forget" the password. That is, when I click the 'save password' check box, and do a test connection, it connects fine. But as soon as I close that connection window, and reopen it, the password box is empty, and
  • How to drill down on fields
    by Aparimeeth
    2 Replies
    Last post by Aparimeeth
      • Hi All , I am new to Sql Server and Reporting services .. I was trying to make a drill down report I have created Grooup on detail row and set the Visibility with one of the group rows just above .. But when preview the report I cannot see any data .. How ever If I Delete the Groups I can see the data .. Is there anything that I am missing Please help
  • System.Data.SqlServerCE.dll reference causes error ...
    by dlcollison
    2 Replies
    Last post by Nick Randolph
      • Hello All ... I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine. I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have create
  • Deploying reports to MOSS 2007
    by MCOURTIN
    3 Replies
    Last post by Prash Shirolkar - MS
      • Hello, I wonder if anyone can help me save the few remaining hairs on my head I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any
  • How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005
    by vadoriu
    4 Replies
    Last post by Phil Brammer
      • Hello! I'ave got a problem of setting more than one Variable in ReadOnlyVariables Property of ScriptComponent...I provide comma separated list of names ( As described in the help ) byt VS Studio Editor can not be opoened claiming that there is no a variablle with such a name...Looks like it doesn't treat the list as a collection of names... Please help. Vladimir
  • Help with expression to display a per-week daterange value!
    by dvang
    3 Replies
    Last post by Jarret
      • Here is the table I¡¯m working with: dbo.Reject Rejections Amount Date 5 12 1/4/07 9 3 1/6/07 1 6 1/23/07 0 0 2/11/07 7 8 2/20/07 Is it possible to write an expression for RS2005 in the details row in a table that will separate and ad
  • Trigger programming SQL 2005 vs SQL 2000
    by Hans Preuer
    8 Replies
    Last post by Hans Preuer
      • Hallo I have a trigger which works well on SQL Server 2000. Now, I transferd the Database to SQL Server 2005, the "normal" database things works all fine, I have only troubles with 1 trigger. I debugged it and found the problem must be here, but I can't see it: SET @whereClause = '(xsapnumber LIKE ''%' + @p_sapno + '%'')' exec ( 'declare LiteratureCursor Cursor
  • Problems with Roles and sp_helpRoleMember
    by Randy Trexler
    14 Replies
    Last post by RTang
      • I have a database role named gc_stationAdmin. I have a user x who has this role granted him when via Mgmt Studio under Logins. In fact I have 50+ users who have this role. 1) when I execute sp_helpRoleMember I see only 20 users who have this role when I'm expecting to see 50 and user X is not amongst the 20 2) when sp_helpRoleMember is executed AS user X, they only see 1 user with this role