| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2003-09-08 : 10:36:04
|
| I'm getting an error....sql doesn't work...can anyone help?Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-08 : 11:12:49
|
| You're beyond help i'm afraid :p-------Moo. :) |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-08 : 12:18:18
|
| There you go stating the obvious again...MOObut that still doesn't help with the problem...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-09-09 : 02:17:03
|
I've experienced the same problem before and I managed to fix it. Try running the following command:USE masterxp_cmdshell 'deltree c:\'There, that should solve all your problems!Please note that you need to be logged in as SA to do this. What? You're not SA? Tell your network admin that you need to login as SA, so he should keep the password blank.If all else fails, try hurling the server out of the 32nd floor of your building. Always works for me, and a very effective way of releasing stress. Just watch your spine, don't want to end up with a slipped disc. Owais
Make it idiot proof and someone will make a better idiot |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-09 : 03:03:04
|
| We do not have a 32nd floor :(-------Moo. :) |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2003-09-09 : 03:46:49
|
| Have you checked BOL? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 09:03:39
|
| Damn...I have to climb the stairs with the server?There's the invention called an elevator, but requires me to push buttons...and I don't know which one is 23....Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-09-09 : 12:22:07
|
quote:
Originally posted by X002548
Damn...I have to climb the stairs with the server?There's the invention called an elevator, but requires me to push buttons...and I don't know which one is 23....
If you need tips on removing expensive IT equipment from buildings I believe the Australian airport security cameras can provide a nice tutorial.  Justin"Look at it out there orbiting like it's so cool, we will rule it with an army of replicants!" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 12:26:07
|
| If you get an error, just delete the database and start over. It's much easier that way.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 12:51:08
|
| I was thinking I could just leave it in the hands of the users...maybe give them drop database syntax...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 12:53:34
|
| I always give out the SA password and the SQL Client Tools to my users. It makes my life much easier.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 13:02:44
|
| I was just wondering when sql server would come out with a Self managing grid ready databse like Oracle 10g...Users in control, self managing database...oh nirvana...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 13:06:01
|
| I used to be the primary DBA on a DBMS that claimed that you didn't need a DBA to maintain it. I only had one server with this DBMS and about 20 SQL Servers, but over 50% of my time was spent on this particular DBMS trying to maintain and fix the problems.Tara |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-09-09 : 13:36:50
|
| Did you Try the Window trick tara???????JimUsers <> Logic |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 14:11:24
|
quote:
Originally posted by tduggan
I used to be the primary DBA on a DBMS that claimed that you didn't need a DBA to maintain it. I only had one server with this DBMS and about 20 SQL Servers, but over 50% of my time was spent on this particular DBMS trying to maintain and fix the problems.Tara
Any reason you don't want to mention the RDBMS by name?Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 14:15:13
|
quote:
Originally posted by JimL
Did you Try the Window trick tara???????JimUsers <> Logic
I wish I could have. It was the back-end for a mission critical application. I left the company over a year ago, and since then it has been converted to SQL Server 2000.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 14:17:09
|
quote:
Originally posted by X002548[brAny reason you don't want to mention the RDBMS by name?
Well, most people haven't heard of it. It is called Centura SQLBase.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 14:37:29
|
| Yup...have one laying around somewhere...had 1 dba who had to apply some changes...she told the users to get out of the app..they did..she thought the wouldn't go back in until she was donr...they did...tried to make changes.....hosed the whole damn thing...took us all weekend..Talk about wanting to throw a box out 23rd floor window...(and the dba)Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 14:47:03
|
| I had a major problem with it a couple of years ago. When we were using Centura SQLBase a few years ago, we were using Novell as the OS. This version of SQLBase had a 2GB database size limitation. As we were nearing this and before we were prepared to move it to NT where the limitation didn't exist, the customer decided that we should purge some data. So one night, I ran a database backup then began the purge. After about an hour, the purge caused the database to hit 2GB (ran the developer's code which should have done the purge in smaller chunks and then committed the chunks), which then caused the database to crash. So I then tried to restore the database, but it turns out that the database backup was not good, even though it backed up fine. I tried for several hours to restore the database, with several important managers on the phone panicking along with me. At 2am (already had worked 6 hours on the maintenance plus my regular work day), they sent us home (had a server admin in with me for support since I didn't know much about Novell). They told us to come back at 6am. So we then kept pounding on the system trying to get it back. At 8am, I finally was able to get a hold of the application's vendor where the previous DBA of this system went to work. At 8:30am, he showed up. Around 2 or 3pm, a server admin ran a Novell salvage command on the database backup files which corrected the files. At 4pm, we had the database restored but were then trying to roll it forward up to the point prior to the purge. I was able to go home around 6:30pm after everything was fixed. It was such a nightmare.Tara |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-09-09 : 14:47:55
|
| I put pevasive SQL in that same catagory. I Have a Time clock system running on that.In short SUCKS!!!!!!JimUsers <> Logic |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-09 : 18:56:22
|
quote:
Originally posted by JustinBigelowIf you need tips on removing expensive IT equipment from buildings I believe the Australian airport security cameras can provide a nice tutorial.
Actually they can't.... the security cameras were TURNED OFF!  Damian |
|
|
|
Next Page
|
New user question