Hi all. I'm using SQL Server 2000.
Is it possible to change the location of a tran log for an existing db? The tran log is located at the following location "D:\logs\DBName_Log.ldf", but under the db properties, the location is listed as "D:\logs\\DBName_Log.ldf". I didn't create the db, so...
Thanks for the reply. Good advice on going to the vendor for more info.
Is there any way to know if some of this memory is not being utilized? SQL Server is holding 1.7GB right now, but maybe it only needs 1GB to meet the demands placed on the server.
Hi all. I have SQL Server Standard Edition running on a Win 2k Server (3GB RAM, 2 x 2.4GHz). We are purchasing a new application and I am trying to determine if there will be enough memory available to add the db to this sql server box.
I ran some performance monitors and found the following...
Thanks for the replies!
John your suggestion works great. Too bad I can't simply add the extra command for the output file to my original approach.
Nigelrivett, your sp is something I will definitely be able to utilize.
Thanks again.
Hi all. I am attempting to use an Execute Process Task to have the windows ftp client send a file to another server.
Here's what I've got so far:
Under Execute Process Task Properties
I set win32 process = C:\WINNT\SYSTEM32\FTP.EXE (also works if you just enter ftp)
In the parameters...
All of the data is already in sql (all tables, views, and stored procedures). I want to use Access as a way for our users to view this data and allow them to build their own reports off of it.
The sql database has been around for a while and already has a number of stored procedures that are...
Hi all.
I have an Access 2000 database that is using sql server 2000 as a back-end. I am able to link to tables and views that are in sql server (using a file dsn connection), but have been unable to determine how to link to stored procedures. Does anyone out there know of a way to do this...
Hi all.
I've been given the challenge of altering the PostScript level that a pdf is saved to when it is exported from CR 9. It looks like the pdf's that are exported from crystal are saved with a PostScript level 3. Unfortunately (for me), some of our users are unable to read the fonts in...
If you enable Logging under package properties you can view how long each individual task took to run. To view the package logs you need to right click on the package name and select "package logs..."
Another approach would be to schedule the DTS Package as a SQL Job. You can then...
Sure thing. Here's a quick run down on what we've discovered so far...
We recently purchased a site license for Crystal Desk Report Viewer. Overall the viewer seems to work pretty well, but has some quirks. Currently we are having problems with parameterized reports. If a user launches the...
Thanks for the replies!
Unfortunately obtaining the developer license is not an option for me right now. MikeLewis, I think your suggestion is the route that I am going to have to go with.
Hi all.
Does anyone know if it is possible to integrate a crystal report into a Microsoft Access application if the reports were not built using the Crystal Developer edition? The reports I have were built using crystal 9 professional edition. I'm trying to find a solution that will prevent...
In case anyone else out there is struggling with this problem, here's a copy of the udf that I built to do this date conversion:
CREATE FUNCTION [dbo].[convertYYYYDDDtoDatetime](@InputDate varchar(7))
RETURNS datetime AS
BEGIN
Declare @Year int
Declare @DayOfYear int
Declare @TheDate...
Thanks for the help. Your logic on this works great!
FYI - I had to change one line to calc the date correctly.
Declare @Year int
Declare @DayOfYear int
Declare @InputData varchar(7)
declare @TheDate datetime
set @Year = left(@Inputdate, 4)
set @DayOfYear = right(@InputDate, 3)
set @TheDate =...
using sql server 2000, sp3
Hi all. I'm hoping someone out there has had to solve this problem before. I am attempting to convert dates that are formatted as YYYYDDD to datetime.
YYYY = Year
DDD = Day of year
I am planning on writing a udf to handle this conversion, but have been struggling...
using sql server 2000, sp3
Hi all. I have a DTS package that saves the results of a query to a global variable as a recordset. An ActiveX task then reads through the results of the recorset and writes them to a text file. If I close the recordset object in my vbScript code, I encounter...
Thanks mwolf00!
I wrote a function to handle this. I want other developers to be able to reuse the logic without having to write the if/then statements for the hundreds of fields I need to apply this to.
CREATE FUNCTION convertEmptyStringToNull(@FieldName varchar(100))
RETURNS varchar(100)
AS...
Below is an example of a trigger that I use to datestamp a table any time that any column in the table is updated. If you add a WHERE clause that compares the values of the column in TableName to INSERTED, you should be able to get what you need.
CREATE TRIGGER TableName_DateStampModifyDate
ON...
using SQL Server 2000, SP3.
I have a scheduled DTS package that queries against a source table and inserts the values into another table. The source table contains several char columns that contain only spaces. I am inserting these values into varchar columns and want to prevent inserting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.