Answer Questions

• Kartit Eventhandlers for DataFlow task events

  Does anyone know how to create an eventhandler for a dataflow task specific events (OnPipelinePostEndOfRowset, OnPipelineRowsSent, etc.) These events are available for logging via the standard logging infrastructure, but there seems to no eventhandler for them. The reason I'm interested is that parsing information logged by these events using builtin log providers is not easy (eg., the number of rows sent gets burried somewhere in the message column (i'm using sql provider). I'd like to capture this information and record it cleanly in a custom ssis metadata database i'm building. Any ideas are welcome. Thanks. -alex chianuri wrote: Does anyone know how to create an eventhandler for ...Show All

• AlexDcosta SQLEVN70.RLL

  I KEEP GETTING AN ERROR WHEN I BOOT MY LAPTOP. IT READS, "YOUR SERVER INSTALLATION IS EITHER CORRUPT OR HAS BEEN TAMPERED WITH. (COULD NOT OPEN SQLEVN70.RLL. PLEASE UNINSTALL THEN RE-RUN SETUP TO CORRECT THIS PROBLEM). CAN ANYBODY HELP ME WITH THIS I've heard a few different solutions to this including uninstalling/reinstalling any SQL components you have on the box (if you are still using them) and changing the SQL Agent service to not start automatically. Give those a shot and see if they work for you. Thanks, Samuel Lester (MSFT) tried copying from another comp that has the same and did not work. also can't seem to find where th uninstall ...Show All

• FernTheBrute TRUNCATE and disk space

  I am extremely confused. I have inherited a sql server database and the mdf file is extremely large leaving only 1% of disk space left. I have truncated some tables using TRUNCATE TABLE <table>. I see some things saying that this will release space back to the OS. Although the table in sp_spaceused does not show it using up any space, there was definitely no data released. So I believe that the only way to clean up this disk at this time is to then run a SHRINK DATABASE, correct Thank you, -Lori Truncating a table will reduce the space occupied by the table in database but will not reduce the space occupied by the database on the disk. As you correctly state you need to use DBCC SHRINKDB to reduc ...Show All

• Tigers21 VB GUI client app inserting into db but where?

  I have a VB GUI client application, no source code or anything, and when I use the GUI to delete a record, is there a tool or something that can tell me where/what the client app is doing in the db (which tables are being accessed, what operation (delete/update/add etc..) The reason I ask this is as follow. I have a client with an access control server. the server stores cards that employees use to enter the building and present to a reader to gain access. this is first time I see this specific type of server. I am integrating some 3rd party app. the db is completely open, I can see all tables etc.. the GUI is closed, the manufacturer will not discuss anything about how it works. I was playing around ...Show All

• Atulpatel omitting null columns

  Hey everyone, I haven't got any idea where to even start looking for a solution to this problem so any help would be appreciated. I'm trying to write a stored procedure that will return a table yet omit any columns that don't have anything written to them, so any columns that have no data will not be present in the table returned after the stored procedure. Thanks in advance. Menace is right: The dynamic SQL to accomplish what you want is pretty ugly. Here is an example of one way to do it: create table dbo.example ( column_01 integer, column_02 float, column_03 integer, column_04 varchar(30) ) go insert into example values (1, null, 2, 'This is a test.') insert into example values (2, null, nul ...Show All

• Pure Krome Return results of stored procedure

  I need to return the results of a stored procedure into a temporary table. Something like this: Select * into #temp from exec (the stored procedure). It appears that I can not do this. The following will not work for me cause I am not sure how many columns will be returned. I want this to work even if the calling stored procedure is changed (i.e add or take away columns) insert into (...) exec (the stored procedure. Does anyone have any ideas how I could do this. Use OPENROWSET SELECT * into #Temp FROM OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec DbName.dbo.ProcName') AS tbl SELECT * FROM #Temp Here is an example you can run to s ...Show All

• Ajai NP SQL 2000 not starting.

  Installed evaluation copy a while ago. Yesterday got a new server and wanted to detach and move the database from old server. However, SQL server will not start on old server. New server runs SQL 2000 Enterprise edition. How do I get my old database detached and moved Your advise is appreciated. Have you tried copying the .mdf and .ldf files from the old server to the new server and attaching them on the new server ...Show All

• Mike Greenway SQLDMO restore error

  I am using SQLDMO.restore object to restore database from backup file (in classic ASP 3.0 Web application). I am getting the following error:- Error Type: Microsoft SQL-DMO (ODBC SQLState: 42000) (0x800A072A) [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WEBGROUP_0.mdf' cannot be overwritten. It is being used by database 'WEBGROUP'. [Microsoft][ODBC SQL Server Driver][SQL Server]File 'WEBGROUP' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WEBGROUP_0.mdf'. Use WITH MOVE to identify a valid location for the file. [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WEBGROUP_0_l ...Show All

• Mark Benningfield How to get all stored procedures script like DDL for table?

  With SQL Server Enterprise Manager, you can get all objects DDL script with drop option in one text file, but not for stored Procedures. How to generate all SP script without using third party tools In the Object Explorer window, Right-click on the database, click on [All Tasks], then click on [Generate SQL Scripts...]. In the window that opens, click the [Show All] button, and then the [Stored Procedures] checkbox. ...Show All

• Alkampfer printing objects on multiple pages and List question

  Hi there, a little new to Reporting Services 2005, but can somebody show me how to display an object on every page I have a sub report that I use and I wish for it to display on every page. As well, is it possible to keep items in a List object together For example, my List dynamically grows, but I wish to keep the items in the list together on the same page. Right now, the items split onto different pages. Any help or comments is greatly appreciated. Thanks in advace! You can only do this if you control the paging manually. you need add a grouping to your list control (right-click -> properties -> general tab -> edit details group... button) and make sure you check the "page break at ...Show All

• Joe Buys SQL Server Mobile - Reset Increment

  I can't seem to find a way to reset the auto increment fields in my SQL Server Mobile database table. Are there any SQL statements I can call in order to do this I'd rather not have to drop and then re-create the database. Any help much appreciated I know that it only work for  identity columns and even if I try on an identity column it did not work for me.  Example: I have a table Table_1 with an identity  column named Col_1 and when I try to run the statement: ALTER TABLE Table_1 ALTER COLUMN Col_1 IDENTITY(200, 1) on the SQL Server Editor in VS.NET 2005  it show me the message: The ALTER TABLE SQL construct or statement is not supported. An ...Show All

• dangrmous CREATE ASSEMBLY error: could not be installed

  I ran the following: CREATE ASSEMBLY A3rdPartyDLL FROM 'C:\Program Files\3rdPartyComponents\3rdParty.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS and got the following error message: Assembly 'A3rdPartyDLL' could not be installed because existing policy would keep it from being used. How can I change the 'existing policy' Often times the problem being reported really means this: Assembly 'A3rdPartyDLL' or another binary that A3rdPartyDLL depends on or uses could not be installed because existing policy would keep it from being used. So, first check on what else 'A3rdPartyDLL' needs. It's "all or none" in terms of the GAC knowing about a set of interdependent files. good luck ...Show All

• PSYDEN SQL Server 2005 Mobile: problem with connection to database

  Hi, everyone! I have a small problem. It consists in: 1. I'm trying to connect to database on my Pocket PC within Visual Studio 2005 (C#) Connection string looks like this: SqlCeConnection1.ConnectionString = "data source = '\\storage card\\mobiluser.sdf'" ; But when i'm deploying it to Pocket PC the error "An error message cannot be displayed because an optional resource assembly containing it cannot be found" appears. 2. When I'm doing te same on Pocket PC Emulator everything is normal. Off course, I have the .sdf file on Pocket PC which is placed to Storage Card into root directory. If anyone knows where I get a mistake, help me please! Thanks for your help! ...Show All

• cjou2004 HELP!!! Can not restore database from only back up I have

  I had to transfer my database from one server to another. Both are running SQL 2000. I backed the database up and moved it to the new server however when I try to do a restore I get the following message: The media set for database "xxx' has 2 family members but only 1 are provided. RESTORE DATABASE is terminating abnormally. I did some searching and found a couple of posts that mentioned something about the back up including 2 files. My problem is that the machine I backed this up from crashed when it was shut down and would not reboot so all of the data and the original database do not exist. Is there any hope of restoring this database. It is pretty critical. Thanks, Melissa :-) He ...Show All

• VRATZ Help? Fragmentation still high after drop and re-create indexes...

  Hello, i am encountering a strange behaviour on SQL 2005 with dropping and re-creating my indexes not affecting my fragmentation. I have many tables with the same structure, and on each table i have 3 indexes defined, one clustered and 2 other indexes. After some time, they get pretty fragmented. When i drop the indexes, and re-create across all my tables, some of my tables fragmentation % is still very high, over 60%. Yet some other tables report fragmentations of 0 across my 3 indexes. I use this query to find out fragmentation: SELECT a.index_id, name, avg_fragmentation_in_percent, index_type_desc FROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID('NS_Time_Daily'), NULL, NULL, NULL) AS a JOIN sys.indexes AS b ON a.obje ...Show All