Viewing 15 posts - 601 through 615 (of 824 total)
Here you are confusing the issues again. I am not naming the set of employees "employee" I am naming the variable that contains the set "employee"
Nobody would argue that the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 6, 2005 at 2:10 pm
"Every tuple is itself a relation. This concept is called "relational closure," and it's very important -- this closure is the reason that I've noted elsewhere in the thread that,...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 6, 2005 at 1:51 pm
I, for one don't care what the iso standard says, they are wrong. A table does not represent a set of entities. Tables represent a single predicate function. So the...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 6, 2005 at 1:20 pm
It's been a long time since I looked at Great Plains and that was before MS bought them. Two points: 1) I wouldn't be surprised to see a bunch of "legacy"...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 6, 2005 at 10:56 am
True, views are not IDENTICAL in their behavior when it comes to DML operations (this is one of the major problems with SQL but that is another discussion.) However, according...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 6, 2005 at 9:03 am
I haven't tried LogPI and when I purchased Log Explorer, I don't think LogPI existed so I never compared them side to side. That said, I will say that Lumigent...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 5, 2005 at 9:37 pm
Have you tried running it from Query Analyzer using xp_cmdshell?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 5, 2005 at 9:35 pm
Who or what manages the changes to the script? Is Monday always the same? If monday, Tues, etc... are always the same (but different from each other) then you'll need...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 5, 2005 at 9:01 am
What happened, what exactly have you done, and what error are you getting? More detail would be helpful.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 1, 2005 at 9:14 am
If you make changes to a table then add/modify data, then discover a problem that requires you to rollback the changes to the table, isn't it a pretty safe assumption...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 31, 2005 at 10:38 am
Not a bug, BOL states that the new owner account cannot "become the owner of the current database if it already has access to the database through an existing alias or...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 31, 2005 at 8:04 am
Good call, I should have thought of sqldts.com... This article details one method of doing this. It's a bit different than what I suggested, but I didn't provide the code /***************** If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek *****************/
March 30, 2005 at 5:36 pm
Roughly, you could create a step that checks for the existence of a file in the directory. If a file exists read the first file name into a global variable. ...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 30, 2005 at 2:26 pm
Actually, TRUNCATE is logged, and it can be rolled back. DELETE operations log the deletion of each row, while TRUNCATE logs the dealocation of data pages. This is a very common...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 30, 2005 at 11:09 am
The SQL Server service account needs read access to the directory in question.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 30, 2005 at 11:03 am
Viewing 15 posts - 601 through 615 (of 824 total)