Search results for query: *

Is there a way to print a table definition from the Enterprise Manager, or do I have to pull the information to a front end? pamela

In the locals window you cannot expand indexed objects to see their Items. (ie the Parameters collection of a SQLCommand or the Tables collection of a Dataset) How can I explore the contents of the Items in those collections? pamela

I am trying to get my head around the DatePart and DateAdd functions. I need to be able to determine the first day of the quarter from today's date. Can you point me in the right direction? pamela

I am converting SPT code to Stored Procedures and using an ODBC connection to call them. The first stored procedure runs just fine in the Query Analyzer, but returns an error string 'Could not find stored procedure <proc name>' The error code is 37000 Syntax error or access violation...

I am converting a bunch of VFP code to SQL Server stored procedures so they can be called from Asp.Net. I can call the stored procedure in the Enterprise Manager and get the appropriate result set. I have a valid connection handle to the database containing the stored procedure, but when run...

In SQL Server 2000 I am trying to use the Copy Database Wizard to copy a database from our production server to the local server on my development machine. When I select the destination server (my local machine) and click Next, I get an error message "Your SQL Server Service is running under...

All the examples I have seen show the CASE statment or function returning a column in a result set. I want to conditionally set the value of a variable for use in a WHERE clause. Can CASE be used programatically to assign a value to a variable (or to control program flow) or do I have to use a...

How can I tell when the most recent update was made to a database. I would like to know the date, time and which table. pamela

Can someone give me some direction on simulating the VFP GoMonth function in Sql Server? I need to be able to establish dates like the end of this month, end of last month, end of this quarter, first quarter, beginning of last quarter. Any help appreciated pamela

We creating our own version of hell right here in my own back yard. We have both Novell and Windows servers and some workstations are using Windows Client for Novell and some are using the Novell client. How could I programatically figure out which client the current workstation is running to...

I have never used a top-level form before, but I just deployed a little applet in one. If there are any open windows on the desktop when it runs, it comes up in back of them. How do I make it appear on top of other open windows? pamela

I have a test database that I use backup and restore to keep updated with production data. But if I just want to update the data in one table, what is the quickest, easiest, down-and-dirty way. pamela

We have been running our apps across a WAN through Citrix for several years. The EXE lives on a Novell file server with its data. Just recently we have had random incidents of users running a report and locking up their Citrix session. Then it is like a disease. Once one user locks up...