SQL Server

Page 4211




  • Topics
    Replies
    Last post
  • Restarted SQL Server 2005, and it's working great now, but WHY??
    by dvang
    3 Replies
    Last post by WesleyB
      • My small business has about 21GIGs of data in our database. This entire week we've been running absolutely slow. Posting transactions have been taking up to 30+ seconds when they're normally instant. We ran the profiler and found that certain stored procedures were taking an absolutely long time to run. We checked for fragmentation, indexing, etc. Keep in mind our hardware was constantly pegged at
  • Unpivot Transformation and Expressions
    by Lawrence Parker
    7 Replies
    Last post by Lawrence Parker
      • I am using the unpivot transformation, but I can't figure out how to use an expression in the Pivot Key Value. The denormalized table I want to unpivot has columns like Sunday_Qty, Monday_Qty, Tuesday_Qty, etc. Just before the unpivot component, I inserted a derived column component that adds fields like DateSun, DateMon, DateTue, etc. that resolves to values like 01/07/2007, 01/08/2007, etc.
  • Oracle odbc driver on windows 2003 64 bit, SQL Server 2005
    by Fari
    14 Replies
    Last post by Alaa AlDahdouh
      • God morning! I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases. - I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange! - I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data s
  • Partitioned View Pruning Issue
    by DejaVudew
    9 Replies
    Last post by DejaVudew
      • I'm using Sql Server 2000 Standard Edition, service pack 3. I'm fairly new to partitioned views and merge replication. We have a 3-year set of monthly tables with about 1 million rows per table from some code we inherited. To ease development , I'm trying to create a local partitioned view. We wanted it to be UPDATE-able and be able to select data by a date range or by id without incu
  • Backup on remote disk
    by FlexibleGenius
    2 Replies
    Last post by Robert Varga
      • hi gurus, can any bdy tell me the procedure to create the Backup Device which is a DISK OF REMOTE PC.. i want to take database backup on remote pc's disk not on local disk or tape i am using sql server 2005 thanks in advance
  • Insert failure while using ForEach Loop + Execute SQL task.
    by A.W.M.
    9 Replies
    Last post by A.W.M.
      • Hello All I was trying to insert some row from one table to another of different database. I was using Execute SQL task along with Foreach loop container. In my execute SQL task I am using this query SET IDENTITY_INSERT dbo.Table1 ON INSERT INTO dbo.Table1 SELECT * FROM DB2.dbo.Table2 WHERE TableKey = When executed I get this error: failed with the followi
  • statment completion in vidual studio 2005
    by hbm_7052
    2 Replies
    Last post by hbm_7052
      • i'm using vs 2005 pro edition i try to enable the statment completion in option menu i try this path (otpton ->text editon->sql script ) but statment completion is grayed i can not check this part how i must do to enable it thank a lot
  • How to count no of items in nested table
    by Popoxinhxan
    5 Replies
    Last post by hunchback
      • I have the following table Region Table ID ParentID RegionName RestaurantTable ID RestaurantName RegionID What i tried to do is count the number of restaurants by specific regionname. My current query is Select RegionID, RegionName, count(*) as RestaurantNo From Region Inner Join Restaurant On Region.ID = Restaurant.RegionID However I only get the
  • sp_sidmap alternative in sql 2005
    by Dan Holland
    2 Replies
    Last post by Dan Holland
      • I use sp_sidmap in SQL Server 2000. I changed from sp_change_users_login because sp_sidmap handles both standard and windows logins. In SQL Server 2005, sp_sidmap is gone and I see threads saying you can't add it. Do you know of an alternative to sp_sidmap in SQL Server 2005 so that I can automate the relinking of users to both standard and windows logins when copying databases across serve
  • copying and pasting cubes
    by Liatush
    1 Replies
    Last post by Darren Gosbell
      • Hello, I was copying and pasting cubes (sql 2000) today--- Like I have done several times before.. And I got this error: Unable to set new aggregation prefix for at least one partition. Please change these manually to avoid conflicting aggregation tables. What does it mean How can i fix it Thank you, Liat
  • Group Total Summary Help
    by Simone530559
    9 Replies
    Last post by Simone
      • I hope someone can help me with this one. I can't seem to find a way to solve my problem. I am converting a report from Crystal to RS. In Crystal I am using global variables to keep track of group totals for a final summary. I need a similar result from RS. Data example Group A PK Field Summary Data Field 1 250 2 300 Group A Tota
  • Can't run the scheduled SQL Agent Job?
    by Mapperkids
    4 Replies
    Last post by Laurentiu Cristofor
      • Hi, I'm tried to run the job that created from maintenance plan. It fail and give me the following message: [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin) We are using the Windows Autheniciaton mode only and my id is set as sysadmin, setadmin, processadmin in the server roles.
  • urgent server installing problems
    by Hsoros
    5 Replies
    Last post by Samuel Lester - MSFT
      • hi, i need help here, plz, problem is that eveyr time i try to install sql server 2000, it doesnt allow me to install server version instead tells to install client only, and even during the installation phase when i need to check wht i want to install, the option for server and client is restricted, .. so any one can help whats the problem and how to solve it and install sql server 2000 on my
  • Commit Error
    by GlobalArchitectI
    2 Replies
    Last post by GlobalArchitectI
      • I have an SSIS package that iterates through a thousand or so download text files, parses them and inserts the results into a database via a Stored procedure and an OLE DB Command. For the most part this process works without any issues, yet I keep obtaining random errors on a DT_STR (500) column. I have reviewed the data extensively and this column - which is the same across all of the rows - doe
  • Snapshots - not having to create them
    by Ants Hurdley
    3 Replies
    Last post by Ants Hurdley
      • Hi I am creating a full Merge replication setup between two servers Is there any way that I can set it up so that I do not have to create a snapshot. Ie I would gurantee that the data and structutre is EXACTLY the same on both the subscriber and the publisher. The problem is that my data base is over 4GB and it is quicker for me to get the data from one server to the ot
  • error using default value property in table column properties (mssqlserver sme)(mssql2005 express)
    by moralesramon
    3 Replies
    Last post by moralesramon
      • I'm trying to set the NOW() function as default value property of a table field (datetime type) but I'm getting the folowing errors: error validating the default for column 'optime' 'NOW' is not a recognized built-in function name i used now, now(),NOW,NOW() as default value property sorry 'my bad english'
  • Passing value from a child Package to the Parent package that calls it in ssis
    by smathew
    5 Replies
    Last post by smathew
      • hi, I am interested in Passing value from a child Package variable to the Parent package that calls it in ssis. I am able to call the Child package using the execute package task and use Configurations to pass values from the parent variable to the child, but I am not able to pass the value from the child to the parent. I have a variable called datasetId in both the parent and
  • Using SQL Server Destination adapter with SQL 2000 database
    by Sayan Ghosh
    1 Replies
    Last post by DarrenSQLIS
      • It¡¯s always said that using the SQL Server Destination adapter is much faster when loading data to a SQL Server database. My question is, if I have a SQL 2000 database, can I still use the SQL Server Destination adapter, or is it only for SQL 2005 db Is OLE DB Destination adapter my best bet My data files(flat files), SSIS package and destination SQL 2000 db are all in the same physical server.
  • using trigger to insert data to different server database
    by XeonYK
    2 Replies
    Last post by zuomin
      • i have 2 server named A and B in A server have database server and B have database server in A have database named A1 with table TA1 and in B have database named B1 with table TB1 i want if i insert data into database A1 table TA1 in server A, database B1 table TB1 in server B will insert the same data to how can do that with trigger or other ways thx u
  • Error 26 on a local machine
    by Anthony P.
    3 Replies
    Last post by Anthony P.
      • I am getting the "Error Locating Server/Instance Specified" message. The part I find most confusing is that I am connecting to my database locally. I have read the recommendations on the blog posted here: http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx and implemented them to no avail. The confusi
  • Period over Period
    by David C Baldauff
    6 Replies
    Last post by dcb99
      • All, I need to find a way to do a period over period calculation which works with any member of my time dimension. So, basically I want to be able to pick like q1 07, or 07 or 1-1-07. And in each case the period over period calculation should work just as well. Furthermore, I have the added requiremment that I need to be able to specify an arbitrary range as well so like the first 45 days o
  • Virtual Address Space very large
    by FHJJr
    1 Replies
    Last post by Ron D.
      • When I run dbcc memorystatus on my SQL 2005 Server under Memory Manager I get: VM Reserved 33610144 VM Committed 1478012 Doesn't the VM Reserved seem really high Is there a way to force SQL to release the VM Reserved memory
  • Parent Package Variables and SQL Package Store
    by Eric Wisdahl
    13 Replies
    Last post by Luis Simoes
      • Hello All, I have a Master Package which calls a group of other packages out on the SSIS Package Store using parent / child and a number of variables. These seem to work when passing various audit information (audit key, record counts, etc) but when I try to pass a variable for the connection string and assign it via an expression to the connection manager, I get the Master Package writing to t
  • Select Stament Help
    by Jorge L Nieves
    2 Replies
    Last post by Waldrop
      • Hi: I need help to make a query to relate diameters reading at a specified time to specific alarms at a different time but whiting 15 second of difference. I.e. for every alarm event I want to now the diameter values during 15 seconds before and after time frame. Any help will be appreciated. Table Diam tsTimeStamp rDiameter 1/10/2007 8:05:45
  • Update data on SQL2005 linked servers to DB2
    by Jeff_Teo
    2 Replies
    Last post by Jeff_Teo
      • Hi all. I need your help. I create a linked server on SQL 2005 server using IBMDA400 as provider. I create a VBscript to update some data on DB2, and issue begin trans and commit trans. Kindly refer to below code. --------------------------------------------------------------------------------------------------------------------------------------------------------------