Search results for query: *

Dear All, I'm sure this is probably a simple enough question, but after many hours of searching I'm thoroughly confused and no nearer finding an answer. Problem I have a standard 3 tier (Pres\BLL\DAL) WPF\vb.net app that uses SMO to backup\restore a SQL database. Once the user clicks the...

Dear All, I'm working on an application that will automatically update my company's software on a number of remote servers. This is easy enough, but sometimes additional programs (e.g. Windows add-ons \ runtimes) are bundled with the update. Some of these additional apps will require Windows...

Dear All, I'm designing a new vb.net solution and want to return strongly typed dataset objects from the Data Access to the Presentation layer. However, I can't decide where to create the datasets within a classic 3 tier design. As I understand it, the only way that I can use the dataset...

Wow, that's given me exactly what I need! :) I can confidently say I wouldn't have managed that myself, but have learnt a lot about the Access system tables in the process. Course I've still got 1200 joins to plow through, but just getting to this point would have taken me weeks manually...

MajP, I've finally found time to try your solution and have hit some issues. Because my database doesn't have any relationships defined "DocumentRelations" doesn't return anything to the immediate window. Also, "DocumentQueries" doesn't output any info on what relationships are defined in the...

Thanks Maj, that's some great info and with a bit of tweaking should save me a heap of time. Apologies for the slow response, I've been sidetracked onto another project. Hopefully I'll find time to give it a try sometime soon... Ben

Dear All, I've taken over a long established Access database with approx 400 tables. All of these tables (I think) have primary\foreign keys columns defined, but for whatever reason the actual relationships between tables were never created. I'm now in a situation where nobody at the company...

Thanks George, that's much clearer. I'm much more confident now that I won't roll out a system that has major language translation issues. Thanks for all your help, have a well earned star from me! B

Thanks George, that's provided a lot of useful information and clarification. I have a couple more questions as a result if you could indulge me. If I specify in my installer that all SQL instances and dbs are created with Latin1 collation, will this come with the risk of applying...

Dear All, I'm creating my first multi-language (English\Arabic) SQL Server database (version 2005) and could really do with some advice on the finer points of collation settings. The structure of the system is: 1 main SQL database (handles storage for the main product) 1 or more additional SQL...

Dear All, I have an ADO recordset in the format (TableName, FieldName, DataType, MaxLength, DefaultValue) I am trying to construct an ADO recordset object from this in the following format: Name: Field1 Value: Default1 Name: Field2 Value: Default2 The purpose behind this is to get the...

Dear All, Any advice on this issue would be most appreciated as I really don't know what to do for the best. As part of a wider project I'm writing code\stored procedures to perform the simple task of inserting a row into a SQL table. I have my SP which accepts a param for each field in the...

Hi All, I have a user defined function (SQL 2005) that expects a number of parameters. I'm wondering if there is any way to pass the params to this function by name, as is possible when calling stored procedures? E.g. SELECT * FROM [FunctionName] (@Param1 = 'Value', @Param2 = 'Value') It's not...

Thanks guys, I guess I'll just have to order on the call expression. Cheers Ben Cooper

Dear All, Please can someone explain why the results of the following table type function in SQL Server 2005 don't sort as per the ORDER BY statement. ALTER FUNCTION [dbo].[CONTACT_HISTORY_UNION] ( @ContactID AS int ) RETURNS TABLE AS RETURN ( SELECT TOP 100 PERCENT * FROM ( SELECT ID...