Viewing 15 posts - 5,761 through 5,775 (of 9,707 total)
Has the backup device been created?
People who use third party tools or the GUI tend to forget that the T-SQL backup commands need that extra step.
June 16, 2011 at 5:25 am
Ditto what Gail said.
However, a lot of people I know use staging tables that they create and drop at need in a user db. These are permanent tables, even...
June 16, 2011 at 5:24 am
What kind of log files? Can you post a sample name for the log file?
I take it that an application would have these files open, rather than a person? If...
June 16, 2011 at 5:23 am
I prefer running an Update via a stored procedure in the Execute SQL Task myself. Merge Join takes a lot of resources that I can better use in other areas...
June 16, 2011 at 5:21 am
What version and edition of SQL Server do you have installed?
Run SELECT @@Version on SSMS and return the results, please.
June 16, 2011 at 5:20 am
Why use a Script Task when a File System Task might work just as well? You can set variables at the package level and have them populated by the names...
June 16, 2011 at 5:18 am
Look at the package level properties window, the Checkpoints menu. There are three options. CheckpointFileName, CheckpointUsage, and SaveCheckpoints. These are all integral in setting up Checkpoints properly.
You need to...
June 16, 2011 at 5:16 am
I am not trying to add wood to the fire, but I have to agree with the comment that going from a higher build to a lower build is always...
June 16, 2011 at 5:11 am
Could you highlight your variable and copy a picture of the variable and property box into your next post?
That might help us visualize the issue.
June 16, 2011 at 5:00 am
Sonal,
Your post isn't very clear. Could you try rephrasing your issue? Include the following details.
1) What type of tasks you are using
2) What you are trying to achieve with...
June 16, 2011 at 4:58 am
I'm sure I'm late, but I'll try anyway.
Make sure you map a variable to that file name in your container and that the variable is scoped at least as high...
June 16, 2011 at 4:51 am
Ah. This might be part of the problem. Sybase and SQL Server datetime data types aren't exactly the same.
June 16, 2011 at 4:45 am
sqlfriends (6/15/2011)
June 16, 2011 at 4:32 am
Peter Trast (6/15/2011)
SQLRNNR (6/15/2011)
Now what does it mean?
The long way to say silicosis.
The main purpose of the word is to be the longest word. It was coined for that purpose...
June 16, 2011 at 4:25 am
Brandie Tarvin
PneumonoultramicroscopicsilicovolcanoconiosisSQLRNNR (6/15/2011)
Now what does it mean?
It's a lung disease caused by silica.
June 16, 2011 at 4:24 am
Viewing 15 posts - 5,761 through 5,775 (of 9,707 total)