SQL Server

Page 2110




  • Topics
    Replies
    Last post
  • Connection String
    by merwy
    1 Replies
    Last post by Jimmy Wu - MSFT
      • public class Class1 { public string sConType = System.Configuration.ConfigurationManager.AppSettings["conType"].ToString(); public string server = System.Configuration.ConfigurationManager.AppSettings["server"].ToString(); public string UID = System.Configuration.ConfigurationManager.AppSettings["UID"].ToString(); public string PWD = System.Configura
  • SSIS Error only from Scheduled Job
    by SQLChamp
    14 Replies
    Last post by JayH
      • Quick question - What are the different ways of executing SSIS Package besides Scheduled Job Does SSIS support command line execution (DTSRUN command supported in 2005) The reason I asked was that Scheduled Job triggered SSIS always error out. But when I call the same SSIS in Visual Studio, it executes beautifully. I wonder if there's some reason behind the error when calling from Schedu
  • SSIS Package Challenge!!!
    by vai2000
    2 Replies
    Last post by Rafael Salas
      • Hi All, Need to accomplish this in SSIS...if someone can point me the flow tips or how to proceed would sincerely appreciate it. The OwnerRecord_1 owns RecordA and RecordB....and so on...the owner record follows the details records Flat File Input RecordA........... RecordB.................. OwnerRecord_1 RecordC................. RecordD................. OwnerRecord_2 ..............
  • problem when running "configuration web synchronization"
    by Qiuwei
    4 Replies
    Last post by Qiuwei
      • Hi, there; We have device using sqlce2.0 and replicate data with sql2000. Now we have new WM5 device which uses SqlCe3.0. So I need to install connectivity tools using "SqlCe30setupen.msi". I got error when I run " Configure Web Synchronization Wizard ": The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib). When I run this wizard, I
  • SQL Server loosing connections
    by facemann
    6 Replies
    Last post by oj
      • I have posted this in the SQL Server Data Access forum but wondered if this was a better location. We have two Server 2005 boxes and one Sever 2000. About 3 months ago we started experiencing random database connection drops. These were manifested by exception errors in database applictions that have worked fine for years. The .NET application exception message: "The specified network name is
  • List Filtering NOT Working
    by PPCUBAN
    2 Replies
    Last post by PPCUBAN
      • I have a Report where i want to show in a DataList only those values Filtered by one of the fields of my dataset. I want to show a Date value ONLY if another column value in that row in my dataset = "IN". But nothing seems to happen here. No records are shown. It's like the condition is never true. Steps: 1. I drag a DataList 2. I drag a DatasetField inside the DataLi
  • Update query
    by Tracy5691
    6 Replies
    Last post by Hunt Tsai
      • Hi! I am very new at writing scripts but I know what I need to do is possible. I would like to create a script that would update a date field in several different sales orders. I don't know how to write an update script that would add today's date in the sales order numbers that are input by the user. Can anyone help me Tracy
  • Extended Stored Proc Works on WIn32 machine but not x64
    by Jacob_g_Smith
    0 Replies
    Last post by Jacob_g_Smith
      • I was wondering if there is anyway to allow a win32 dll to be called from an extended stored procedure on a 64-bit sql machine. The error I am getting back is Could not load the DLL C:\WINDOWS\system32\PBFWSSAPI.dll. Reason: 193(%1 is not a valid Win32 application.). I have the src for the dll if that helps. At the top of the src is #include <PB.h> #include <SRV.h>
  • why is my print preview screen black?
    by JohnSLG
    1 Replies
    Last post by Craig Guyer - msft
      • So in order for print preview to work, one has to change the background of all items on the page to white Is that a bug that is going to be fixed soon (along with running out of memory when you print a big report)
  • Getting Basline Test
    by Anony999
    2 Replies
    Last post by Anony999
      • How do you guys get a baseline test of your database I mean how do you test your SQL database to make sure it is fast enough Also, how do you know that the numbers you are getting back are in fact fast enough I mean is there a gauge that one goes by to verity that an INSERT should take no longer then 'n' miliseconds... How do you guys do it Thanks in advance!
  • KPI Help Required-I want a revenue report with average Daily Revenue
    by winnipeg
    3 Replies
    Last post by Darren Gosbell
      • Hi All, What I am trying to do is create a average daily revenue KPI using vs.net 2005. The necessary fields from my fact table are Revenue and the datetimeID, there will be multiple entries perday. I would like my KPI to check if we are hitting a $10,000 daily average in revenue. But I need to know how many Distinct Days are being calcuated. If I were using regular SQL I could use: COUNT( SELECT
  • reliable Connection with SQL Server
    by MA.
    2 Replies
    Last post by MA.
      • Hi.. I have a SQL Server 2005 Database .. I develop for the customers a C# Application , that sends some specific Information to my central Database. If I would create a connection over tcp/IP (in order to send data to central database) like sqlconnection1.ConnectionString = "Data Source=192.XXX.Y.ZZ,1433;Initial Catalog=Muster;Integrated Security=True" ; it would not be r
  • table field datatype
    by arkiboys
    6 Replies
    Last post by TryingToLearnFromScratch
      • What datatype should I use for a field in my sql server table that should be able to hold values such as: -1.092 0 2.9875645 25436.432567 etc. Thanks
  • Offline cube cannot open
    by grmohan68
    14 Replies
    Last post by grmohan68
      • I built a cube by Microsoft SQL Server 2005 Analysis Services and deploy into the server. The deployment was successful. I extract the cube by Microsoft Excel 2007 to view data. That also successful. Then I built an offline cube from there. I can successfully create the offline cube. And store into a thumb drive and open the offline cube by another pc through microsoft excel 2007/2003 both. I cann
  • get the day from date value in SQL Server
    by MielieSpoor
    3 Replies
    Last post by MielieSpoor
      • Hello, I want to know how can I (in sql server) get the day of week(eg Mon, Tue, Wed, etc) when a specific date is being given to the stored procedure. The day number will also do fine!! In other words...I want to send a date to a stored procedure. Before anything in the sp can happen, I need to know the DayOfWeek the specified date falls on (day number also fine). Once I know the Da
  • Working with the old database for the new site?
    by fire bLade
    4 Replies
    Last post by Michael Hotek
      • I have contracted a webproject to be done. My client allready has a website. I need to create another website that replace the existing one with the new look. This is the problem. The old website has a Database that is associated with user registration & all other data of the company. So, I need to implement the same database to the new website which I am going to develop. In this case, how ca
  • Question about TransactionScope and DTC
    by NightElf
    2 Replies
    Last post by NightElf
      • My Code : Code Snippet using (TransactionScope scope = new TransactionScope()) { using (SqlConnection sqlConn = new SqlConnection(connStr)) { sqlConn.Open(); //throw exception: The transaction has already been implicitly or explicitly committed or aborted //do delete,update } scope.complete(); } My clientsy
  • Really interesting issue!
    by Melih Araz
    14 Replies
    Last post by Melih Araz
      • Hi All, When I wanted to see ONLY today¡¯s records on the sql server, it took 5 minutes. When I wanted to see records including today¡¯s records on the sql server, no problem. ( 19 Sep. is a past date which is working properly) It is very interesting it takes 5 minutes to sort the lastday there is nothing wrong with the other days. I ran DBCC INDEXDEFRAG method but no chan
  • making a view from the other server
    by ashk1860
    4 Replies
    Last post by Satya SKJ
      • hi I have two sql servers in the LAN, one is 2000 and the other is 2005. in 2005 server I have a database and I want to have a view of a table in a database in the other server (2000) is it possible thank you in advance
  • Missing SSAS Diagrams
    by ScottRichmond
    2 Replies
    Last post by ScottRichmond
      • I've created multiple SSAS diagrams and saved them back to the server. The next day, I connected to the server and the diagrams are gone. Rather than recreate all of them, I recreated one and tried saving it back to the server. I get the message stating "updating server", but when I close out and get back in the diagram is missing again. We have so many cubes we really need these so ever
  • Green Bar Matrix =ReportItems!Color.Value ignored
    by IanO
    2 Replies
    Last post by Adam Tappis - IMGroup
      • I followed the instructions and the textbox named Color did indeed display alternate colors on the odd rows. However, when I tried to propogate the color to the whole row using the expression =ReportItems!color.Value for the value of the backgroundcolor property, it was ignored. So I tried some custom code: Public Function GetColor() Dim retValue as String retValue = Me.ReportIt
  • Using the results of a script component
    by Sam_res03
    4 Replies
    Last post by Phil Brammer
      • Hi There, I have to populate data from two oracle databases. I have a list of ids from one table and I have to query those ids in the second table (in a different database) and populate that data into a sql server. This is the approach I have taken... I have populated the ids into a recordset destination. I use a script component to extract those ids (from an object) into an ouput buffer. I
  • system table or user table?
    by Michael Farthing
    1 Replies
    Last post by Arnie Rowland
      • dtproperties appears in Enterprise Manager as a system table, yet sysobjects gives it a type of 'U' for User table (in both of its xtype and type column). As far as I'm concerned it's a system table and I'm trying to exclude it from a query on that basis - is there another place where this distinction between table types is made. Seems to be an inconsistency somewhere! [Server 2000]
  • Help, "The value could not be converted because of potential loss of data"
    by sadie519590
    14 Replies
    Last post by Phil Brammer
      • Hi, I am getting the error below in my Flat File Source. I've seen this error many times before, and have successfully resolved this problem in the past. However, this time it's a little different. It's complaining about row 7 of myFile.csv, column 20. I have column 20 defined as a Numeric(18,6). It also maps to the Price field in the table, which is also a Numeric(18,6).
  • Error with Neural Network Viewer
    by sbowden07
    2 Replies
    Last post by sbowden07
      • I have read the threads regarding the Neural Network Viewer and I think I have a similar problem. I do have Service Pack 2 installed and I'm running the x64 version of SQL 2005. I'm building a model from a single relational CASE table. Granted the table has many columns summarized at the customer level but there are it is well formed and has no NULL values (plenty of zero or blank values