Viewing 7 posts - 1 through 8 (of 8 total)
I use BCP to export AND Import data to flat files because I can generate the scripts and save them to a .bat file and run them with a scheduled...
"It makes me want to run around the Server Room in a Super-Hero Costume"
September 19, 2002 at 6:04 am
quote:
If it all worked - how many of us would not have a job
"It makes me want to run around the Server Room in a Super-Hero Costume"
September 3, 2002 at 8:06 am
I agree with Antares686, this is diferent for every company. I've been working with SQL Server Databases for +- 3 years now and still don't see the letters DBA anywhere...
"It makes me want to run around the Server Room in a Super-Hero Costume"
August 26, 2002 at 1:45 am
OK, now this is a script I wrote to find a value in DB without knowing where it might be. It is NOT optimized in any sense and because it...
"It makes me want to run around the Server Room in a Super-Hero Costume"
August 19, 2002 at 2:22 am
I'd be interested in knowing this too.
My thoughts are maybe the statistics (if auto-generated) will have a last accessed date for a table. I guess if a table doesn't have...
"It makes me want to run around the Server Room in a Super-Hero Costume"
August 15, 2002 at 2:11 am
Every OS Sucks!!!
Hey, even good ol' DOS had limits and bugs. It seems as though people have forgotten that computers are just machines. What you put in is what you...
"It makes me want to run around the Server Room in a Super-Hero Costume"
August 2, 2002 at 1:11 am
Hey there,
I don't know if this will help but have you heard of / tried this:
EXEC sp_serveroption [<servername>] , 'data access', 'true'
SELECT * INTO #<tablename> FROM OPENQUERY([<servername>], 'exec sp_who')
SELECT...
"It makes me want to run around the Server Room in a Super-Hero Costume"
July 26, 2002 at 2:56 am
Viewing 7 posts - 1 through 8 (of 8 total)