SQL Server

Page 1469




  • Topics
    Replies
    Last post
  • SQL - dosomethingbig
    by dipeshnepal
    2 Replies
    Last post by JohDas
      • Hi All, I have a very simple problem that I guess most of us have but we might tend to igore it. We have a ASP.NET application, once a week we need to call a "create schdule" function from this application. This should have been in off hour process but we were not able to do this because of some business rules. This simply calls a stored procedure that will take approx. 1.5 hours to comp
  • SQL Server 2000 sp4 - Full-Text Seach - Item count 0
    by Arul-R
    0 Replies
    Last post by Arul-R
      • Hi I have been trying to create fulltext search catalog for my database. However, when I finish populating the catalogs, the item count is 0. Apperciate yor suggestions on this Thank you,
  • Operating System Error 1450 - Unable to resize db physical file
    by Imran Shaikh
    7 Replies
    Last post by Imran Shaikh
      • Hi, We have a very severe issue in our production, and this is very very ugent to fix this issue, there was a job started on server on 10th October, 2007, for backup of database of 3.2 TB, which caused this issue on 18th October, 2007. I cancelled that job and even restarted the server, but still there is same issue on the server. I am using this command to expand the physi
  • OLAP Client
    by Ashok Ojha
    9 Replies
    Last post by QDA
      • Upgrading to Analysis Services 2005 has put me in difficult position because of lack of good client from Microsoft and using Excel 2002/2003. We are small shop and use Excel (Pivot Table) big time as client tool. We upgraded to Analysis Services 2005 and we all know on server side it helped a lot. BUT, I was expecting Excel 2002/2003 to work "at least same" even it can no
  • what's the differences to shrink my db?
    by Andre's
    1 Replies
    Last post by WesleyB
      • BACKUP LOG **** WITH TRUNCATE_ONLY DBCC shrinkdatabase (****,10) DBCC shrinkfile (****,10) If shrinking maybe destroy my data Especially like DBCC shrinkfile(datafile,10) thanks
  • Hold group constant across time?
    by Frank2808
    4 Replies
    Last post by Frank2808
      • Hi eveyone, My users asked me a question today that I wasn't sure of so I was hoping you guys could give me some advice. Is it possible to make the cube hold a group constant across time For example, I want to take all of the customers that were here in December 2006 and see how they performed during the year. Is that something I can do in a cube Obviously, I could create a seperate cube
  • Got an error when trying to import multiple tables from one SQL Server 2005 database to another
    by Rucksapol Jiwungkul
    14 Replies
    Last post by jwelch
      • We just upgraded from SQL Server 2000 to 2005. In the past, when I ran the import/export wizard to copy multiple tables from one database to another with SQL Server 2000, I had no problem. Now when I used the import/export wizard to copy multiple tables with SQL Server 2005, I kept getting an error. For example, when copied three tables, the first table might be copied fine and I got an error with
  • How to force 12 rows (1) per month
    by slimshim
    14 Replies
    Last post by rusag2
      • i have a datatable with Part , DateSold,ItemsSold i want to show the sales for the last 12 months by month. if there were no sales for a given month i want the table to show 0. here was my first attemp that only gives me data if all twelve months had sales. SELECT MONTH(DateSold) AS Month, SUM(ItemsSold) AS ThisYear FROM inv_Monthly_Sales WHERE (YEAR(DateSold) = @
  • SSAS Cubes & Dimensions
    by DineshMurali
    7 Replies
    Last post by DineshMurali
      • Hi, I need Small Info: 1. What is the maximum limit of dimensions in a cube 2. if i keep more dimensions in one cube will it effects performace 3. In which way the data comes faster 1. if i keep the attribute directly from the dimenstion to report (or) 2. if i create heirarchy and place them into report 4. i created a cube with 3 dimensions and
  • Query cannot be updated because the FROM clause
    by GerrydeBruijn
    2 Replies
    Last post by Ricky Wen - MSFT
      • Hi everybody, I have a problem. My provider(ISP) is supporting SQL Native Client driver and my forum supplier is only supporting SQLOLEDB. I am trying to access our sql2005 DB located at our ISP. I have changed this line: strCon = "Provider=SQLOLEDB;Connection Timeout=90;" & strCon To: strCon = "Driver={SQL Native Client};Connection Timeout=90;" &
  • adding text to the column data in a query result
    by rknowles
    7 Replies
    Last post by carrie09
      • If I had a table with 3 columns in it, named "ID", "TITLE" and "CLASS_ID" and, in a query result, I wanted to add a fourth column named "URL" that would be the result of concatenating a file name and the value in "ID", how would I do that so a table that looked like: ID TITLE CLASS_ID 1 "Hello" 137 3 "Good
  • SSIS:package contains two objects with the duplicate name
    by anils
    2 Replies
    Last post by anils
      • public static void CreateDestDFC1() { destinationDataFlowComponent1 = dataFlowTask.ComponentMetaDataCollection.New(); destinationDataFlowComponent1.Name = "SQL Server Destination 1"; destinationDataFlowComponent1.ComponentClassID = "{5244B484-7C76-4026-9A01-00928EA81550}"; managedOleInstance1 = destinationDataFlowComponent1.Instantiate(); managedOleInstance1.ProvideCom
  • how to connect from asp
    by Esthera
    2 Replies
    Last post by Hemantgiri S. Goswami
      • How do I connect to sql server express from asp. to sql server I would do as follows but this is not working with sql server express <% Dim objconn ,mserver,dbName,UserID_db, PassWD Dim strCon Set objconn=Server.CreateObject("ADODB.Connection") mserver="iphere" dbName="dbname" UserID_db="login" PassWD="password" strCon="Provider=SQLOL
  • Point in time restore
    by DaPosh
    9 Replies
    Last post by Chris Howarth
      • Is it possible I have no Backups at all. And I dropped a important table completely. Is there anyway to roll back this command. I am guessing that the transaction log keeps this inforation and its still there. I think with other 3rd party tools you can recover to a point in time without backups so there must be a way we can do it without 3rd party tools , cant it
  • discarding rows - best practice?
    by slicktop
    6 Replies
    Last post by Phil Brammer
      • I have a need to filter out certain rows from my data stream. I cannot apply the filter against the source data using my DataReader component, due to some constraints in the source system. Therefore, I must filter the data out after it enters my datastream (trust me on this part). I have created a data flow that uses the Conditional Split transformation to do this. I created one condition that
  • how to connect from asp
    by Esthera
    2 Replies
    Last post by Hemantgiri S. Goswami
      • How do I connect to sql server express from asp. to sql server I would do as follows but this is not working with sql server express <% Dim objconn ,mserver,dbName,UserID_db, PassWD Dim strCon Set objconn=Server.CreateObject("ADODB.Connection") mserver="iphere" dbName="dbname" UserID_db="login" PassWD="password" strCon="Provider=SQLOL
  • How to move the packages To a different server
    by sureshv
    1 Replies
    Last post by Jamie Thomson
      • In sql server 2000 if we need to move a package from one database to another we have to move the package. But is it the same in Sql server 2005 integration services. let me know
  • oracle & SSIS on 64 bit...
    by Vladimir552654
    2 Replies
    Last post by jwelch
      • Hi All, We have 64 bit win 2003 & sql2005 EE sp2.. I managed how to trick VS2005 with Oracle connections and have converted a lot of packages already from sql 2000 to sql 2005(using Oracle connetions as well), now I stack with one oracle connection manager... So just to clarify, we have SSIS on same SQL server installed, as well have this one Oracle server set as linked server(using O
  • deploy pacakge - what files have to go?
    by CSharpCoder
    6 Replies
    Last post by Karunakaran
      • I'm getting ready to deploy my SSIS packages to a real server (woohoo) after testing on my local SQL box. What files have to be deployed to the SQL server I'm creating a folder for each package (easier for these guys to maintain when my contract is up). Does only the .dtsx and .dtsConfig file go or is there any other files that have to be copied over to the SQL server
  • Pull Merge constantly have all the same conflicts
    by MartinLebl
    4 Replies
    Last post by MartinLebl
      • Hello. Let me describe first my replication setup: - SQL Server 2005 SP1 (SP2 coming soon) - Approximately 35 remote users (Salesrep laptop) using Pull Subscriptions - Merge (Bi-Directional) (8 articles - tables only) - Merge (Uni-Directional) (5 articles - tables only) - Transactional (5 articles - tables only) Users receive data based on their territory #, ther
  • Blank password check
    by Alexander Sychev555908
    8 Replies
    Last post by Alexander Sychev
      • Is there any way to check whether the password for existing sql authentication login is blank (except trying to connect) Where can I find information about how the passwords are stored internally in SQL Server
  • Database snapshot
    by cosimog
    2 Replies
    Last post by cosimog
      • I drop and recreate a database snapshot for reporting purposes at the end of a DW loading process. I need to create some indexes to improve query performance. Where I should create the index, on the originale db or on the snapshot db Cosimo
  • Query problem in Microsoft_time_series
    by tina dna
    2 Replies
    Last post by tina dna
      • hello,all: In the process of one of my data mining projects using Microsoft SQL Server2005,i met a problem. I have created a mining model with microsoft_time_series algorithm and have processed it successfully.when i predict the pridictabe column [traff] with the following DMX: select predict([traff],-50,0) from my_model_name and: select predict([traff],40) from my_model_name
  • Handing over SQL Server DB to client company
    by PhillipM
    10 Replies
    Last post by Madhu K Nair
      • I would like to handover a SQL server 2005 database that I've been using for testing/development to a client for use in a production environment. Besides deleting my test records from the database and making a copy of the MDF file, do I have to handover the datase's LDF file too I guess I should also compress the database before providing a copy. Please advise of "gotchas" I should be a
  • Package xml config files used in child packages?
    by CraigL77
    3 Replies
    Last post by jwelch
      • I have a package that executes 3 other packages in it. From the command line I pass in which config file to use (just contains db/seerver) does this setting get carried over into the child packages as well