redgate

RE: date comparison help

• by James-Horsley

• Redgate

• Reply

SELECT * from t Where year(t.testdate)=(year(getdate())-1) and month(t.testdate)=month(getdate())

2005-02-05

RE: Automatic column table tracking

• by ram4tech@yahoo.com

• Redgate

• Reply

Hi Remi, What other ways can I accomplish this task, if I choose not to use my own query. Thank you.

2005-02-03

RE: Problems Scheduling DTS ?

• by Bill-Geake

• Redgate

• Reply

A simple thing that has tripped me up a few times is that both the job and the schedule need to be enabled to run. These are on 2 separate tabs of the job properties.Bill.

2005-02-03

RE: job faild

• by Lital

• Redgate

• Reply

i change the path to a full path\\servername\vol\......and it work fine Thanks a lot.  

2005-02-01

RE: job faild

• by Lital

• Redgate

• Reply

this is the cmd file contents:ftp -s:t:\Customised\Database\PFW\Util\$ConData.scrthis is the scr file contents:open 10.22.55.55 asddd ftpee cd panel pwd put t:\Customised\Database\PFW\Util\ILpanelcontrol quit from the dts the process running fine (same user) 

2005-02-01

Blocks / Blocking Locks.

• by Alex-Wilson-148544

• Redgate

• Topic

Evening All;I'm having this strange problem on a production server (SQL Server 2000, SP3A, Build# 8.00.760) whereby, at non-regular intervals during the day we are swamped with blocks.So far I have taken the usual approach, ran traces to identify slow running queries, cpu intensive queries, even to locate what resources are locked; unfortunately nothing to […]

2005-01-31

RE: tempdb problem

• by David Poole

• Redgate

• Reply

I work with a variety of web CMSs and one of the things they share in common is a config file that allows me to switch their own internal logging on.I was wondering if your packaged app had something similar.Although my CMSs have an official set of values that can be used for logging during […]

2005-01-31

getting the check constrains of a field in an specific table

• by ofern

• Redgate

• Topic

I have a program to document a sql database , part of the program is using select to the SCHEMA and part of it is using DMO, table structure with field types, lenght , and so on , i am using the select against the schema but it seems that the checks are not store […]

2005-01-28

1 reads

RE: backup question

• by hoo-t

• Redgate

• Reply

Yes, that helps.  You have a total of 48GB of transaction log, 653.85MB currently in use according to task pad.  You shrank the log a few hundred mbs, so that confirms that you are indeed working with a log on the current db.  Now, a transaction log is made up of many "virtual logs".  As […]

2005-01-28

Re: How to encrypt a column in SQL Server

• by AJ-92543

• Redgate

• Topic

Hi everyone,How can you encrypt a column in SQL Server?? I have a text box in Access when user types in his/her password I would like the field to display something like **** in the text box. The password field is a field in a table on SQL Server.I'm using AC2K and SQL Server 2K.Thanks […]

2005-01-28