Answer Questions

• Sivaji Raju Foreign Key Constrint Problem

  we have tables created CREATE TABLE Project ( CreatedBy int NOT NULL, CreatedOn datetime NOT NULL, Description nvarchar(1028) NULL, ProjectID int identity(1,1) NOT NULL, ProjectName nvarchar(128) NOT NULL, RefProjectID int, Time_Stamp datetime NOT NULL ) GO CREATE TABLE Project_AuditLogs ( Before_Data int NOT NULL, EventID int NOT NULL, LogDate datetime NOT NULL, Project_Audit_ID int identity(1,1) NOT NULL, UserID int NOT NULL ) GO an ...Show All

• exo_duz Delete subreport at runtime?

  Is it possible to delete a subreport from a main form at run time I am trying to find a work around for the inability to conditionaly format a page break. I have a main form that has 10 subforms. Some of the subforms won't have any data (depending on the parameter values). When I export the main form to excel each subform needs to be in it's own excel tab. Obviously, I don't want a tab if there is no data. Any suggestions ...Show All

• Matei Puiu SQL installation Error...

  i tried installing sql server 2005 express... but when i came to installing last part, the database server, it gave me this error SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted. help anyone I have the same problem. I'm running on xp ...Show All

• xsfidoo Best Oracle source provider?

  Hello, I am using a massive Oracle db in SSIS and am trying to figure out the best way to increase performance in moving data from this db to sql server.  As far as Oracle sources, which seem to have the best performance Thanks, Adrian The OLEDB providers for Oracle that are currently available aren't terribly fast.  Have you considered replicating (a subset of) your data to SQL Server from Oracle b ...Show All

• WindSailor How to make tables & stored procedures in MSDE?

  Hello, I am a beginner using MSDE & Visual Basic.NET standard version (not Visual Studio.NET) . MSDE was downloaded from microsoft.com yesterday, which is sql2ksp3.exe. The problem is I don't know where to input data to set up tables or stored procedures after configured the MSDE. The MS Desktop Engine pops me "configuration sucessfully", then I can just open a small window with the title of "SQL Server Service Manag ...Show All

• Nate Hekman Time Intelligence gives this failure if X64bit installed on a different drive

  TITLE: Microsoft Visual Studio ------------------------------ Could not find a part of the path 'C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Templates\OLAP\1033\TimeIntelligence.xml'. ------------------------------ BUTTONS: OK ------------------------------ SQL Server is installed on D:\SQLServer2005 (x86). and the XML file is on the D: drive. Has anyone come across this Thanks for the re ...Show All

• nkw Conflict of Permissions by NT Groups

  Hi, This is regarding permission issue in windows-authenticated sql server 2000. I have two NT groups namely A & B. Groups A has all permissions on SQLDB1 while group B has all on SQLDB1 and SQLDB2. Since I dont want B to have INS/UPD/DEL rights on SQLDB1, I revoked those permissions for B on the same. But users belonging to both groups suffer INS/UPD/DEL rights on SQLDB1. Could anyone help please Tha ...Show All

• Wayne Atherton Empty Source So there is no data in the pipleline

  Hi, I am trying to do a lookup for a value in a codes table and if that code is not there; add it to the table, my problem is if the lookup table is blank no records to begin with it will not add any data, that means the data source is empty so there no data going thru the data pipeline. So how do I get data in the table if we start with an empty table If I am not clear I can explain it more. Thank ...Show All

• Aus .Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."

  Hi All, I'm developing Pocket Pc application, In that i have set of statement, which establishes connection with sql Server 2000 Database. When ever I try to open SqlConnection, I’m getting error "Can't find PInvoke DLL 'dbnetlib.dll'.". Right now i am working in .Net Compact Framework 2.0 , But previously i worked in .Net CF 1.1 i didn’t face problem while doing that. Can any one help me to solve this issue   My code exactly look ...Show All

• ejm3 Online Data Transform

  Dear All, I am new to SSIS, and just watched some of the webcasts and take a look at SSIS Hands on Lab on the MSDN site. I want to handle an online data transformation scenario which has some data mappings between. I want the SSIS to add each new record in source table, insert in the destination tables online. If this is possible, please let me know where can I find a sample package and configurations. Happy new year, Sassan ...Show All

• Computer-Geek Please post setup and installation questions in the Setup forum

  This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum. Thanks There was also a feature in Visual Studio 2003 whereby we could view and manage the database present on the server(s) [I think it was called the SQL Enterprise Manager], and also a tool called the Query Analyzer where we could run queries on the data ...Show All

• Olega Programmatically create data sources

  Is there a way to do this It does not appear as part of the standard SSIS API. Thanks. Thank you Mark. I know how to create connection managers, as it is part of the standard API. Data sources are design time components - part of the SSIS project and has no impact on programmatically creating packages. Can you provide an example of accessing the SSIS project and adding a data source to it ...Show All

• Mariusz Gorzoch AES (128 bit block) : Can I use it?

  If I've got a 64-bit OS such as Windows XP Professional x64 Edition running and I have the SQL Server 2005 Express Edition, is AES permittable or does TRIPLEDES still need to be used SQL Server 2005 does not support AES encryption on Windows XP. You can visit http://msdn2.microsoft.com/en-us/library/ms345262.aspx for more details. -Raul Garcia SDE/T SQL Server Engine ...Show All

• dNetGuru Branding of Reporting Services Web Site

  Is there any documentation out there as to how you go about changing the look and feel of the Reporting Services Web Site Not being able to apply the corporate 'brand' to the site is the only thing that prevents us from adopting this as the corporate reporting service, from my evaluation of the product so far Thanks Thanks for the response. I was hoping not to have to build my own Web S ...Show All

• tenshon 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 dat ...Show All