Answer Questions

• fenrir Can I use AMO from .net 2003?

  I'm working with SQL server 2005 beta 2 from C# 2003 I want to know if I can somehow work with amo I would really appreciate any kind of sugestion AMO (Microsoft.AnalysisServices.dll) is built and works with .net framework 2.0, so you will not be able to use it with Visual Studio 2003 (that uses .net framework 1.1). SQL Setup 2005 install .net framework 2.0, so you can build AMO applications fro ...Show All

• pumaken68 How to: Query Time only?

  Hi, I would just like to know if there's a simple way of querying a time disregarding the date. I mean, I want to query all employees that spends time on the office after 5pm. I don't care about the date, I just want the time... Im currently achieving this by using DATEPART function and concatenating it to resemble a time. Is there a shorter way of doing this     cheers, Paul June A. Domag Here is an example: select convert ...Show All

• iknowstuff How to backup a database to a network drive

  It is OK to backup a database to the local drive (C:) on SQL Server 2005. But when I tried to backup a database to a mapped network drive (N:) on the server,  it failed. Here is the message: System.Data.SqlClient.SqlError: Cannot open backup device 'N:\db.bak'. Operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo) The network drive N: is accessible through Windows Explorer.  Currently, we ...Show All

• JPNMN MS SQL Server Run time Error

  Hi We are using MS  SQL Server 2000 as back end database for our application. It was working fine certainly we are getting Run time error while try to open this application through front end. The Error number says that the SQL Transaction Log file is file . find belo the error Thanks in advance. S Kaliyan I think I missed the error in the post. If this is still unresolved can you resend with the appropriate er ...Show All

• vighnesha Lookup task with NOLOCK

  I have an SSIS package that unpivots data - each row from the source becomes 20-24 rows in the destination db. In the dataflow it looks up some type-data IDs before inserting into the destination table. The whole process flies through the data at an incredible rate, however I find that the final commit on data insertion takes a very long time, and two of the lookup tasks remain yellow throughout. It appears that there may be a contention issue b ...Show All

• markco Does anyone from MSFT monitor this forum anymore?

  Most if not all other forums that I participate in include responses from people in QA and or the respective product group.... Several posts here have gone unresolved for weeks and I was curious as to why someone from MSFT hasn't attempted to respond. Thre are times when the only answer or resolution to a question or problem require inside information. Chris, Your complaint duly noted. We've been a little b ...Show All

• Euan Garden Proxies in NT4 domain

  I am unfortunately in an NT4 domain. I am trying to use proxies for jobs but its failing with the following errors SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.55.250.67] followed by Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.55.250.67] I assume this is a Kerberos iss ...Show All

• anonjj IN Parameter

  Hi, I'm trying to do this in a stored procedure: select * from planning where userid in (71,97) I want to make the userid's dynamic. I've tried this: DECLARE @userid varchar(40) set @userid = '71,97' select * from planning where userid in (@userid) But then I get the message: Syntax error converting the varchar value '71,97' to a column of data type int. How can I do this Thanks Well, you ...Show All

• vb6newbie Problem installing SQL Server 2005 express, In windows 2000

  I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest. The error log is as shown: Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006 Process ID : 1008 e:\469a4a9ba4bfdc9d2db501289fb676\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/4/5 21:34:50 Complete: ...Show All

• YMW DTC & TIP

  hi..i am trying to see TIP communication using MS  DTC sample applications (dblib: equipped with SQL Server 2000) between w2k & w2k3.             | w2k |------------------| w2k3 | My query is abt TIP...i couldn't find any check box or option to "Enable TIP" in Win2000. How can i enable TIP and see packets between w2k & w2k3. At the moment i am using dblib sample applicatio ...Show All

• James_Steven Best way to prevent multiple notifications for an event

  I am setting up a notification system using the SQL Event Provider, and I have a question about preventing multiple notifications for a single event. The events are provided from a SQL select, and the notification emails are sent once a day. How does NS decide if it's already handled an event If I change the email frequency, do I need to add a check in my SQL select, or does NS handle this Thanks Erick Chro ...Show All

• Harish Ranganathan about bcp

  Hi all, I would like to know about bcp. The input file (in parameter) must to has \t to separate the columns Is there a way to choice the separator simbol for example the file: 1;Test1;active; 2;Test2;active; 3;Test3;inactive; Yes, there is a command-line parameter "-t" which can be used to specify a field terminator. See Books Online for more details on the command-line options of BCP. http://msdn2.microsoft.com/en-us ...Show All

• JIMMY-D- Is it easy to upgrade from MSDE to Full blown SQL v2000

  Hi,   Noob here.... Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it. Also, don't remember getting a keycode with the CD - is this right   Thanks for help :) Kenny (bump)   anyone ...Show All

• ReportGuru How can I get the actual line number from inside flatfile sources for each record?

  hi all, maybe this is not a serious problem, but I tried for days to come toi a solution without success. My Problem: I have have several flatfile sources I need to import into a sql-server 2005 DB. It is very important for me to have the original line number from inside the source file for each record. The rowcount transform doesn't fit in for this task, because it accumulates all rows until the end of the dataflow. I tried s ...Show All

• SelfishGene Getting error "Not enough space on drive c:\" when I install SQL Eval2005 on XP(sp2)

  I keep getting that error, yet I have 180GB of space. Is this because my drive is FAT32 and not NTSF (Help) There was an issue in SQL 2000 where if the free space on the disk was an exact multiple of 4gb, you'd get this issue...workaround was simply to create a dummy text-file or something that was a 101 mb in size or something so the free space wasn't a multiple of 4gb...see this KB: http://support.microsof ...Show All