Answer Questions

• M.Hegazy sql server lockup after strange error in log, help please.

  Can anyone help me solve why my server is locking up. We're running sql server 2005 ent on a 2 cpu dual core server. With 3gig. Once each the last couple weeks, the machine has hung and the only thing I can find that's suspicious is on the sql server log.  It's below.  After the excerpt is about 50 more different memory errors.  As far as I know there's no ssl configured for log in, it mostly uses private lan cards fo ...Show All

• GaelFraiteur Get information from sysobjects in another database (CLR, MS SQL 2005)

  Hi All, I've written a scalar function in C# for the MS SQL Server 2005 that has to have access to two databases in one instance of a server ("database1" and "database2"). I got information from database1, calculate the name of the database2 and got information from user's tables in the database2. But when I'm trying to get informatin from "sys.tables", "sys.columns", "sysobjects" I always get ...Show All

• VonSch How to get a row committed

  I have a package loading up rows of employees from an excel file. An employee may be in the file multiple times. The package does a lookup and if not found it inserts the employee. When the employee is found it does an update. So in my file employee A gets added on the first occurrence in the file. On the second occurrence, the lookup does not find the employee and tries to insert a second time and I get a unique constraint. How do I make the ...Show All

• Sowelie Problem in ERD creation in sql server management studio

  I have downloaded adventurework database intall it then configure the databases in managemnt studio and then make a ERD of the db all works fine. Then I have intall asp.net 2.0 starter kits. 1,Club Starter kit 2,Commerce Starter Kit 3,eBay Selling StarterKit 4,Jobs Site Starter Kit 5,Personal Site Starter kit 6,Time Tracker Starter kit install them and configure the databases in managemnt studio.all thing works fine but when I create erd ...Show All

• Dan Jimenez DR for Crystal Enterprise and Business Objects

  Have to build DR solution and subj is a part of it. Maybe some one has done it already… share the experience please. Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is ...Show All

• allears42 Distributed data synchronization - Comparing timestamp

  Hello, I am designing a distributed application where a central SQL Server 2005 database will need to be synchronized with remote SQLExpress databases via a WebService. Data can be edited at the cental db (by our connected applications) or on the local SQLExpress dbs running on the users machines (by this disconnected application). Now, how can I use the timestamp column to determine the most recent update. The most recent update to me is ...Show All

• rigg A Better Way (Complicated Select Statement)

  After hours of trying, I finally got a select statement to return what I needed, but I am not sure how I am doing is the most efficient way. Please give me your input. Here's the situation: I want to allow customers to add to their magazine subscriptions online, so I created an aspx form that shows the magazines they are currently subscribed to and allows them to choose from other "available" magazines. In the available magazines fi ...Show All

• charlie_pike Do Sql supports mutlithreads on triggers?

  Hi all, I have a question Whether Sql supports mutlithreads on triggers. For example: I have a Patient table. When two patient records getting inserted by two different transactions does it trigger the triggers in different threads and execute the code in Insert trigger Or only one row will fire the trigger and the other one won't Thanks Each transaction will fire the trigger. The trigger is in res ...Show All

• Whatonly Strange out of memory error on 2005

  Hi, I am getting the following: spid53,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 262144 spid53,Unknown,Memory Manager <nl/> VM Reserved = 1662084 KB<nl/> VM Committed = 954940 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB ... <lots of memoryclerk/cachestore stuff) ... Followed by loads of 701s (There is insufficient sy ...Show All

• Ravin08 Get Error when install SQL Server 2005

  Excuse me. Can Anyone help me. I have downloaded a try version (180 days) of SQL Server 2005 from Microsoft.com (about 900 MB in one ISO Image) When I install, I get this error : My computer installed SQL Server 2000 Persional before. I tried to setup from every setup.exe & .msi in the install folder on the disk. But cannt.... :( Please tell me how to resolve this problem. Thanks a lot. Sorry for may bed English. I'm sorry, but your ...Show All

• MochaJunkie filtering on dataset

  Hi all! I am trying to filter a dataset. Could someone help me            I only need the last 12 months from the system date. systemDate.field< 12 Months    Anyone have any suggestins Thanks in advance, Kerrie  Sorry about that. I did try to use that just now and I am getting the same results as if that statement was not there. Thanks, Kerrie I am new at this ...Show All

• myeager Error in creating a simple asp.net app similar to sample.net (as2000 samples)

  Hi, I am new to MS Analysis server technologies. I environment consists of: Server: windows 2003 server, Sql server 2005, analysis server 2005 client: windows xp As given by Microsoft, I configured the server for HTTP access. When I try to browse to msmdpump.dll by giving the path " http://ServerName/olap/msmdpump.dll " both in server and client systems I get the HTTP 500 Internal server error. I also did a right-click->browse ...Show All

• Diacono_Frost need help on a query--sequence number

  How to select sequence number (Row ID /number) for a query ROW_ID ID EffDT MonthFirstDay 1 162028 1 11 2 162028 12 123 3 162028 15 567 Thanks You didn't mention the version of SQL Server you are using. In standard SQL, you can do something like: select (select c ...Show All

• apache64d SQL Task - passing parameters

  Hello, I have a SQL task wich executes the following statement on a OLEDB connection (SQL 2005 DB): TRUNCATE TABLE DimTime GO DECLARE @CurrentDate AS Datetime DECLARE @EndDate AS Datetime SET @CurrentDate = '10-20-2003'; SET @EndDate = '10-20-2005'; while(@CurrentDate < @EndDate) begin INSERT INTO DimTime SELECT DATEPART(month, @CurrentDate) AS MonthNumberOfYear ,DATEPART(quarter, @CurrentDate) AS CalendarQuarter ,DATEPART(year ...Show All

• othman_11 Import all xml-Files from a Folder into SQL

  Hello I'm just starting with SQL and BIDS. I have created a xml-Import to SQL Server which works without any problem. Now I like to import (daily) all xml-files of an appropriate Folder at once to the DB. The files will have different names each day. I could not find any help in the internet to solve this problem. Can someone give me an Idea how to import many xml-files out of the same folder to SQL Thanks & regards Chaepp ...Show All