Search results for query: *

Hi all, I'm relatively new to the SQL Server 2005 world and am looking for a good "overview" book to purchase. I'm in charge of everything from installation & maintenance to creating T-SQL and scheduling jobs. I attended an administrative course, but need some guidance on some pretty basic...

New to SQL 2005 and I'm trying to get a stored procedure that will extract the query info into a csv file to the server. I know how to do it in 2000, but it didn't work in 2005. I'd surely appreciate some help on this. Here's the code: USE [msdb] GO /****** Object: StoredProcedure...

Hopefully someone out there can point me in the right direction! [ponder] I've got a table of test scores containing the following data with up to five different test types: ID, Test_type, score, test_date, grade 000008710 CR 50 10/2004 11 000008710 MATH 62 10/2004 11 000008710 SI 17 10/2004...

I receive the following message while trying to restore a database in our test system. I'm using a backup from our live server, restoring it to our test server. What am I missing? cannot associate files with different databases ODBC SQLstate 42000

This is my first day with having FMP7 Server advanced up & running. Everything is installed on one box (server 2003). I've got one database published using IWP. When I go to the url for IWP, I see my database listed. I click the link and it prompts me for a login, but which one do I use? Any ID...

Hello, This is a long shot, but... we have crystal reports v8.5 installed on our 4 citrix servers (windows server 2003). When I launch Crystal directly on the server, the regsitration info is retained correctly. When we publish the application either by desktop or just the application (from...

Hi all, I've got a very invloved view joining quite a number of tables. It takes 30+ minutes to run because of all the data we're pulling. To make things easier on the user, I'd like to populate a temp table each night with this data (and report from that). I'm not sure how to go about this...

How can I tell if another form is open with VBA? I'm in Form A and want to in my code, check to see if Form B is also open. Anyone? Thanks!

Hello all, I have two test servers running SLQ Server 7 (one is "blank"). I need to make a copy of a database from Server A (via backup) and restore it onto Server B (via restore). The purpose is to set up an enviornment for testing upgrades. The two servers are actually on one...

I know this seems like a simple item, but I'm not sure how to do this. I have one form, and upon reading the record, I want to set a "global" field for the ApplicationType (on the event). In another event (applicationType before update), I want to read the global variable to see if...

Hello, Our FMP server event log shows that event ID 30 & 31 keep occurring for every file on our server, over & over again. It seems as though each file is cycled through these two events constantly throughout the day. These events are not initiate by any users, as they are occurring...

I'm trying to create a query that will return the top value when multiple rows are retrieved for one person. For example, I have a person table. A person can be entered multiple times depending on the type (employee, former employee, retired, part time, faculty, former faculty). Select id...

Hi all, I am an experienced database programmer with SQL Server & Access. I have started a new job where I now need to support some Filemaker Pro databases. I've been asked to create a FMP backend (not a problem) that will import data from a webpage. I don't just want to publish the...

Hello all, I need to pass a Serverfilter paramater when opening a report. Can anyone tell me how to do this? I am not looking to apply a "filter"... I need to use the "serverfilter" property. This is an Access project with SQL Server backend. When I open my report in...

I'm wondering if there is a way to reverse engineer a VB application exe file to generate the source code? We had a part time employee create an application. He quit and we can not find the source code (vbp) for his application. All we have is the package including the CAB, setup.exe and the...

I'd appreciate some input on this. I'm not a VB programmer, but have been given an application to correct. (I work with SQL Server & Access) I have an application with VB 6 front-end connecting to SQL Server 2000. The programmer has his SQL ID & Password saved in the application, so that...

Forgive the simplistic question. I'm an Access developer who's been given some VB source code to fix. The person who developed the code put a copy on CD before leaving the company. I've copied the source onto my PC, but when I open it (VB 6), it says "read only" at the top of my...

This may seem like a simple one. I've got a datetime variable that I'm declaring in a stored procedure. How do I set it to be the current date? ( @today datetime=Now ) This gives me a "syntax error converting datetime from a character string." thanks in advance, H. Barnes

Is it possible to set the unique table property in VBA code behind a form? I have several forms where I need to set one table, but notice that the option does not always remain saved. I'd like to ensure this is set. Does anyone know how to do this using VBA? thanks in advance, H. Barnes

Is it possible to set the unique table property in VBA code behind a form? I have several forms where I need to set one table, but notice that the option does not always remain saved. I'd like to ensure this is set. Does anyone know how to do this using VBA? thanks in advance, H. Barnes