Search results for query: *

I'm trying to mimic DataSet table queries within VB code that are simple as pie in SQL Server. Another words I want to work with the data tables in vb and perform e.g. left joins that can then be used to create a new table within the DataSet that contains only rows from Table A that are not...

I believe there's a way to select e.g. either all customers from a table or just one customer from a table when given either a customer's unique id (alpha characters) or a null value as the parameter input to a stored procedure. Of course it is possible to just use an IF Else block, but isn't...

I'm new to Great Plaines. I'm trying to learn what tables are effected when various transactions are performed. I've read from another thread that the dex.ini file can be modified to create a SQL log file. I've also read that version 10.0 may not support this feature. My question is rather...

I plan to upgrade to SQL Server 2008 from 2000. I’ve read that to run in 2008 mode, you must not use an alias (for a column name) in the Order By or Group By clauses. The use of *= and =* for joins is also verboten along with the keyword “WITH” (except in nolocks). Hmm, does that mean...

I need to print a SQL Server report (using the report server) from a vb6 application. Does anyone know of example code for creating a vb6 control in .net that could expose the properties and methods to accomplish the printing? Karl Cursors, triggers, user-defined functions and dynamic SQL are...

Does anyone know how to code a call to SSRS from VB6? Is there a .NET wrapper to do it? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Does anyone have example code for calling a 2008 SQL server report (off the server) from VB6? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Can a report be called from a stored procedure? I don't have SSRS, so I have no clue. Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I don't use SSRS, but I'm wondering if the report server can run a report that is called from a stored procedure? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Will I need to update my VB6 and dot net apps? Just connection strings? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I've been Googling this topic, but I've got a few questions that I don't find answers to: If a SP has the Commit & Rollback logic within it and the VB program that calls it raises an error during the call because of a connection timeout (eg. possible network cable/router failure) will that...

Given an email address is there a way to check the string after the @ symbol to be sure that the DNS server can find the email's domain? In other words is there a way to have the SQL server do a DNS lookup? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil...

In thread thread183-1094475, vongrunt outlined a Coupon Definition table to be used by a program running a cash register. The next hurdle involving the Coupon Definition table is actually its child table which contains the ProductIDs to which a coupon can be applied. For example a coupon might...

Hi Guys, it's been a while :-) I have an interesting problem. I need to create a Coupon Definition table that I can use to solve various possible discount scenarios for my new cash register software. What is the most efficient schema that can handle the following discounts: 1) Buy x get y...

Does a backup automatically all of the security info for each database user? How do you backup the Login accounts? -Karl

I'm about to turn on cross database ownership chaining and would like to know if IN MY CASE it is safe to do so. The only login account with any database roles other than public is the sa account. It's my intention to assign a login account (and hard code it) for each application that...

I was startled to discover that a recordset returned by a Select statement in a SP is update-able even when the user doesn't have explicit rights to the underlying table, but only has Exec permission on the SP. I thought that SQL Server would only give Select permissions unless the SP itself...

I've granted exec permissions on a SP in database A. The SP references a table in db B. The connection string references db A. The connection fails because it doesn't have rights to the table in db B. If I change the scenario so that the SP is defined in db B, but still use a connection...

What's the equivalent method for a VB6 Button1=True statement in .NET? -Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

I've tried posting in the VB forum without much success. Does anyone know how to implement Application Roles when using VB. My connection string to SQL Server doesn't work using an Application Role name as the UserID. You can't add users to an Application Role, so how are you supposed to...