SQL Server

Page 2740




  • Topics
    Replies
    Last post
  • starup parameters for mssqlserverADHelper
    by nigel.uk
    1 Replies
    Last post by Samuel Lester - MSFT
      • the service cannot start without two startup parameters can anyone tell me what these should be
  • Instead of Trigger and In-Place Updates
    by PaulNations
    3 Replies
    Last post by PaulNations
      • Converting an existing application, I have a table: create table problem ( building char(3), function char(4), sqft int, pct dec(5,2) ) [pct] is a problem because it depends on it's own row and the sum of all other rows for the same building: pct = sqft / sum(sqft) over building I want to create a trigger to update the pct column in the da
  • Modify Remove Ignore namespace in typed xml data type?
    by Terry Aney
    0 Replies
    Last post by Terry Aney
      • I have a Sql Xml Data type field with typed data associated with different schemas inserted in the *same* field. The different types of data represents 'different clients'. I have however, some *shared* xslt presentation files to process all data from this field (since many of the items are in similiar structure) but obviously since each 'client' has it's own associated schema, my shared xs
  • Transaction log restore procedure
    by L Arvind
    11 Replies
    Last post by Kevin Farlee
      • Hi We have a database on sqlserver 2005 on a schedule for transaction log backups is in place already which is happening at interval of 30mins.All these transaction logs are appended to file called 'BKP' on E drive of our server. Now i have to configure logshipping for this database.Normally logshipping process will backup the transaction log,stores it in a shared folder on primary server
  • Problem creating XML with FOR XML PATH
    by MickeyGreen
    3 Replies
    Last post by benzhi86
      • Using Northwind as an example this is the XML I would like to create: <CustomerOrders> <Customer CustomerID="ALFKI" CompanyName="Alfreds Futterkiste"> <Orders> <Order orderID="10643" orderdate="08/25/1997" /> <Order orderID="10692" orderdate="10/03/1997" /> <Order orderID="10702&quo
  • SKUUPGRADE Isn't working...
    by rlrcstr
    3 Replies
    Last post by rlrcstr
      • Trying to upgrade SQL Server 2005 Standars to SQL Server 2005 Enterprise. I've tried every combination of the setup.exe params I can think of: - start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 - start /wait setup.exe SKUUPGRADE=1 - start /wait setup.exe UPGRADE=SQL_Engine SKUUPGRADE=1 And several others. Nothing will ac
  • Problems upgrading SQL Server 2005 x64 Evaluation to SQL Server 2005 x64 Enterprise
    by windthorstking
    8 Replies
    Last post by windthorstking
      • I first tried installing the DVD and of course it told me I must use the command prompt installation method to include the line SKUUPGRADE=1. I found good references to this in the following links: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2208593&SiteID=1 http://msdn2.microsoft.com/en-us/library/ms144259.aspx Below is the command I issued at the command p
  • SQL failover - mirroring, log shipping, clustering, load balancing
    by matilda16
    10 Replies
    Last post by matilda16
      • Hello. I am confuse and cant decide on how to setup high availability on our SQL 2005. Here's what on my mind and on resources list: I plan to have mirroring on my SQL1 to SQL2 with the help of SQL3 as witness. So this would be automatic failover. My idea on mirroring is when SQL1 goes down, SQL3 would tell SQL2 to run and be the primary. It will automatically failover to SQL2. Right
  • SCD not updating
    by Anonymous768634
    14 Replies
    Last post by SQL-PRO
      • Hi gurus, My feeling with the SCD component is not that very solid. I have the feeling that the behavior of the insert/update strategy is not always correct an working. I will describe two problems that i encounter. 1. My destination table contains records with the value ''. Cause i don't want '' ( 2 single quotes) in our DWH i update the view that is the source with a case statement that change
  • Code Profiler is executing for requested trace
    by JJKusch
    1 Replies
    Last post by Jens K. Suessmeyer
      • Afternoon, Is there a way in SS2K5 Profiler to see what the code looks like for the trace being executed And then further, is there a way to copy the code and rework it in an SP Thanks ALL! J Kusch
  • dataadapter.Update() OR ExecuteNonQuery()
    by Dactilifera
    4 Replies
    Last post by Dactilifera
      • Hy, again! I am at the begining of an application. I have some modules that insert, delete and update only one row at one table. My question is should I use dataadapter.Update() or ExecuteNonQuery(). I prefer ExecuteNonQuery because I want to build a class : DataLayer to implement my own InsertProcedure(), UpdateProcedure(),DeleteProcedure(). I want speed in my application, so which is the best: d
  • SSL with Multiple Instances
    by Kent Waldrop Fe08
    3 Replies
    Last post by Mugambo
      • Can SQL Server be setup such that one instance on a server is using SSL and another instance is not Or is SSL a server-wide all-or-nothing issue Dave
  • EXEC sp_insertRecord has too many arguments specified: Msg 8144, Level 16, State 2-Why I got this error?
    by Scott Chang
    7 Replies
    Last post by Scott Chang
      • Hi all, In Object Explorer of my ComputerName\SQLEXPRESS, I have a Database "shcDB" with Table "dbo.MyFriends" which has fields "PersonID" (Int), "FirstName", "LastName", "StreetAddress", "City", "State", "ZipCode", "E-MailAddress" set up. When I executed the following query: /////----shcSP-1
  • General feedback on animations needed
    by dbjorck
    1 Replies
    Last post by DarrenSQLIS
      • Hi! I have an idea to generate an animation file in SSIS based on the data it imports. Has anyone done that Is Flash the best format for this or something else I have programmed in several languages, and written programs before that wrote other programs, but I have never used any of the animation tools such as Flash. Can anyone point me to some resources I can use to quickly get up t
  • Microsoft Access Database Synchronizer (ADS) RTW Help
    by SamReh
    7 Replies
    Last post by ErikEJ
      • Someone please help, Ive downloaded and instsalled Microsoft Access Database Synchronizer (ADS) RTW onto my desktop and the files have installed to C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access. Ive got a device running windows CE 5.0 connected to the desktop via USB. Ive installed all the necessary CAB files onto the device but how do I get the ADS working What do I have
  • SSIS And T-SQL Print Statement
    by Pete Murphy
    2 Replies
    Last post by David Frommer
      • First, I will apologise in advance for my ignorance, but I am new to the subject of SSIS. My objective is tbe able to execute a stored procedure from SSIS and have a log of what the stored procedure did - preferably a log file At the moment the stored procedure diagnostics etc are via T-SQL Print statement . When I execute the stored procedure from SSIS I don't get any of the print diagno
  • Can I use Custom UI for executing Package in C#?
    by My Vizai
    9 Replies
    Last post by My Vizai
      • Hi I've a doubt. I don't know whether it is possible or not. I've a very less knowledge in DTS packages. When I execute a package in C#. it is displaying predefined GUI for showing process. Can I've my own UI when executing DTS. Thanks in advance.
  • SQL Server 2005 Compact Edition + .NET version 1.0
    by LtSolo
    4 Replies
    Last post by LtSolo
      • Hello, I want to learn if it is possible to develop applications for SQL Server 2005 Compact Edition using .NET Compact version 1.0 . The major doubt is the possibility for version 1.0. It is reasonable to deliver SQL Compact Edition redistributables with an application, but this is not great to require ,NET 2.0. Many thanks.
  • Service Broker from SSIS
    by RudyGroode
    1 Replies
    Last post by pons68
      • Hello, I want to use Service Broker to drop some SQL from a loop in SSIS task into a Service Broker queue. Can anyone point me in the right direction, examples, samples I have an ExecuteSQL task which returns a set of tablenames, which will be iterated to, and I want to send an EXEC mySP 'myTable' to Service Broker, to asynchronously execute. I have created a queue and a service, but I'm not
  • When should I examine the values of expressions?
    by JeffJohnsonMVPVB
    2 Replies
    Last post by JeffJohnsonMVPVB
      • I have written a few custom tasks and I've noticed that they don't behave exactly like the built-in MS tasks when in design mode. Specifically, they don't update themselves with the values of expressions that have been assigned to their custom properties. Here's an example. My task exposes a property called JobNumber. Let's say I make a variable called @[User::JobNumber], give it a value, a
  • ssis issue
    by Gess Man
    2 Replies
    Last post by Ryan.Kelley
      • I am trying to create a job in ssis for a package I created. I able to execute the package, but get the following error when I run the job [298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000] Anybody have any idea how to get around this
  • Excel file loading in SSIS
    by sidzone123
    4 Replies
    Last post by sidzone123
      • Hi All, We did the development of SSIS packges on 32 bit machine. We have few excel files which is loaded using SSIS. Now the same was deployed to anothe rmachine(64 bit). This 64-bit machine does not have Microsoft office installed. And all packages(which loads excel files) failed. Hence can someone answer my following questions:- 1) In order to load excel files using SSIS, is
  • Backup Software
    by The Loiner
    9 Replies
    Last post by Tombellia
      • Hi We are getting ready to rollout a new system in the next few months and I have started to look at backup and recovery strategies for SQL Server 2005 on which this new system will be housed. The proposal is to by Veritas Backup Exec with the server this system will be housed on however my knowledge is "limited" to the backup and restore options available directly from SQL. I have be
  • ReportViewer axd path
    by svenderuyter
    7 Replies
    Last post by Sajjad Mussani
      • Hello, I'm having problems using the ReportViewer control (which you can use in VS2005). When I go to the page that contains the control, the images (back, next, print, etc) don't show up and I get different javascript errors (one of them is the "RSClientController is undefined" error). After some investigation, I found out that the path to the Reserved.ReportViewerWebControl.axd file
  • Query Timeout in SSAS
    by pmak
    1 Replies
    Last post by Edward Melomed
      • I am using Sql 2005 SSAS. When building the Data Source Views using "Edit Named Query", the data source is pointed to a Sql 7.0 server. When I tried to execute the query, it terminates after 30 seconds with "Query Timeout Expired".