Steve Jones - Editor (5/6/2010)

---

I think you might want to do this instead:

DROP TABLE dbo.mytable

go

CREATE TABLE mytable( col1 int, colb varchar(20))

GO

INSERT MyTable SELECT 1, 'a'

INSERT dbo.mytable SELECT 2, 'b'

GO

DECLARE @tbl...

Dan.Humphries (5/6/2010)

---

I would try running the dro table seperately. If it is truly not in the tempdb then you will get an error stating the table does not exist...

Dan.Humphries (5/6/2010)

---

I dont see a drop table section to drop the temp table on completion so if you have run this in testing and then you are trying to run...

Steve Jones - Editor (5/6/2010)

---

Why copy it? Is the logic that complex?

Couldn't you copy the row back into the table directly, changing the columns?

insert TableA

select ColA+1

...

That depends almost entirely on the nature, structure and format of the file. There is nothing complicated about float or decimal (though you do have to be set on...

Ok, so its like setting up permissions in active directory. I can handle that. Where do I setup the schemas?

Just when I think I'm starting to get good at this stuff, I come on here and realize I'm not, haha. Schema's, hmm...where do I begin? Would this schema be...

Problem fixed by applying SP2.

I tried configuring the user for sql service service and sql server agent service as administrator but still not working.

I have this procedure working on my physical machine.

Also note, this is running on vmware, so I don't know if this would affect it.

Line 1:

EXECUTE master.dbo.xp_create_subdir N'C:\SQL Server Backups\test'

If I run the t-sql manually it works (From New Query).

Cool. Will Truncate Table Drop my foreign keys?

So my index in my county table should be the state_code? I really can't think of what I would index in my States table since it just lists each state...

I guess I must be missing the meaning of index. In my county table I have 1 column called County_Id (primary key, unique identifier), another column with the actual county...

Ok, I went into my database diagrams and updated a few table relationships and it seems to have fixed the delay. However, they still do not say "Seek" instead of...