Search results for query: *

Hello all - I had to rebuild our file server OS yesterday. Separate from the hard drive on which the OS is/was installed, we have (2) 40GB drives that were mirrored within Server 2003. Upon reinstalling Server 2003 on a new drive (again, separate from the mirror), the new OS recognizes the 2...

Thanks for the response soleagle. I have to work through our ISP's tech support to configure the router (but they seem willing to help). The router is capable of NATing. So if I understand correctly, the router (which currently has an internet IP of 64.0.92.5) needs to be configured for...

Also, in working through the deployment chapter of this book, I am configuring Routing and Remote Access Services via the Wizard. I a receiving an error during this process because I only have 1 NIC installed in the VPN Server. Why are multiple NICs required? Thanks again... ...Doug

Hello all - I am looking to configure our domain controller (Server 2003) as a VPN. It, along with the rest of our small network (about 10 PCs) sits behind an Adtran Total Access 612 router (provided by our ISP). All of our PCs have nonroutable, private IP addresses. My initial confusion is...

Hello everyone - I am struggling with the following... I have an mshflexgrid that is populated with a simple shape command that relates two tables in a one to many relationship. Each parent row has a few child records associated with it. The grid is properly displaying the records. What I...

Hello everyone - I recently ported several access tables to SQL Server. A couple of these tables were "accessed" via parameterized Access queries - either for use in reports, or just to view/modify the data. The users are comfortable with Access as the front end, but I am just not sure of how...

I recently installed the corporate edition on our file server, and have been deploying the client install for several of our office PCs. So far so good... We have a 10 seat license - so when I go to Manage License Seat Allocations for my single group, I see 10 Allocated, 10 Distributed, and 8...

Thanks all for the replies! martyh - I had not tried to ping the FQDN. On your recommendation I tried, and the domain controller responded. So it was able to resolve the FQDN, but not the NetBIOS name. Joseph - makes sense - I tried to telnet to port 3398, and that worked as well, so the...

Hello everyone - I have been struggling to join a new member server (Server 2003) on a different subnet to an existing Server 2003 Domain. Here is the architecture: Windows Server 2003 (Domain Controller, DHCP Server, DNS Server) with IP Address of 192.168.100.23 New Windows Server 2003...

I stumbled across the solution when searching for the connection strings for Data Shaping. It also showed an example of calling sprocs within the SHAPE command. I forgot the exec statement! Oddly enough, the provider I am using (MSDataShape) did not require it on the parent recordset...

Hello all - I am at wits end with a pretty simple data shaping application. I have two tables related to one another (standard one to many relationship between parent and child). I am trying create a data shape to populate the hierarchical flex grid. I am able to get the desired shape when I...

Thanks SQLSister and 557 - I was just not seeing the forest through the trees. It was a long day...!

Hello all - I have stumped myself on the following. I am writing a stored procedure that, among other things, will insert values from one table into another. The source table has 59 fields - 57 of which I need to use to insert into the destination table, which in addition to these 57 fields...

Awesome Will - thanks a bunch. Great FAQ :)... ...Doug

Hello all - I have read a few existing threads regarding Terminal Services Licensing which helped me realize that my Terminal Server Licensing Server was setup for per Device CALs, and I have installed per User CALs (5). I just went in and changed the setting to per User in Terminal Services...

Ok, I have now run into a real indexing question (unlike my previous post with the same subject) - however, it is related to the same table. The table in question is a log table that collects records from a manufacturing software application. As such, informational rows are inserted into it at...

Thank you Walid - that is exactly what I was looking for :). Sorry for the simple question.

Hello again everyone - I have a question regarding the most efficient way to work with a table that stores time series application log data. The table is currently non-indexed. It receives at most a new inserted row every second (but generally about a dozen rows per minute). Each row is date...

Thanks again SQLBill - great information :).

Thanks again SQLBill - I was looking for that exact link, but no luck. Well that certainly explains the behavior I witnessed initially :). Once I recognized that I was not running my simulation with the Desktop Edition, I switched to another PC which I verified was running MSDE. I created a...