Viewing 15 posts - 5,776 through 5,790 (of 9,726 total)
I like using subqueries and an Identity column. If you don't have an Identity, add it to the table. Then join the table to a subquery searching for the MIN()...
June 16, 2011 at 6:01 am
"Error" is a generic term in the SQL Server logs. You need to look at the Severity in order to understand if you're reading a true error or an informational...
June 16, 2011 at 5:55 am
DUPLICATE POST! Please direct all responses here: http://www.sqlservercentral.com/Forums/Topic1126304-149-1.aspx
June 16, 2011 at 5:46 am
We definitely need more information. If that is all the information, though, then FYI: Pivot does not work if you don't have something to aggregate on.
You need to SUM()...
June 16, 2011 at 5:44 am
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
Viewing 15 posts - 5,776 through 5,790 (of 9,726 total)