Should be doable. Access supports both autoexec and named macros as I remember, you just pass a command line switch. I'd suggest using a batch file to get it to work right, then either call the batch file directly from the job or cut/paste the line from the bat into the job. Most likely what […]
2003-08-25
Sorry, I was wrong. Once the license mode is set, you can't change the modes but you can add seat or processor licenses from control panel --> SQL Server 2000 Licence setup. But you still can change it by change the registry. '0' for 'per seat' and '2' for 'per processor'. HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo\MSSQL8.00
2003-08-22
1 reads
What exactly are you doing in the package. I've run into similar problems in trying to output data to an Excel file. Using Active X object, I've checked for the existence of the table, if exist, drop and re-create, if not exists, create, then execute transformation.
2003-08-22
As an alternative, consider using NTFS to store the document files. In your database simply store a pointer to the resource, e.g. a varchar field called "URI", containing data such as: "//myarchiveserver/myfiles$/myfile.xls" You don't say what version of IE, but assuming something fairly modern with the appropriate plugins, displaying the documents is then as simple […]
2003-08-21
Hi chitra, quote: How can I store Excel / word / Image documents in SQL server 2000. The files exists on the NT server. What should be the front end to browse the files and capture into the SQL server database. The front end given to the users is the I.E using ASP. Pl. guide. […]
2003-08-21
wouldn't taking the SQL from the queries and creating them in SP's and Views be a good start. It would depend on the complexity of the prog. If it is a client tool and not internal proggy then sure you are talking total conversion, if it's internal then converting select queries to Views and some […]
2003-08-20
We had this problem in SQL 7.0 SP1. Unused connections would be orphaned when the last icon was deleted. After we applied SP3 we were able to remove the orphanes by adding an icon and then removing it again. Hope this helps.
2003-08-18
1 reads
Hi, The type of recovery model you have set affects the space, i.e. bulk logged uses the least amount. Check BOL for more, and the pros and cons of different recovery models. Cheers Ritch "I didn't do anything it just got complicated" - M Edwards Edited by - Ritch on 08/18/2003 09:37:54 AM
2003-08-18
1 reads
Hi, You can try in QA: backup log yourdb truncate_only dbcc shrinkfile (file_id, targetsize, truncateonly) Sometimes it can be quite stubborn, so good luck Ritch "I didn't do anything it just got complicated" - M Edwards Edited by - Ritch on 08/18/2003 08:12:51 AM
2003-08-18
Thanks for the answer. Yes, I did not run comclust. The servers and cluster had to be re-built. Comclust was run on both nodes and the setup program successfully installed SQL 2k on both nodes. Failover worked correctly. Thanks again. Graham Farrow Graham Farrow DBA Mastercare Central Division
2003-08-18
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers