SQL Server

Page 4939




  • Topics
    Replies
    Last post
  • The specified package could not be loaded from the SQL Server database
    by Harsh567960
    6 Replies
    Last post by Alexander Blood-Wand
      • Hi all, I have created a dts on my Sql server. which gets the data from my log file and insert into my sql 2005 table. In dts i am using 'Flat File Source' and 'SQL Server Destination'. When i execute this through 'SQL Server Business Intelligence Development Studio' it works good. But when i execute this through my c# code from my web server, it throws me an error 'The specified package cou
  • VS 2005 standard prevents using free SQL Express functionality?
    by Stampede2
    5 Replies
    Last post by Michelle Alexander - MS
      • Hi, *relative newbie warning* I use Visual Studio Standard edition with the built-in version of SQL Server. Now I chose a new image catalogueing app, IDImager, that uses SQL Server Express to store photo info. The idea is that I can use the database also with my own code, or transfer the data to another app/database in the future if necessary. IDImager needs SQL Express with the 'connecti
  • Joining mdx results
    by David C Baldauff
    12 Replies
    Last post by dcb99
      • All, I have two separate mdx queries I want to run. I need to be able to specify a date range for each using the range operator ":". The measures will be the same, just different date ranges specified. I want to take the results of each mdx query, and then join them together, so that I end up with a single result, but the measures from date range 1 in one column and the measures f
  • import data from excel data sheets
    by KRISTER
    6 Replies
    Last post by KRISTER
      • Hello A problem with my replication system as occured. I have a working SQL server that can do replication trough internet, everyting works The problem is when I try to import large amount of data (10000 rows) to my database on the SQL server the subscriber on my client don't get the rows. That will say imported data is not being replicated. only rows that i have manually inser
  • How to display column from Inserted table
    by shahrul
    11 Replies
    Last post by Naomi Nosonovsky
      • Hi all, I have created a trigger in SQLExpress which looking for any insertion to a specific table in a database: Create Trigger Tg_Insert on [tablename] FOR Insert AS Select * FROM Inserted --------------------------------------------------------- Assume there is nothing wrong with this trigger as I have already checked the output with Query tool. My question is how can I display the newly inse
  • Last working day from last year!
    by PedroCGD
    14 Replies
    Last post by PedroCGD
      • Dear Friends, How can I retrieve the last working day from the currentyear-1 Thanks
  • Check data changes in table
    by wdk
    2 Replies
    Last post by wdk
      • Hi all! I need to check data changes in some tables from specified date. Can it be done without triggers for each table SQL Server Management Studio always says "Data was changed" if another user updates data and you try to update old version. How it checks data modification date I found only this: USE [ScheduleDB] GO SELECT * FROM sys.objects WHERE object_
  • Get certain raw row from table
    by America
    10 Replies
    Last post by America
      • Suppose I have a table with 100 records.. and I wantto get the 3rd record from that table. How can I do it
  • SQL Server 2005 Service Pack 2 -- Now Available
    by Paul A. Mestemaker II - MSFT
    7 Replies
    Last post by Satya SKJ
      • SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005
  • SQL task works running the package but not when called via C#
    by Brian E. Parker
    5 Replies
    Last post by Brian E. Parker
      • This should be a very easy question. I'm trying to develop an SSIS package that will eventually do many things, but I can't get it to do very basic things. My current test package has 2 tasks in it: 1) File System Task ( FST ) 2) Execute SQL Task ( EST ) When running just the SSIS package via the VS2005 IDE ( as startup project ), everything works fine. The FST moves a f
  • MDX throws error after server upgrade
    by CodeKracker
    0 Replies
    Last post by CodeKracker
      • Hi all, I deployed the "Adventure Works DW Standard Edition" cubes on my machine and I wrote the following simple MDX : MDX 1 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany], [Product].[Category].&[1]) } on rows
  • System.Data.SqlServerCe
    by ANGanley MCSD
    1 Replies
    Last post by Jens K. Suessmeyer
      • Sorry being a little vague but if you can point me in the right direction. I have just created a new VB ¨C Windows Mobile 5.0 pocket PC ¨C Device Application. (which will be connected to a PDA) Do i have to use System.Data.SqlServerCe or System.Data.SqlClient to connect to my db.
  • Cant get Access Database Synchronizer set up on client machine
    by mhawb
    4 Replies
    Last post by mhawb
      • I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation. His "Computer Name" as it's stated in his 'My Computer' properties is " PAVSGP024FE.NWFSC.NOAA.GOV " However his Access.MDW File is located in the directory &q
  • SQL Server slower after 2005 upgrade
    by Michael Lutz141607
    9 Replies
    Last post by rafiq_hay
      • We have an extensive stress test for our OLTP application.that runs slower after upgrading to SQL Server 2005. We have done the following: - applied SP1 and SP2 - updated statistics (sp_updatestats) - recompiled all stored procedures Some behavior we notice in Perfmon over the course of the 1-hour test is: - Average CPU Utilization is up from 22% to 32% and we're try
  • Filtering on a part of a field - 3
    by Cactus77
    4 Replies
    Last post by Jarret
      • Hello, new question about an old topic ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1232451&SiteID=1 ): I want to set a filter on a field, but the it must set a filter on a part of the field. I think it will be more clear with an example: I have a list with ItemNumbers and ItemDescriptions. ItemNo ItemDescription 1 Pineapple yellow 2 Cauliflower size 6 3
  • Multi-user access through a data-access layer/remoting server
    by cp.net
    3 Replies
    Last post by Jeff Wharton
      • Hi guys, I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time. I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on: - The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. Bu
  • How To Connect From SQL Server Database To Another SQL Server Database
    by Rgoal
    5 Replies
    Last post by Rgoal
      • I want to be able to access a table from another server for example using a stored procedure: I am in server A I want to do a select in a table (dbo.test) that is located on server b. so how can i connect to server b using windows authentication then access the table dbo.test thanks
  • How to create Vertical Partioning
    by TJ_1
    3 Replies
    Last post by Gary Chen
      • Hi All, I setup a Transactional replication between SQL Server 2000 and SQL Server 2005 via wide area network . The intial snapshoot failed because run into problems on a table with column 379 columns. How do ceate Vertical Partioning a table on Publication Thank you. TJ_1
  • xp_smtp_sendmail
    by Subeesh
    3 Replies
    Last post by Satya SKJ
      • My DTS program requires an email functionality. But I cant use xp_SendMail , its already configured to use for some other purposes. Then I came to knew about master.dbo.xp_smtp_sendmail, but my problem is its not executing (giving a procedure not found message). What may be the possible causes How can we able to rectify it Thanks in advance
  • Error Message Text in Multi Languages
    by Bhudev
    4 Replies
    Last post by Bhudev
      • Basically I am making ETL Project in which there is need to display Error Message in Multi Languages e.g.: US English, Japanese. User may have option to see Error Log Table in Japanese or US English, so I was working on it and found solution is below Sample Code, in which I¡¯m checking same validation twice first for US English language and second for Japanese language. I feel it will take little b
  • Copy Folders and Files to different location
    by Bader Cheema
    1 Replies
    Last post by jwelch
      • I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location. e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder Does any one know the best way to do this in SSIS Thanks in advanc
  • Permissions to view Stored Procedure Property
    by hayward_ke
    6 Replies
    Last post by hazarder1980
      • My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security.
  • data file blanks to nulls
    by sadie519590
    14 Replies
    Last post by sadie
      • Hi, With DTS, the default behavior is to import blanks ("") in a data file as nulls in the table. However, in SSIS, the default behavior is to import blanks as blanks. I need to ensure that the packages I'm migrating import the data in the exact same way. I am wondering what is the easiest way to convert blanks to nulls Right now I'm using a script to convert
  • Send an email on non-fatal errors from Data Flow
    by Sandy F.
    5 Replies
    Last post by Phil Brammer
      • Ok, I'm incredibly new to all of this so please bear with me. I took the Integration Services tutorial, and that's pretty much all that I have done. I'm creating my first package and I want to be able to email myself when certain non-fatal conditions occur. I still want the entire row to flow into my table. My understanding is that this type of checking should be done in the "D
  • Service Broker "TO service could not be found" Message origin: "Transport"
    by Anonymous558364
    8 Replies
    Last post by Anonymous
      • I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: