Using MS SQL Server

Looping Through the Records returned from a DTS Lookup
Okay...here is what I need to do. I have an Oracle Connection that I want to pull records from into an SQL table. I have a view in the SQL server that contain the values I want to use in a where statement to query the Oracle DB with. What I need to do is loop through the Lookup (of the SQL view) in an ActiveX scri... 19 Jun 2008 01:14

Not an ad hoc query?
Dan Guzman wrote: try command.CommandText = "EXEC dbo.sp_setapprole 'MyRole', 'MyRolePassword'" Similarly, you ought to be able to use a stored procedure command type: Thanks! I am trying to get it working from a C++/ODBC library that our architecture group has developed. No luck yet... 19 Jun 2008 01:14

Stored Procedures and Commiting Data
<option value="13315">Jackson, Duane | | Duane Jackson</option> (duane(a)kashflow.co.uk) writes: I have a Stored procedure on a SQL 2005 server. It inserts a new record into t_people and correctly retrieves the id using SCOPE_IDENTITY. It then calls another SP that takes the ID of the new record in ... 19 Jun 2008 01:14

Selecting several types
Hi all, So I have these tables of items and item-types, and the items can be of several types: Items: ID ; Name 1 ; Item1 2 ; Item2 ItemType: ID ; Type 100 ; Type1 200 ; Type2 300 ; Type3 Now, to link these 2 I have a "linking" table: LinkingTable: ItemID ; ItemTypeID 1 ; 100 1 ; 200 2 ; 100 ... 7 May 2008 10:08

Prevent Excel and Access access to SQL 2000
Hi, I'd like to prevent Excel and Access (well any Microsoft Office application) from gaining access to a SQL 2000 instance, via an ODBC connection. If this we're SQL 2005, I create a logon trigger, and just kill off unwanted connections. Can anyone suggest how I can achieve this is SQL 2000? Thanks,... 7 May 2008 04:18

Stylus Studio 2008 Release 2: New EDI support & code generation
[Announce] Dear comp.databases.ms-sqlserver, Stylus Studio 2008 Release 2 is now available.The following highlights some of the new features included in our award-winning XML tools: * Convert New EDI Formats to XML: Stylus Studio now supports the Edig@s EDI dialect. With a new Edig@s to XML Schema wizard, as we... 6 May 2008 23:24

Read HTML File though Network for Email.
Hello, I am using SQL server 2000. I have created 1 folder contains HTML files, which resids on IIS on one machin. And my SQL server 2000 is on another machin. I have created SP which reads file very well if the Files are stored on same machin on which SQL erver was. But if Files are stored on another Machin (fil... 6 May 2008 23:24

Read HTML File though Network for Email.
abhy (abhijit.dalvi29(a)gmail.com) writes: I am using SQL server 2000. I have created 1 folder contains HTML files, which resids on IIS on one machin. And my SQL server 2000 is on another machin. I have created SP which reads file very well if the Files are stored on same machin on which SQL erver was. But... 6 May 2008 23:24

Disable and Rebuild or Drop and recreate Index
Hello all, I am new to managing indexes on large tables and need some help. Hopefully, I am not repeating question here. I searched as much as I can, but not finding relatively best answer.. Here is my scenario. I have 2 tables with more than 4 mil rows (1 - 2.8 Mil, 2 2.1 mil). Of these tables, there are about... 6 May 2008 23:24

How to implement Audit/Alert for Row level access?
Hello, We have a large database of our customers. Some of the important customers records are flagged and can be accessed only by applications designed for upper management. The management would like to know if anyone else is trying or successfully accessed the flagged customers. Is there anyway to send a... 7 May 2008 12:35