Answer Questions

• insaned SQL Server 2005 with SQL 2000 Emulation Mode

  I am installing an application that makes reference to "SQL Server 2005 with SQL 2000 Emulation Mode Enabled". But I'm not seeing how to turn this on within SQL Server 2005. Is 2000 Emulation Mode available somewhere Can anyone point me in the right direction Thanks, Derek Perhaps you could use the SQL Server Management Studio if you are using SQL 2005 and Go to the properties of the Database you wish to change the Compatibility to and Go to options under which you would be able to change the Compatibility mode to SQL 7, 80, 90. Hope this will be usefull I expect that they want your database to be in 8.0 Compatibility Mode, and not in 9.0. Here is a way to check....This query will r ...Show All

• Wahl04 Problem with slowly delete many filtered rows in table.

  I use cursor for delete 20 milions rows from one table, but it's very slowly. I want use delete rows in a non-resource consuming manner. I don't need from transaction log, but don't know how turn off it. Please help me! 10x Why are you using a cursor for this Can't you form the DELETE statement into a SET-oriented operation Cursors are going to be much less efficient than a straight-DELETE DML operation. (FYI, TRUNCATE is the only logging-optimized DELETE operation available in the server.) Thanks, --R I use the cursore because i want remove filtered data from this table. I have relation with another table and result to deleted rows is round 21 milions r ...Show All

• canuck81 Publishing a report to the web error

  Does anyone know how to fix this error -I've tried allowing anonymous access to the site. -I've added it to my trusted sites. Error: The request failed with HTTP status 401: Unauthorized.    Thanks. I can view this just fine on my local report server. Why can't I view it through the website that I embedded it into Doesn't make sense. I have my defalut.aspx page authenticated to windows, I have my windows account with permission on the reporting server and my local virtual directory to authenticate with windows integrated security. I also have my web browser to use current log in and password when visiting the site. Why is this so confusing to do The report you are using does not have the correct cred ...Show All

• Sachi_SG sa Password change, fails backups

  i am supporting a instance of SQl 2005. The person here before me gave out the sa Password (PW) to too many folks. I changed the PW last week through the GUI. The application using the db works fine, but it looks like the db and trans log backups are failing. Do I need to change PW somewhere else as well Check the account that is used to start sQLagent in this case, even though jobs are owned by SA as explained you need not update anything on SQL server. Can you: - Restart SQL services - Identify the logon account used by your backup software to access SQL Server. In case it uses the SA account, change the password there too. Alternatively if the problem persists: - Create a new account ...Show All

• pjam cast from float to varchar

  Hi, Can I convert from float to varchar without trunc the values Can I use any mask like '#.##' from -> cast ( 123.44 as varchar(256) ) result = '123.44' thanks, Hi Alessandro, As long as the varchar type you are casting to is long enough, no truncation of the float value will occur. For example, cast(23.444 as varchar(3)) will result in a overflow, where cast(23.444 as varchar(6)) will return correctly. Is that what you meant Cheers, Rob ...Show All

• Deanboy How to relate InstanceID of RunningPackage object to logging?

  Iterating through Running packages as in this code from MSDN: RunningPackages pkgs = app.GetRunningPackages("yourserver"); // Enumerate through each package in the collection and display some data. foreach (RunningPackage package in pkgs)     {         Console.WriteLine("InstanceID: "+package.InstanceID);         Console.WriteLine("PackageDescription: "+package.PackageDescription);         Console.WriteLine("PackageID: "+package.PackageID);         Console.WriteLine("PackageName: "+package.PackageName);         Console.WriteLine("UserName: "+package ...Show All

• AlexBB No more datatype TIME in SQL 2005...what to do???

  I understand that SQL 2005 doesn’t support TIME ( which is, for me, incredibly weird). Now, could anyone please help me solve my problem. I want to make it possible to insert into database a start-time for the first runner in a team. And when he finishes, a finish-time. This finish-time I will also use as a start-time for the second runner....a.s.o. Furthermore I want to be able to get the results from the database to present them in several ways. This also means I can't simply insert the time as a string since it won't change hour at every 60 minutes. I have read somewhere that it should be possible to create own datatypes, but I have absolutely no knowledge to that. Could anyone please help me ...Show All

• S76 Corrupted SQL Files !!!

  Hi: I try to run VB2005 Sample101, "Using Datagridvies" with SQL Express, Here is what I got !" "One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. if this is an existing database, the file may be corrupted and should be restored from a back up. Cannot open use default database. Login failed. Login failed for use 'XXXXXXXXXXX\Administrator" Lof File 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Data\AdventureWorks_Data_Log.idl' does not match the primary file. It may be from a different database or the log may have been rebuilt previously." Then I re attached the Database again. Still ...Show All

• EmekaAwagu constrained flag in the STRTOSET function violated?

  I get this error when, i try to set a parameter for user input, it doesnt matter what i type in, it says this: <<Query (1,408) The Restrictions imposed by the constrained flag in the STRTOSET function were violated>> what exactly does this mean and how do i fix it My parameter is for dates, but i have the datetype set to "String", when i change it to" DATETIME" , i get the same error when i select from the calendar. So far the only date option that is working right now. Is a long drop down list, that could go for days at a time. I just want users to be able to input dates, such as "Jan 9, 2000" or 10/10/1999. What can i do about this Hi, ...Show All

• AdelioStevanato Calling debugger from SSMS

  I realize that the DEBUG capability has been removed from SSMS and moved to the IDe for Visual Studio. As much as that annoys me , I am dealing with it. Is there a way I can open a SP into the debugger from SSMS I very much miss the ability to right click a SP in my list of 300 and choose form edit, run or debug. I dont care if hte debugger is a separate app, can't I have SSMS send my proc to the visual studio debugger Currently I have to open the VS app separately, and then establish connection, and the re-fnd my proc in that very long list of 300 that is in there. Hi, I tried to configure t-sql debugger in my visual studio 2005. I have sql server 2005. I somehow unable to debug the store ...Show All

• venup HOWTO disable package start / finish events in eventviewer

  hi all, i searched and all i found is questions, not answers. maybe it's a silly question, but i really can't find any documention / posts about this. i have a scheduled job in sqlagent that executes a SSIS package that runs every minute. As a result, my application log in eventviewer gets filled very quickly. i tried using "/REPORTING E" option with no luck. i tried enabling logging on the package, and then select only the OnErro Event, no luck. does anyone have this problem does anyone have a solution TIA Luis Azedo wrote: Thanks for the reply. i know that Logging is very configurable, but, where can i configure in order that star ...Show All

• Chris Honcoop Could not Authenticate with SQL Server

  Here's my situation and I've spent enough time to troubleshoot. Any help would be appreciated. 1) I have a VB.NET Windows Form Application that uses SQL Server Express 2005 database. 2) The "mdf" file is a part of the application itself. 3) When the application distributed to my clients using Windows XP SP2, the "Click Once" installer automatically installs SQL Server 2005 Express [which is a pre-requisite] and copies this mdf file into the application folder. 4) The authentication mode is "Windows Integrated" The problem is, when the application is launched [while logged in as the local system administrator in a given computer], it is unable to connect to the SQL Server. I get the following error, Failed to generate a user instance of S ...Show All

• FinnErik problems testing db restore, file based backups

  I'm trying to test out a restore scenario for a large database. It contains several files, each one is backed up when we are finished inserting data into it. No changes are made to the data after insert. All changes happen in tables in the primary file group. So, I backup the primary file, the log, the first "partitioned" file, the log, the next "partitioned" file, the log, etc, etc, etc. Now, I delete one of the tables residing on one of the partitioned files and want to restore it. For arguments sake, let's say I have a primary file, and 5 partitioned files. I delete the table which was on file 3. I'm having trouble wrapping my head around the steps to restore under these circumstances. I thought I understood it ...Show All

• abowman Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• sudhirvn Having Problem with Report Parameters

  i am trying to generate a report based on 3 parameters age, location, ethnciity every thing works fine in data and layout tab, when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time. i tried executing the query in data tab, it takes less than a sec. any ideas am i doing somethign wrong in parameters any help any one have an email id of any of the webcast instructors who have instructed for RS before... What happens when you take the statement from the profiler and run it in a new query window. Does that e ...Show All