Search results for query: *

I can't figure this one out. No matter what I do the user files (FIN) are only 'READ ONLY.' I have the following directory attributes: APPS(share) <read,list> USER GROUP - FIN <modify, read,execute,write> USER GROUP - LOAD <modify, read,execute,write> USER GROUP - REPORTS <FULL...

I was given a project to build a database to work against some previously created PHP code. I would like to recycle some of the PHP code so I don't have to re-write, but the database has to be built from scratch. Can you recommend which forum would be the best to post questions to? I am familiar...

I recently found that I need a table that stores images not text based data. Any suggestions? The tables are already built. Is the image actually stored in the database or there a reference a directory on the server where the file is. IE TABLE 1 PRODUCT_ID - TEXT PRODUCT - IMAGE

Hopefully there is an easy solution to this. I have an older version that seems to work with the same settings. I have install this copy on Windows XP. I created a server called: Name: DEVSQL Host Name: localhost User Name: root Password: blank I am using the MySQL Control Center. It...

I am creating a report based on view of joined tables for a fiscal year report July03- June04; each column only needs to have data for a single month. (DATA is hours worked that month. The DATES are period end dates. ie. June-03 --- through June04 DATA DATA What is the best...

I have a Windows 2000 Server in our small network that encounter some problems using IE based on a Windows Update that did not have a digital signature.(from reading various online postings) I was able to restore a SysState backup, however only users with 'Administrator' rights can use IE, any...

I have had some problems with my server after applying some security updates. It has created an endless loop of errors everytime IE was started on the server it would immediately close. They have put out a hotfix to correct this problem but it is not working for me. The only way to resolve this...

I have a firewall(hardware) as well as spyware and anti-virus application. I recently adjusted my security policies to log/audit failed attempts and I saw a failed attempt from TSInternetUser, I promptly disabled this account, like the guest account, is that enough or should I delete them. I...

I read in WINNET magazine that it is not possible to send the query results to an output file. This was in version 7 of SQL Server. Does anyone know if this is correct or if this is still the case with SQL Server 2000? I tried a couple of different spool commands, but it did not work. The only...

I am attempting to assist an associate with a database that sufferred through a server crash. They relied on a provider to do backups and they were not. They were able to obtain a mdf and ldf file from the server but it is no longer recognized as a database file when they try to attach it. The...

I have created several Crystal reports using MSACCESS as the backend, with SQL SERVER being the true source of data. Basically the queries are written in Access, based on SQL SERVER tables. I can run these reports repeatly no problem. However, when the user tries to run them they get an ODBC...

I have a database query that I created in Access based on a share directory location. Now when other users try to run the report from the server it states in cannot find the path. I tried the button 'convert to unc' in the Set Database Location, but the path remains unchanged. I saw a similar...

Production Database Size 7897.37gb Test Database Size 7269.12gb TEMPDB Size 6668.68gb I have run DBCC CHECKDB and SHOWCONTIG on production database. (tuning and checking for errors) I have rebuilt the indexes of 3 of the largest tables(scripted). Would this create a problem with tempdb...

I reviewed some of the other tek-tips but I didn't see a resolution that would resolve this issue. The user assures me that after he edited it, it was still in the same format, but that cannot be the case because of this error. I want to get some clarification that a file format error is the...

Because of the complex nature of the data I had to combine several queries in MSAccess to get one result query that has everything that I need. I am using this query in combination with some tables from SQL Server. When I first ran this report a month ago it worked fine. Now when I try to...

I have a one-page website that I would like to use with an existing hosting site. I initially tried to purchase a one-page website, but it was too restrictive and would not allow me to use my own background or graphics. Technical support suggested that I use 'URL masking' and place this one...

I understand that this is probably not a simple task but I am open to listen and learn about any ideas that you may have. I have 4 queries that I have combined to run as one query. I can run the SQL code through query analyzer and get all the results for each one of the queries after the period...

I have 4 small select queries that I running at the same time in Query Analyzer. Each select statement within this SQL code uses a Period End Date. Although the table names are different they all have the same period end date. Instead of editing the program for each closing period I would like...

We have a Windows 2000 Server/MSSQL 2000 machine that was recently upgrade to 3gb of memory. I made an adjustment in the memory properties for SQL Server. SQL LOG states: Configuration option 'max server memory (MB)' changed from 2147483647 to 2024. Run the RECONFIGURE statement to install...

We have a Windows 2000 Server/MSSQL 2000 machine that was recently upgrade to 3gb of memory. I made an adjustment in the memory properties for the server. Configuration option 'max server memory (MB)' changed from 2147483647 to 2024. Run the RECONFIGURE statement to install. I ran the...