Viewing 15 posts - 5,776 through 5,790 (of 9,722 total)
viduvs (6/16/2011)
This is some critical issue we are facing in our production environment.
We have a production instance which was installed on SAN-LUN.
Somehow that LUN got deleted, and now SQL...
June 16, 2011 at 5:39 am
Don't just check the application log. Check the system log. It is more likely to have relevant information.
Also, the security log might give you information on who or what was...
June 16, 2011 at 5:35 am
Look into BEGIN TRANSACTION and END TRANSACTION. You'll probably want to name it. Try using the "new" TRY - CATCH functionality for error trapping.
You can find information on both of...
June 16, 2011 at 5:32 am
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
Viewing 15 posts - 5,776 through 5,790 (of 9,722 total)