Viewing 15 posts - 27,436 through 27,450 (of 39,800 total)
A few of the 2008 exams went through a beta cycle, a few more starting soon.
I'd think the 2005 exams will be around for 2-3 more years, and most of...
August 14, 2008 at 8:16 am
END added to the code.
August 14, 2008 at 8:14 am
In SQL 2000, I know we had to loop through users and KILL their processes. However I thought Ss2K5 would force users off after a short delay. The documentation specifies...
August 14, 2008 at 8:13 am
On the advanced tab, you can specify logging. You can also choose to have step 1 end the job if it succeeds. If it fails have it go to step...
August 14, 2008 at 8:10 am
Can you post the exact text? This might be a system table/area.
If you are getting errors, they are almost always hardware related. If this is a production system, I wouldn't...
August 14, 2008 at 7:58 am
If the orderdate is the correct time item, the MAX() should give you what you need.
If it doesn't, please show some data and explain what's not right.
August 14, 2008 at 7:57 am
I think they should if they will to trace code. However they should be careful not to make sysadmin type changes if they have rights.
August 14, 2008 at 7:49 am
I'd go with that advice for now. Start reading about Oracle, maybe buy a book and start learning.
August 14, 2008 at 7:44 am
Actually I think martial arts, when done at a high level, is more mental than physical. One of the reasons I got out of it years ago is that I...
August 14, 2008 at 7:22 am
I've updated the question to show partial scan with the plain yes answer and awarded back points.
August 14, 2008 at 7:05 am
Are you sure the FK is disabled? Please post some code.
Could there be another FK on the table?
August 14, 2008 at 6:08 am
A blanket rebuild isn't necessary for most tables, but it is easier to set up and I've typically run it. 8-9GB isn't a lot of space. Can you not spare...
August 13, 2008 at 12:51 pm
There are some third party products to do this, and I think we have some scripts here as well.
August 13, 2008 at 12:46 pm
Windows firewall?
August 13, 2008 at 12:46 pm
Viewing 15 posts - 27,436 through 27,450 (of 39,800 total)