Search results for query: *

Do you understand the fundamentals of relational databases (normalisation, DB design and general ANSI compliant SQL etc)? I'd say understanding that was far more important than understanding SQL server specifics, although both are very relevant to you. For a start, DTS doesn't exist in SQL...

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...

I should add, I can get this to work using SQLCMD, but my manager wants this as a scheduled SQL job (like DTS). It works, but hey, I have to ask!

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...

Thank you, thank you, thank you!!!!! That's exactly what I needed!

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...

Ok, got it to work! The location for the log file was different. Thanks!

True backup... On live, I did a "backup database". When complete, I copied that file to the backup directory on the test server. Then I performed a "restore database" from device, navigate to that backup file.

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

We use Citrix but have not installed FMP7 yet on the production servers. I assume that you are not hosting the server via citrix, just the FMP7 client, correct? You want FMP7 server on a different server. Then install the client only on citrix.

I put a call into FileMaker. The issue was with a setting in the IIS. It was checked to look at windows authentication, which should have been unchecked. I'm glad I made that call because I don't see that documented anywhere in the install guides. Thanks for your help.

Yes, it does work fine from sharing the client with the FM account.

I should also be sure to mention, I am not using IWP by sharing the file from the database itself (not from the sharing menu). I want to do IWP from the server hosted database. I hope that makes sense. I'm guessing that either I don't have something configured right on the server, or I don't...

Yes, I have given access under IWP in the extended privileges area (for all access levels).

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...

Well, that's a great thought, but that didn't work either. If I run Crystal directly on the Citrix server, the registration # is there. I even tried uninstalling crysta, going into install mode, and re-installing crystal. As soon as I try to run Crystal from the published application or a...

Did you ever find a solution? We have the same problem. We installed Crystal Rpts from CD, not an upgrade. Server 2003, Crystal 8.5

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...

Thanks John. Quick question to clarify. Do I need to name the columns in my view the same as in my temp table? I'm wondering how that select into statement would work otherwise. Thanks again, Heather

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...