Answer Questions

• Gary D Custom Task - Custom Property Expression

  I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime. I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me This is what I did in the custom task customProperty.ExpressionType = DTSCustomPropertyExpressionType .CPET_NOTIFY; In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName ...Show All

• clam0391 row number

  update [Costing] . [dbo] . [Supplier] set n = ( SELECT ( ROW_NUMBER () OVER ( ORDER BY suppliercode ) + 1000 ) as RowNumber from [Costing] . [dbo] . [Supplier] as t where t . suppliercode = Supplier . suppliercode ) hi i cannot update a column with the row number, it is all taking 1001, supposed to be 1001,1002 and so on . thanks. Hi, Use better something like this here: update [Costing] . [dbo] . [Supplier] set n = Subquery . RowNumber FROM [Costing] . [dbo] . [Supplier] S INNER JOIN ( SELECT ( ROW_NUMBER () OVER ( ORDER BY suppliercode ) + 1000 ) as RowNumber from [Costing] . [dbo] . [Supplier] as t ...Show All

• Dipesh A. Communications to the remote server instance failed before database mirroring was fully started

  command in principal server ALTER DATABASE database name SET PARTNER = 'TCP://<mirror_server_name>:5022' return: Msg 1413, Level 16, State 1, Line 1 Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started. This problem is only in production database any testing database include adventureworks mirroring sucessfuly. Why is problem: size database > 9GB slow HW Principal database Intel D 3Ghz,4GB RAM, 4x 15k RPM HDD RAID 5 / Mirror database 2x Xeon 3Ghz,4GB RAM,6x HDD 10k RPM RAID 10 Slow LAN both servers connect 1Gb/s please h ...Show All

• Santal_Maluko Merge Replication with SQL Mobile 2005

  We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas Thanks! Mike Thanks Mike. Working with MS support probably a good way to pursure this issue. they can instruct you how to trouble shooting this issue. Thanks Yunwen are the any configu ...Show All

• sParc134758 List of Table Name that not supported by SQL Database ???

  Is anyone know about waht type of table or database name that not supported or will have error during execution of SQL statement in SQL or MS Access database. For my, I know only two , i.) cannot put table name that same as the the database name ii.) cannot put database name like "RETURN", "POSITION",etc. Is there any reference site that show out a list of table about the table or database name Thank You ... :) these are actually reserve keywords but you can actually use them as table name if you qualify it with quotes or square brackets as shown in the example below create table [return] ( field1 varchar(200), field2 varchar(200) ) select * from [return] drop table [return] ...Show All

• SolarWind Cant see my DB (MSDE)

  Hi! I dont know if this is the right forum to ask about MSDE.well nwy, im new in using msql and I just want to ask why does my database cant be viewed using my VB express edition. I have a database created using MSDE and I can see this using my window explorer. I tried to open the database using the Data Connection Tool of VB express edition but when I go to the directory where the database is I cant see it even I select all files.. Anyone know why thanks! If you execute "exec sp_helpdb 'your_db_name'", you should see the listing for your database files. That's where you should go and look for files... i think u got it wrong... while connecting to Microsoft SQL , you need to connect to ...Show All

• Rakesh k.m cluster install 2nd node unavailable

  Hi all, Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown". - I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 version -> same result. What do I miss out here Any help is highly appreciated. TIA acki ok, after setting up a packet sniffer and running behind the bits and bytes I finally found the solution to this problem. Make sure the "Remote Registry" service is running on second (inactive) node! ...Show All

• Sergey Volk Customizing Report Model AutoGeneration

  Is there any way to customize the expressions that are generated when using the AutoGenerate wizard to produce a model in Visual/BI Studio There are certain expressions that my team always has to generate for nearly every datetime attribute. Adding the expressions manually is very tedious since the expression window does not allow simple copy & paste. There is no supported way to customize the fields created by the model generation wizard. However, if you poke around a little on your file system (for instance, under C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ReportModelProjects), you might find an undocumented file that, when modified, seems to influence the output of th ...Show All

• Quimbo Installation Problems

  I downloaded MS SQL as an ISO file, and tried to mount the image. All I got was a quick loading screen and then MS SQL in a grey box, and it didn't even show up on my applications list when I pushed CTRL+ALT+DELETE. Um. Help :[ Try to directly run the setup in the folder: SQL Server x86\Servers There might be some security issues which does not allow you to run .hta files. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- In my case, I am using Virtual CDROM from http://www.softwarepatch.com/windows/xpvirtualcddownload.html  to access my ISO images.  All you need to do is follow the readme file. You can even share the virtual CD ROM in your network ...Show All

• Pockey Problem in a QUERY with COUNT

  CREATE PROCEDURE [dbo] . [GD_SP_HARDWARE_MONITOR_COUNT] -- Add the parameters for the stored procedure here @Direccao nvarchar ( 10 ) AS DECLARE @NrMon int BEGIN SELECT dbo . Monitor . MON_Monitor AS Item , COUNT (*) AS Unidades , dbo . Monitor . MON_CustoUnitario AS Total FROM dbo . HARDWARE INNER JOIN dbo . ADServico_User ON dbo . HARDWARE . UserID = dbo . ADServico_User . UserID INNER JOIN dbo . SERVICO ON dbo . ADServico_User . GrupoServico = dbo . SERVICO . S_GrupoServico INNER JOIN dbo . Monitor ON dbo . HARDWARE . MONITOR_ID = dbo . Monitor . MONITOR_ID WHERE ( dbo . HARDWARE . MONITOR_ID <> 5 ) GROUP BY dbo . Monitor . MON_Mon ...Show All

• pwinant DELETING ROWS with REFERENTIAL INTEGRITY

  hi there! im having problems deleting rows in a reference table. is there any tools which tables to delete first before deleting the rows in the table which contains the primary key i have a lot of tables let say over 300 so its hard for me to guess which comes first... what should i keep in mind deleting rows with a referential integrity thank... hi nitin! thank u for ur quick reply! the thing is, im copying data from server to server, after copying the data i wanted to deleted this rows i've copied to the source database and offcourse i want to delete correctly. i dont want to disable the foreignkeys because if my delete script is wrong , i wont able to delete the data correctly. b ...Show All

• GConst Scripting.FileSystemObject & Script Task

  Hi Is Scripting.FileSystemObject exists in SSIS (Script task), Below is the code from ActiveXScript (SQL 2000) What will be the equivlant in SSIS (Script task) Thanks unction Main() Dim fso Dim fil Dim fold Dim counter Dim intMonths set fso = CREATEOBJECT("Scripting.FileSystemObject") set fold = fso.GetFolder(DTSGlobalVariables("gvProcessedFolder").Value) counter = fold.files.count if counter >= 1 then for each fil in fold.Files intMonths = DateDiff( "m" , fil.DateCreated , Date ) ' Delete all the file whose passed the FileArchive Duration if intMonths > CInt(DTSGlobalVariables("gvFileArchive")) then fil.Delete end if Next End if Main = ...Show All

• JAul How to set douplicate id in sql server 2005?

  Hi There, Some one please help me to achieve this task. I have task to join 2 tables and insert values.The table which i am inserting values has typeid column which is primary key column.I supposed to insert values except this column(TypeId).When i m trying insert values its throw an error saying Error: Cannot insert the value NULL into column column does not allow nulls. INSERT fails. Please let me know ther is a way to set duplicate id for this rows Thanks in advance. See if this helps you. Take a look at my post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1211015&SiteID=1 I don't understand; how is that a column is a PK but you don't want to insert any value on it a PK has to have a va ...Show All

• DamonPeng SQL server agent job

  Hi I have a SSIS package that uploads data into a table by reading from flat file. When I deployed it to SQL Server(different machine, not in dev machine) it fails to execute the SQL Agent Job. I have tried as many combinations of sa vs windows authentication. I am sure there is no problem in the package, as it runs fine manually. I also tried to look into the log file. please find below the lines which were extracted from log file. "The job failed. The Job was invoked by User CHNBSL\durairaj.g. The last step to run was step 1 (To upload data into Emp_temp).,00:00:01,0,0, 07/11/2006 23:28:06,test_schedule,Error,1,BSLCHNLCS01,test_schedule,To upload data into Emp_temp,,Executed as user: BSLCHNLCS01\SYSTEM. The package exe ...Show All

• ivanchain Failure when installing SQL 2005 SP1 on Windows 2003 Server

  Hello. When I installed SQL 2005 SP1 on Windows 2003 Server, I received the following message: "A recently applied update, KB913090, failed to install." At the end, "Database Services" was marked as "Failure". I have tried everything I could find in the knowledge base and on the forums, but still was not able to install SP1. For example: http://support.microsoft.com/default.aspx scid=kb;en-us;918357 Any insights would be greatly appreciated. MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (B0!C0) [22:08:08:355]: Transforming table _sqlAction. MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -21472 ...Show All