Viewing 15 posts - 37,501 through 37,515 (of 39,510 total)
Not sure what is wrong. That's kind of strange. Could the .bat already be executing and a lock on that file?
Steve Jones
May 22, 2002 at 1:17 pm
Oh this makes me long for v6.5 in some ways.
First, Antares is right. Reread his post, twice, before you make any decision. then, here are a couple suggestions.
System table trigger...
May 20, 2002 at 9:34 pm
I agree with Antares. This is the best way to set this up and modularize the code. You might even resuse some of the individual sprocs for something else.
Steve Jones
May 20, 2002 at 9:22 pm
select a.cola + b.cola + c.cola
from tableA a
inner join tableA b
on a.something = b.something
...
Steve Jones
May 20, 2002 at 4:05 pm
What objects are still there? Is this the first filegroup? If so, you cannot drop it. It will have the system tables in it.
Steve Jones
May 20, 2002 at 2:49 pm
Lumigent it the best option. There is a DBCC option to read the log, but it isn't pretty and you will need to do lots of decoding to figure out...
May 20, 2002 at 10:01 am
Are your browsing? If the extension is not the same, it won't appear. Try copying to the root of a drive and manually typing the file name in.
Steve Jones
May 20, 2002 at 10:00 am
That works, but I'd do
select
case when len ( cola) > 10
then colA
else null
end 'colA'
Steve...
May 20, 2002 at 9:57 am
Do you have some knowledge of what new stuff goes into Table A?
Actually it doesn't matter. Do an update join on the tables using the PK. Anything that matches will...
May 20, 2002 at 9:56 am
Rebuild the pacakge. I suspect something is corrupt. If you still get this, try it on another client station.
Steve Jones
May 20, 2002 at 9:54 am
I've started seeing a few jobs in Denver asking for the MCDBA cert, but not many. I think this is mainly to limit the number of resumes from people.
I...
May 20, 2002 at 9:51 am
Haven't heard that, but I did hear that Stored procedure can be written in VB.NET, C#.NET, etc. IMHO a bad idea. Fundamental differences between the languages (set v row based)....
May 20, 2002 at 9:44 am
Agree. There isn't a way to do this (other than dynamic sql, which I don't recommend). Besides, that's what CTRL-C, CTRL-V are for 🙂
Steve Jones
May 20, 2002 at 9:43 am
I tend to be biased towards SQL Server, but Antares has great points.
Oracle is regarded as a more scalable and mission critical product. It has a better track record, but...
May 20, 2002 at 9:41 am
Tough to audit everything. Lumigent provides a product that reads the logs, which will capture most of this if not all. You can also run profiler, but that will be...
May 20, 2002 at 9:37 am
Viewing 15 posts - 37,501 through 37,515 (of 39,510 total)