When the job was create it should have created a DTSRUN encrypted version that it executes, open the job step and copy it out, then run command line prompt to see what happens? If it fails create one yourself and see if works? Just trying to get a grasp on where the failure actually is […]
2002-03-20
1 reads
2002-03-20
Quickest way to get is open enterprise manager and drill to your db and the tables in question. Right click on each table an choose copy, then paste into notepad or something to old text while you get the other tabel as well, then just paste into forum reply screen. "Don't roll your eyes at […]
2002-03-20
1 reads
DMO is another alternative, though sp_start_job, etc, are just as good if that's all you're doing. Andy
2002-03-20
Many thanks Antares686, I'd buy you a beer if I could tear myself away from this upgrade! Ross.
2002-03-20
1 reads
Forgot to say. There is a large turnover of data loaded into that database (as you can see from the size of the log file). Not a lot else on that server. I think IIS may be on it, and two other databases which are not currently used.
2002-03-20
You can look at the FMStocks application at MS. It uses a middle tier with rights that the end user does not have. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfmstock/html/fmstocks_starthere.asp Steve Jones steve@dkranch.net
2002-03-19
Something like this would work. I included the table DDL for clarity: CREATE TABLE TABLE1 (FULLNAME VARCHAR(20), EMAIL VARCHAR(30)) CREATE TABLE TABLE2 (IDEN NUMERIC(12) IDENTITY(1,1), FULLNAME VARCHAR(20), EMAIL VARCHAR(30)) INSERT INTO TABLE2 (FULLNAME, EMAIL) SELECT FULLNAME, EMAIL FROM TABLE1
2002-03-19
Thanks to you all for the responses. I've also added a second drive array to this server and after configuring it as RAID 5 I have about 70 gigs for the data files. Is there any reason to create separate partitions on this array or should I just create one large one? The only reason […]
2002-03-19
YUP I use DELPHI 5 accessing SQLSWERVER through ADO (direct ADO TLB not ADO Express) Works uncommonly well! But I have to admit to being an MS person as well my principal languages are DELPHI, VB, JAVA and I'm a C# initiate.
2002-03-19
1 reads
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