Viewing 15 posts - 181 through 195 (of 589 total)
Personally I am convinced that most people that admin SAN's do not understand the technology they are working with and that is why they refuse to answer....
December 3, 2007 at 9:44 am
What makes you think the table is stuck?
The table only exists for the connection that made the temp table, and should go away when that connection is closed...
December 3, 2007 at 9:41 am
Problem with the BMW 1-Series in the US is that we start with the 3 liter I-6 from the 328, and the car is relatively heavy for such a small...
November 28, 2007 at 5:17 am
Not very fance at all, using xp_cmdshell 🙂 We considered making it into a CLR, but neither him or I am completely comfortable opening up that can of worms...
November 2, 2007 at 10:11 am
Solution found 😉
Make my own (well, one of our programmers did) C# program that will do what I want. Guess I could have made a CLR program...
November 2, 2007 at 6:29 am
Dynamic SQL maybe? I would propably make a function that took the DBid and the ObjectID and return the name using it.
November 1, 2007 at 12:51 pm
Just made a SQL backup on one server, copied the file to another SQL server. The XP_Delete_file removed it just fine.
November 1, 2007 at 11:32 am
It's on SP2, and I tried it with the same extension name as well.
Before running my delete statement right now I have two files in a directory:
AndersTest.bak backed up with...
November 1, 2007 at 6:40 am
I did some more testing this morning.... Looks like that XP only deletes files that where created by a SQL maintenance plan, or by SQL native backups. Guess that...
October 31, 2007 at 9:23 am
There are 2 applications in for new reactors as of yesterday (10/29/2007) in the US, and 14 more applications expected to be filed in 2008. Good thing IMO. ...
October 30, 2007 at 6:23 am
You must have Cobol developers on your staff! Man we get that stuff all over the place around here, but I refuse to let them store it in that...
October 25, 2007 at 3:24 pm
Bachelor of Science in Aeronautical Studies (read: commercial flying), with a minor in Computer Science.
Also hold a license for flying fixed wing aircraft, all but ATP rating and floats....
I always...
October 19, 2007 at 6:34 am
Man I want to work where Rhat works! Imagine the utopia of perfectly designed databases, servers, hardware. Never had to figure out why you suddenly are starting to...
October 16, 2007 at 2:01 pm
The only time I saw the code (small part of it) it seemed to me it was in C and Assembler, but that was for SQL 6.5. 😉
October 16, 2007 at 8:54 am
Viewing 15 posts - 181 through 195 (of 589 total)