Something like this should work ok:

Dim oPKG

Dim oConnection

Dim sNewFilename

Dim sDatetime

Set...

This should be ok:

1: In the DTS package have an initial ActixeX script step which assigns the filename, then schedule the DTS job.

2: You could add a column to the...

Gotya - could be a useful distinction.

Paul Ibison

Paul.Ibison@btinternet.com

Isn't this the same as the T_SQL function REPLACE?

Paul Ibison

Paul.Ibison@btinternet.com

Thanks Steven - that's the first time I've heard a decent explanation of that - one for the memory bank.

Paul Ibison

Paul.Ibison@btinternet.com

backing up the transaction log removes the inactive portion but does not physically reduce the file size - use DBCC SHRINKDATABASE or DBCC SHRINKFILE to do this. If this is...

This will work ok, but to select into a permanent table, execute sp_dboption to turn on the select into/bulkcopy option before executing the SELECT statement. :

SELECT a.division

b.department_name

c.employee_name into dimension...

Hi Mitra,

I use log shipping as part of a solution to have a standby server running SQL 7 while we start running SQL 2000 in the live environment. A few...

Don't know of any tools for this, but there are documents to help on Technet:

http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/reskit/sql2000/part2/c0761.asp

I converted an Oracle system last year. Seem to remember that there were far less datatypes...

The unicode locale id is the character set (1033 = English US, 2057 = English UK).

This shouldn't be a problem as indicated by the severity of the warning (the message...

First check the error logs. In EM, open the Management folder, SQL Server logs, Current and locate the reference to the suspect db - this might be helpful.

For reattaching, Query...

Sounds nasty! I'd

(a) check the SQL error log file for any info about the suspect status.

(b) Am not sure how you added the mdb database to sql server, but...

These files are enough, but 'Suspect' could mean a few different things, so initially we probably need a little extra info:

Did you detach the database before copying it, and have...

Thanks for the answers guys.

Steve: the direction you mention for TSQl sounds exciting, although presumably it'll be a couple of years before this comes about.

Mattias: my FK question really...

UDFs (user defined functions) could be used instead of sps. Alternatively (and less preferably) OpenDataSource or OpenRowSet would work.

Paul Ibison

Paul.Ibison@btinternet.com