Sorry, not August, just yesterday ........ ooooooooops! "reversed" dates in english are troubling my mind (should I have noted it was from yesterday...
as referred here ... in August ... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11814 I just received the same email from the same...
Hey there, just recently I have been receiving some alerts with the following Error. * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION It...
Hey guys, First of all, I don't know whether this topic should be posted here or rather in the "DTS packaging" section. Anyway, here we go. It...
Hi there hgurolaksu, yes, the problem was solved when I discovered that it was occurring on other tables, in different indexes than the primary key....
congatulations to satya, of course but....... for us dummies, where is his weblog?
Awesome Articles! " (..) In many aspects SQL Server is a very good DBMS that permits you implement powerful solutions with good performance....
Thanks gremlin, as I see experts a bit quiet, I am afraid there must not be any fixing for that. However, the "convert" example above was just an...
Hey guys, I am trying to trap the following thing: ---------------------------------------------------- declare @myInt int select myInt =...
yes, you are right ... It doesnt work with "E" and "X" as single letters in the middle of numbers ... my developers are beginning to develop a...
and, further to my concern ... could anyone explain to me how to handle this error?? --------------------------------------------- declare @myInt...
Hey, could anyone explain why Select isnumeric('00X418975') --> raises 1 and Select isnumeric('00D418975') --> raises 0 (which is the expected...
Yes, definitely what makes the difference is the WITH NORECOVERY clause .... "To restore multiple transaction log files you must restore database...
Hi there, I have been trying (with EM) to restore 2 different database backup files (complete database and post differential backup) on a different...
I am dealing with the problem and I am doing quite well (sigh!), although I have had to stop the dabatase several times (single user, repairing the...
hey Frank,<br /><br />[<br />Error : 8908, Severity 22, State : 6<br />Table error: Database ID nn, object ID xxxx, index ID 0.<br />Chain linkage...
Hey guys ... I have a "not that enormous" table (400.000 regs) with 100 users accessing it ... I am receiving continously (and even after repairing...
silly ME! Adriaan yes, you are right there were (are) GROUPS! my baaaad! Actually your scenario looks pretty close to what I have here. So far, we...
Actually db_owner, db_writer, db_reader and all that stuff are not dependent on the objects associated, this is why they are so useful ... When u...
When I said "I find that usually the db_datawriter members tend to have those kind of privileges : read/write data and additionally execute stored...
Separate names with a comma.