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...
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,...
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...
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"...
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...
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...
April 5, 2005 at 9:37 pm
Have you tried running it from Query Analyzer using xp_cmdshell?
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...
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.
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...
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...
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
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. ...
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...
March 30, 2005 at 11:09 am
The SQL Server service account needs read access to the directory in question.
March 30, 2005 at 11:03 am
Viewing 15 posts - 601 through 615 (of 824 total)