Answer Questions

• Brian DeKorte Disconnecting from engine does not closes database

  I connect Managment Studio to MSDE 2000SP4. Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use. In older version collapsing DB objects in tree closes DB. I don't need detach database. Autoclose is a DB property (must NOT overrides by SSMS) and it's "TRUE" ...Show All

• Che2Palle Issue incorporating third parameter in report

  I'm having issues incorporating a third parameter into my existing 2 parameters.  I currently have them all defined and referenced in all queries, but the problem is with the criteria I think.  I  can get 2 of them to work together either 1&2 or 2&3 (by removing the other one), but not 1,2&3 at the same time.  I'm using or conditions.  Is there something I'm missing   thanks. Like I said all my datase ...Show All

• SD_Stu Linked servers and Windows Authentication

  I have seen similar questions, but none of the answers have solved my problem. I have several SQL2000 servers running under Win2003. In the past, we have been using SQL logins, but I have been trying to transition to using Windows Authentication. It has been working great except that sometimes queries using linked servers fail. The linked servers are set up for the connection to use the login's current security context. For testing this ...Show All

• Ean L. Towne OLEDB provider error.

  Hi: I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this. OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.". Msg 7373, Level 16, State 2, Line 1 Cannot set the ...Show All

• Michael Norton FMTONLY, LONG Running ?

  Hi There I have been running a trace for long running queries. I know what FMTONLY is, simply returns the metadata of the query. I have found something odd. SQLBatchComplete:SET FMTONLY ON SELECT SETID,FFIG_FIGURE_XX,(CONVERT(CHAR(10),EFFDT_XX,121)),EFF_STATUS_XX,FFIG_TYP_XX,PRCSR_CLASS_XX,SQL_SEL_TXT_XX,RUN_SEQ_AVAIL_XX,DESCR_XX,FFG_COLUMN_XX,FFG_VAL_COL_XX,LASTUPDOPRID_XX,LASTUPDDTTM_XX FROM PS_FFGDFN_XX_VW SET FMTONLY OFF. This performs 0 rea ...Show All

• Can1 Failed to access IIS metabase

  I installed Report Services 2005 on XP Pro, and when trying to access the http://localhost/Reports directory, I receive this error: The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/ kbid=267904 . I ran the aspnet_regiis –ga <WindowsUserAccount> , still nothing.  I went in to ...Show All

• crixxxx87 Division Problem

  Hi there, I need some help on a query I'm trying to build. I have two columns, one has the current months value and the other has the previous months value. I only want to select the rows where the previous and current values differ by more than 10%.  The problem I have is that some of the rows have values of 0. Any help is appreciated Thanks for the reply. I have, however, simplified the problem somewh ...Show All

• RichMill Store images in db or in file system.

  which is better, storing images in database or storing it in the file system (saving only the path of the images in the database). Hi, that is (and I don’t hope that you started it right now) a religious war. I think files have to be stored on the file system (unless WINFS is launched). If you want to fulltext index them and search them though the database then you’d better store them in the database and keep u ...Show All

• Miles Thompson Problem getting SQL Server Express Service to Start

  I have had SQL Server 2005 (Full Version) installed along with SQL Server Express and suddenly SQL Express quit starting and will not start manually. I have reinstalled VS 2005 (Team Edition for Software Dev) and tried to reinstall SQL Express but the installation fails when it tries to start the service. Any suggestions Keith When the server quit starting and repairing visual studio didn't help, I removed the following registry entri ...Show All

• jose rivera wmi event watcher task

  hello i would like to know how i can retrieve the file path+name of a file detected by the WMI Event Watcher task, so that I can assign this to a variable for an Import task thanks darren i eventually found this tutorial on using the FileSystemWatcher in VS 2005 http://www.geekpedia.com/tutorial173_File-monitoring-using-FileSystemWatcher.html It describes how to build a file monitoring app , ...Show All

• Xzion 101 convert does not convert?

  Hi, I am trying to convert a datetime to a date and get a rid of the time or set it to 00:00:00. I use the convert like BOL says will trunc the time, but it does not. I must miss something. See example bellow. The first formula should trunc the datetime as per BOL but it does not so I have to use the second formula which I feel is somewhat bad even if it works. I have the same problem on both 2000 and 2005. I am sure I missunderstand somet ...Show All

• Johnny Bug Best way to implement external Log file

  Hi, I am developing application for our clinet. some of requirements are system failure scenarios. SQL Server is generating numbers for items inserted in some tables ( something like "oridinal number / year". logic for this is specified by my client and is somewhat complicated ) . most important requirement is to have external( usb stick on the server for example ) log file with latest numbers generated so that in the case ...Show All

• Gary Yukish Restore a database from Yukon to SQL 2000 SP4 edition?

  Hello, I have a siuation that need restore a testing database that currently running on Yukon server to SQL 2000 SP4 staging server.  I am getting an error when I go with filelistonly option to see if its possible. ### Error Starts ### Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 603. The server supports version 539 and cannot restore or upgrade this database. Server: Msg 3013, Level ...Show All

• Chad Scharf alter column b/w desired column

  if i have structure of table like a,b,c,d,e column then i want to alter one more column x b/w b and c column, so that a,b,x,c,d,e Do you need to add the column to the table or do you want to do something with the records ALTER TABLE testTabelle ADD x NVARCHAR(20) I don't know if the position of the column could be defined but is it really needed You can always define the position on quering: SELECT a, b, x, c, d, e FROM testT ...Show All

• Craigster SQL Server 2005 Express SP1

  Hi, I have install Visual Studio 2005 Professional with SQL Server 2005 Express. Kindly advise how to identify if I am having SQL Server 2005 Express SP1 CTP is also installed in my PC. MSDN web provide link to SP1 with CTP. Filename: SQLEXPR.EXE. Is this the SP1 file Rgd Hi, Thanks for yr mail. My current version is 9.00.1399.00. When I try to upgrade to SP1 with SQLEXPR.exe, its say the version are the ...Show All