Viewing 15 posts - 9,046 through 9,060 (of 9,643 total)
Frank,
Thanks for the input. I actually think I have it figured out. I am doing something similar to what you are suggesting. In my destination system I...
March 11, 2008 at 8:21 am
Matt Stanford (3/11/2008)
Isn't a clustered index just physically ordering a table based on the key fields? Does this actually add any size to the table?
It does add some size...
March 11, 2008 at 8:11 am
Brandie,
I don't see a way to sort on a derived column as the derived column task does not allow you to set the IsSorted property or the Sort Keys. ...
March 11, 2008 at 7:55 am
Based on the reading I have done that seems like it would be correct. I wouldn't guarantee my accuracy though. Have you compared it to the results from...
March 11, 2008 at 7:07 am
It sounds like MS is showing the size of the non-leaf levels of the index which should be a relatively low number according to Kalen Delaney in Inside Sql Server...
March 11, 2008 at 6:37 am
I can almost guarantee the Delete without a where caluse will take a table lock. What is the business reason for the purging of the table? Are the...
March 11, 2008 at 6:33 am
If you change the error output to redirect row and place the attached script component in the path you can then output the error with the error description and the...
March 11, 2008 at 6:32 am
Not all countries have 10 character phone numbers. Some are more, some are less.
March 10, 2008 at 9:36 pm
What is the error you are getting? It may have to do with naming convention. Using SQL "." notation versus IBM notation.
March 10, 2008 at 9:35 pm
That error means that the DB2 timestamp column date is either before 1900/01/01 or after 2076/06/06. Are you running the linked server query against the same DB2 data? ...
March 10, 2008 at 9:31 pm
Check out "EXECUTE AS" in Books on Line.
March 10, 2008 at 9:25 pm
sys.databases and sys.sysdatabases are both views in SQL 2005. The base tables are hidden. Not sure what you need to do.
March 10, 2008 at 9:20 pm
What is the length of the parameter in the stored procedure?
March 10, 2008 at 9:18 pm
What kind of problems is the software experiencing? Having multiple updates taking place simultaneously should not cause any problems with the trigger as it should handle that. What...
March 10, 2008 at 9:11 pm
Is there Trust setup between the domains? If so grant your SQL Server Agent account write rights on the share on the other server.
BTW-it is not a...
March 10, 2008 at 9:01 pm
Viewing 15 posts - 9,046 through 9,060 (of 9,643 total)