Answer Questions

• skuehner recovery a SQL Server db from mdf/Ldf files

  hi to all, I'm newbie with Sql Server, I've a serious problem. After a crash of one of my disk I loose all the data about the SQL Server db but I've the mdf and ldf files because were placed on another hard disk different from the SQL Serve Installation disk. I reinstalled the Sql Server (in a new path, a new hard disk letter) but I don't know how to rebuild the db starting from the mdf/ldf files. Is it possible Please help me, I'm in a ugly Situation. Open Books Online. Do a search for Attach. It will have instructions and sample code. What version are you using...SQL Server 2000 or 2005 If you can access the mdf/ldf files, simply doing an attach will do the trick ... sometimes can you teach me how to at ...Show All

• Joe H Catching DML statements by A specific application and emailing all identiy info and T-SQL String

  I would like Create a DDL trigger that would intercept all delete,updates,and inserts by a specific application. Than send an email to me about the : user name application T-SQL statement executed The problem I am having is I can't create a DDL trigger for Delete,Insert, or Update statements. Delete, Update, and Insert are DML operations, not DDL operations. You can write DML triggers for these operations. Thanks Laurentiu Do NOT write send emails directly in the trigger, triggers behave synchronously, slowing down your processing time causing error if e.g. the mail service is down. Better write the events to a separate table and send them using a job (or something like this). HTH, jens K. Suessmeyer. --- h ...Show All

• GroZZleR Report Server (MSSQLSERVER) cannot connect to the report server database

  I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error: Message: An error occurred during rendering of the report. ---> An error occurred during rendering of the report. ---> An error occurred during rendering of the report. ---> An error occurred during rendering of the report. ---> Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Stack Trace: at System.Web.Services.Protocols.Soap ...Show All

• russlunn SQLServer dll's disappeared

  When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:\ProgramFiles\Microsoft SQLServer\90\SDK\Assemblies:  .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more.  How can I re-install these   Are they in the SQL kit, VB, SDK Any help would be appreciated.          If you need the SMO package and in common the feature pack you can use the following link: http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Jens - Thanks Very M ...Show All

• Sab2 Plug-in algorithm in data mining using sql server 2005-- modification for association , classification??

  managed plug-in framework that's available for download here: http://www.microsoft.com/downloads/details.aspx familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en#DMAPI . This package includes the source code for a sample plug-in algorithm written in C#. in this source code all .cs files are modified for clustering algorithm if my plugin algorithm is of association or classification type then what modifications are requried in source code If you want to use the same Time Series function as Microsoft Time Series (i.e. PredictTimeSeries), then: - your class implementing the IDMAlgorithm should also implement IDMTimeSeriesAlgorithm (both interfaces are defined in the same file, dmalgo.h/idl) - your metadata ...Show All

• catweazle How to convert a value in a parametered sorting

  I've made a parameter for sorting data in a report. The expression for the table sorting is: =Fields(Parameters!Parametername.Value).Value The parameter has two labels (and values): 1. Item (Description) 2. Item number (Item_No) The description is a string, but the item number is a integer. In de parameter properties I can set one value for string or integer. When I use a "locked" sorting I can use the CInt function: =CInt(Fields!Item_No.Value) but when I use a parameter this doesn't work. Please help! I’ve found a solution.The fields used in the parameter could be different types, for example text, decimal, etc. So it is not possible to convert different fields in on ...Show All

• gabriele46 Small values on charts y axis

  Hi! I have a chart that sometimes might show small values (less than one). When this happens, my y-axis label only shows 0, and doesn't show the decimal value. If the values are greater than one everything works fine. How can I "split" the y-axis in small values Thank you! ...Show All

• aztec2_step can a database be made full after 15 entry's

  Hello guys I was wondering if it would be possible to make a database full after 15 entry's and how would I go about doing that if it is possible Hi Warren, Just to clarify: are you talking about simulating a "full"data file in a database, or some form of constraint which enforces a rule that only 15 rows can exist in given table(s) If the former, you'd simulate this by sizing your database very small (2MB for instance), and creating a table in which each column's data size equates to the db size / 15... If the latter, you would do this with a check constraint and perhaps trigger. Cheers, Rob Hi Warren, No worries at all :) It's probably easiest to paste the code in a que ...Show All

• Ix-Xerri Copy values from previous row

  I'm guessing this is a fairly straight forward need, but want to make sure I am using the correct set of tasks: In the dataflow, some values I need to carry forward from the previous row, such as a balance that I need to carry forward for the current customer record. This is similar to a running total, only I am not summing anything, but just carrying over from the previous records value (assuming dataset is sorted correctly, first by customer #, then by date). Do I need the Dervied Column transform, and use a variable to store the previous value, or is there another transform that would be better suited Thanks Kory I would do this in a T-SQL, Stored Procedure, or Execute SQL Task, avoiding a ...Show All

• Stokh Sync Fails with Error -2147200992

  Here is the error message... The merge process could not store conflict information for article 'CMPersonnel'. Check the publication properties to determine where conflicts records are stored. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200992) Help please. ...Show All

• Little_Dice overvue

  i want to build an xml based, driven web site.......... with sql......... in c#. However i looked into visual web developer over a couple of weeks and liked some of the display tools......then when i went back into c# i noticed some of the display tools werent available and vis versa. Also in vis web dev there does not seem to be the "under the bonnet" dataset...person binding source etc. The question is which way should I go Can I build and refine a sql in c# and then drop it into vis web dev or am I just making a lot of work for no reason. I just want to start correctly and not end up in some sort of swamp. Jens.... thanks again have included this time the exceptions .....is this any ...Show All

• themadprof Can't save Server names in "Object Explorer"

  In Management Studio, under Registered Servers, I double-click a server name (could be sql 2000 or sql 2005 server) and it apperars in "Object Explorer" where I can work with it. I click the "Save All" button in Management Studio, exit Studio, and re-start Studio. When I do, I find that all the servers I placed under "Object Explorer" are now missing and I need to go through the "double-click the registered server" ritual again. And again, and again. What am I doing wrong here Why don't the servers "stick" in Object Explorer TIA barkingdog P.S. I have Sql 2005 SP1 installed on my box. >>> When the server is ...Show All

• JockForrester Max function

  Hi, The question is about the way max function works in SQL. I have to implement a database design where in i have to write a stored procedure which will perform an insert in the table/tables. This table/tables will in the long run have a large number of records, i have been instructed to create another table (lets call it tableA) which will have the primary keys of all the other tables and their respective maximum values being used. While performing an insert into one of these tables, i will have to probe the tableA and find out the currently used id for that table ( in which i have to insert a new row) and use the value for insertion. According to me, we can use a max clause in the stored procedure and achieve the following or use an I ...Show All

• Kevin Rodgers help! I am locked out from my SQL2005

  Hi Champs, Is there a way to recover from a account lockout in SQL2005 I cannot connect to "Database Engine" in "SQL Server Management Studio", error: login failed...18456. Access denied. And I also cannot start the "SQL Server agent service" Any possebility to recover without reinstall /Many thanks What is the error printed in the errorlog Thanks Laurentiu Do you have Mixed Autenticated enabled With which Authentication method are you trying to logon COuld it be that your Windows account is disabled for some reason HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• BunnyStrider Problems with Reporting services

  I just installed SQL Server Express Advanced. I previous had SQL Server EXpress installed, which I didn't uninstalled. The problem is that, when I look in Services, it is not started and when I try to start it, I get a warning: "SQL Server Reporting Services started and stopped, some services stop automatically if they have no work to do". I have IIS installed and running. I have disabled Apache web server. What could be the problem Thank you. I have solved the problem partially. I have re-installed the .Net Framework, because initially when I installed it, I did not have IIS installed. Now that IIS is installed I re-installed the Framework and the Server Status is up and running. So, in my humb ...Show All