Viewing 15 posts - 3,631 through 3,645 (of 3,666 total)
My apologies but but when I first replied I missed that you had tried:
SELECT * into Tbl_Cars FROM V_Cars
Try just the select statement
SELECT * FROM V_Cars
Does it return any records?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 3:37 pm
You need to spend a bit more time learning how to create tables.
CREATE TABLE Tbl_Cars
AS
SELECT * FROM V_Cars
is not valid SQL. You cannot load data into a table that...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 2:05 pm
I agree with Crispin. That's why I started my reply with "If were using SSIS...".
I'd much rather to this in VB.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 1:20 pm
If I were using SSIS, and since I'm reasonable new at SSIS, I would load both files into SQL tables and then generate a new file from these 2 tables.
However,...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 1:04 pm
Looking at the "Access Denied" in the error statement I would say that the scheduled DTS is running as a different user when scheduled. That user does not have...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 10:25 am
Could you make sa the owner? The job would then run using the system account.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 8:22 pm
avamin (8/19/2008)
rbarry: To clarify, I suggested creating a single windows user that only the app will use to talk to database. Sorry if my earlier post was not clear.
Wouldn't it...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 4:02 pm
I'm with Terry on this one. Actually, we also used SQLAdmin.
One problem that exists with the local system account is that is does not have rights on other servers....
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 3:53 pm
Instead of changing the user you may have to drop the user then add the user again being careful to use the proper case.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 1:43 pm
I'm just grasping at straws here but try scheduling the job to run around 5:15.
Just a wild guess but I'm wondering if for some reason the data is not available...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 1:08 pm
Double check the time when the job runs. Is it possible it's running after the table has been truncated?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 11:51 am
You got an error with VARCHAR(MAX) because that is only valid in SQL 2005 and 2008.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 19, 2008 at 11:22 am
You can use DBCC SHRINKFILE or make the changes from the database properties using SSMS. SSMS will then use DBCC SHRINKFILE to make the changes.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 18, 2008 at 12:03 pm
If you want to use temp table try using ## instead of #.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 14, 2008 at 7:01 am
Kayuca,
You might want to take a look at the resources that are available for certifications. These resources could provide a good list of the topics that you need to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2008 at 3:50 pm
Viewing 15 posts - 3,631 through 3,645 (of 3,666 total)