Viewing 15 posts - 46 through 60 (of 155 total)
Yes, the idea is that only records that got summarized get updated. With no new inserts that match either.
July 14, 2006 at 5:51 am
I had a purchased application that production data disappeared from a table with no known cause. We believe it to have been a bug. Vendar has been contacted, and they...
July 11, 2006 at 6:23 am
It appears that if you copy data into a new table by using the selct * into ... syntax than it keeps the original timestamps.
I am trying to find...
July 10, 2006 at 12:38 pm
If this does appear to be right path, SPNs are a critical piece of this as well as enabling the account that runs SQL to impersonate. Changing the SQL service...
February 22, 2006 at 9:14 am
What type of connection is the linked server trying to make?
Is SQL running under the same account it was before the server changes? ie, did you change from local system...
February 22, 2006 at 6:13 am
I've had sporadic issues with Kerberos and for the most part it has been because of improper SPN records. Check your allowed for delegation on the SQl service accounts and...
February 22, 2006 at 6:07 am
Historical execution statistics for stored procedures - numbers of times executed and time. Access statistics for tables and views.
February 17, 2006 at 3:09 pm
It appears to be executed also when remote queries are run (ie using linked servers).
I am having issues with queries 'hanging' while DBReindex is running on...
January 5, 2006 at 6:58 am
Can you copy the EXACT create for the view into QA and create it on the subscriber database? Are you sure both subscriptions are going to the same subscriber database?
December 13, 2005 at 12:24 pm
Anything not electronic. Besides keeping books for my contractor husband and running two teenagers to activities, I enjoy anything outside - living in the great state of TN and only...
December 12, 2005 at 7:33 am
BTW, if it's a log file giving the error, you may be fooled into thinking you fixed a problem if TLOG backups are running at intervals and you don't know...
December 7, 2005 at 7:20 am
Suggest same thing as hplu. Had a similiar problem with data file on a web site. Change your growth increment on all files to a set amount you know can...
December 7, 2005 at 7:14 am
For security reasons I am removing non neccessary permissions from the service accounts.
The article you point to is a very good reference to find all the information about rights. It seems...
December 1, 2005 at 9:48 am
I looked at the reference and I couldn't get that to work either. I had an idea that maybe the problem was privileges still - that because the file path wasn't...
December 1, 2005 at 8:27 am
Thanks for the feedback. It looks like I will end up with a process very similiar to yours. Perform the login creation disjoint in a scheduled job separate from the application...
November 29, 2005 at 6:45 am
Viewing 15 posts - 46 through 60 (of 155 total)