Viewing 15 posts - 37,441 through 37,455 (of 39,456 total)
AFAIK, you have to do this with some application. The Services applet in Control Panel is the most frequently used one. There might be a command line as well.
Steve...
May 24, 2002 at 9:26 am
You would use a text or binary column and do a standard insert. You might need to replace some items, like single quotes within your file.
Once inserted, you can query...
May 22, 2002 at 1:28 pm
May 22, 2002 at 1:25 pm
Good advice above. Keep in mind when explaining that the KISS principle also helps maintain a stable environment. This tends to violate that.
Steve Jones
May 22, 2002 at 1:23 pm
I saw somethign similar and it was a client installation issue. You might try reinstalling the client tools.
Also, what SP?
Steve Jones
May 22, 2002 at 1:20 pm
I don't think there is anything. You could develop some audit item if you switched to stored procedures that would capture the spid.
Profiler will do this, but that might be...
May 22, 2002 at 1:19 pm
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
Viewing 15 posts - 37,441 through 37,455 (of 39,456 total)